On 06/01/07 19:17, Joshua D. Drake wrote:
> Ron Johnson wrote:
>> On 06/01/07 18:35, Joshua D. Drake wrote:
>>>>
>>>> Since DDL is infrequent, is that bottleneck an acceptable trade-off?
>>>
>>> Define infrequent? I have customers that do it, everyday in prod.
>>> They do it willingly and refuse to change that habit.
>>
>> Even 2 or 3 ALTER TABLE or CREATE INDEX or CREATE TABLE statements per
>> day is a drop in the bucket compared to the number of I/U/D
>> statements, no?
>
> True.
So Alexander Staubo's idea of synchronous DDL replication via 2PC
has some merit?
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!