[Pgpool-general] Generate UUID with pgpool-II

[Lazaro Ruben Garcia Martinez]

The reason why Pgpool-II selects a master node is for continue the service if a node fails, but this has nothing to do with multi-master technique. Really? 

Sorry for my questions, but this was a doubt that a I had long ago and thank you for answer them. 
Regards. 


----- "Tatsuo Ishii" <ishii at sraoss.co.jp> escribió: 
> > 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" <ishii at sraoss.co.jp> 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 
> >> 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110303/0d16f3aa/attachment.html>