> Thank you very much for your answer, but now I write you because I have a > conceptual doubt about pgpool-II. Is pgpool-II only a statement-based > replication middleware?
Yes, pgpool-II is definitely statement based. Though I prefer to use the term "query based replication". Because "statement" is oversimply the fact which pgpool-II is doing. Think about extended protocol. A query can be consisted with multiple "statement" (prepare, bind, execute etc.) > I have this doubt because pgpool-II selects a master node, when failover is > performed and my confusion is between statement-based replication middleware > and multi-master tecniques. I don't understand your question here. "Multi-master" replication and query based replication are orthogonal concepts. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > Thank you very much for your time. > Regards. > > > ----- "Tatsuo Ishii" <[email protected]> escribió: >> > Hello everyone. I have a database than contain many field with uuid type. >> > Is there any way to generate an uuid by Pgpool-II in replication mode for >> > ensure that this value will be identical in all the nodes?? >> >> Currently I don't think of any way to replicate uuid >> data. Theoretically we could ask master node to generate uuid data >> then INSERT the value to other nodes. This is essentially same as the >> way timestamp support does. Of course this needs to patch pgpool. >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese: http://www.sraoss.co.jp >> _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
