Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-04 Thread Andrew Beekhof
On Fri, Nov 2, 2012 at 7:03 PM, Andrew wrote: > On 02/11/12 01:02, Andrew Beekhof wrote: >> >> On Fri, Nov 2, 2012 at 2:34 AM, Andrew wrote: >>> >>> On 01/11/12 03:02, Andrew Beekhof wrote: On Thu, Nov 1, 2012 at 5:27 AM, Andrew wrote: > > Hi all. > I try to build 1+1 MySQ

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-02 Thread Andrew
Thanks, I'll read this. On 02/11/12 10:23, Denny Schierz wrote: Am 02.11.2012 um 09:06 schrieb Andrew: Hi. Thanks for config, but is there a possibility to avoid DRBD usage for postgres? DB on top of DRBD may be broken if master fails at DB write (because write isn't atomic process). yes,

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-02 Thread Denny Schierz
Am 02.11.2012 um 09:06 schrieb Andrew : > Hi. > Thanks for config, but is there a possibility to avoid DRBD usage for > postgres? DB on top of DRBD may be broken if master fails at DB write > (because write isn't atomic process). yes, there is a way: replication. You can use replication for P

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-02 Thread Andrew
Hi. Thanks for config, but is there a possibility to avoid DRBD usage for postgres? DB on top of DRBD may be broken if master fails at DB write (because write isn't atomic process). On 01/11/12 23:40, Denny Schierz wrote: hi, one example config from my testcases: = primitive

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-02 Thread Andrew
On 02/11/12 01:02, Andrew Beekhof wrote: On Fri, Nov 2, 2012 at 2:34 AM, Andrew wrote: On 01/11/12 03:02, Andrew Beekhof wrote: On Thu, Nov 1, 2012 at 5:27 AM, Andrew wrote: Hi all. I try to build 1+1 MySQL HA cluster, and currently I'm looking on Percona replication manager; other variant

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-01 Thread Andrew Beekhof
On Fri, Nov 2, 2012 at 2:34 AM, Andrew wrote: > On 01/11/12 03:02, Andrew Beekhof wrote: >> >> On Thu, Nov 1, 2012 at 5:27 AM, Andrew wrote: >>> >>> Hi all. >>> I try to build 1+1 MySQL HA cluster, and currently I'm looking on Percona >>> replication manager; other variant - to write own OCF for

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-01 Thread Denny Schierz
hi, one example config from my testcases: = primitive drbd-mysql ocf:linbit:drbd \ params drbd_resource="mysql" \ operations $id="drbd-mysql-operations" \ op monitor start-delay="0" interval="31" \ meta is-managed="true" primitive drbd-postgres ocf:

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-11-01 Thread Andrew
On 01/11/12 03:02, Andrew Beekhof wrote: On Thu, Nov 1, 2012 at 5:27 AM, Andrew wrote: Hi all. I try to build 1+1 MySQL HA cluster, and currently I'm looking on Percona replication manager; other variant - to write own OCF for semi-synchronous master-slave replication. Also I want to run here P

Re: [Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-10-31 Thread Andrew Beekhof
On Thu, Nov 1, 2012 at 5:27 AM, Andrew wrote: > Hi all. > I try to build 1+1 MySQL HA cluster, and currently I'm looking on Percona > replication manager; other variant - to write own OCF for semi-synchronous > master-slave replication. Also I want to run here PostgreSQL HA DB. > So I have some qu

[Pacemaker] MySQL/PostgreSQL HA cluster with Pacemaker

2012-10-31 Thread Andrew
Hi all. I try to build 1+1 MySQL HA cluster, and currently I'm looking on Percona replication manager; other variant - to write own OCF for semi-synchronous master-slave replication. Also I want to run here PostgreSQL HA DB. So I have some questions: 1) How pacemaker decides what node should b