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" <[email protected]> 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" <[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
