Re: [Postgres-xc-general] Corosync Resource configuration for Postgres-XC

[Koichi S. <koi...@gm...>]

Hello;

I just know general thing about DRBD, Corosync and Pacemaker so I'd like to
post my comment with a question of DRBD basics.

First of all, I have one important questions on DRBD basics:

Does DRBD send all the update to slaves in synchronous manner, or is there
any chance that DRBD slave fails to receive some of the updates at the
master?

If you cannot configure DRBD update backup synchronously, we may have some
consistent issue among the data stored in different datanodes.

The background is:

Postgres-XC assumes consistency of data stored in all the coordinators and
datanodes.    If some coordinator/datanode fails and is switched to the
slave, the slave must not lose any commits done to the master.

This is the same in the case of log-shipping replication and this is why I
advise to use synchronized replication.

If you can keep slave in sync with the master, then what you should do is
to start Postgres-XC component at the slave.

Thank you very much;

---
Koichi Suzuki
https://www.linkedin.com/in/koichidbms


2015-08-26 16:12 GMT+09:00 ssoorruu <sso...@gm...>:

> Dear fellow PGXC enthusiasts,
>
> Good day and I hope you're all doing well, especially with Postgres-XC :)
>
> I have job to deploy Postgres-XC cluster replication using DRBD, and
> cluster resource manager using Corosync-Pacemaker.
> I've followed the tutorial from this link:
>
> https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5
>
> But I cannot understand how to configure a Corosync resource for
> Postgres-XC.
>
> Does anyone can give me tutorial on how to do Postgres-XC with
> Corosync-Pacemaker?
>
> Very appreciate and thank you in advance.
>
>
> Regards,
> FattahRozzaq
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>