Ron Johnson wrote:
On 06/01/07 17:31, Andrew Sullivan wrote:
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
Could you not (I ask naively) detect the first DDL statement is
submitted in a transaction
Maybe.
on the master, then start a transaction on
each slave, then funnel this and all subsequent statements
synchronously to every nodes, then prepare and commit everyone?
You could if 2PC was ubiquitous, which is certainly wasn't when the
code was designed (remember, it was originally compatible all the way
back to 7.3). Some people suggested using 2PC "if it's there", but
that just seems to me to be asking for really painful problems. It
also entails that all DDL has to happen on every node at the same
time, which imposes a bottleneck not actually currently in the
system.
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.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
