Re: [Linux-cluster] MySQL MASTER->SLAVE agent?

2011-02-21 Thread Andrew Beekhof
On Sat, Feb 19, 2011 at 1:36 AM, Jakov Sosic wrote: > Hi. > > Would it be possible to use the MySQL replication as a way of achieving HA? > > When MASTER is down to take appropriate actions and declare SLAVE the > NEW master, and take on IP address? That would be tricky for rgmanager since it doe

Re: [Linux-cluster] MySQL MASTER->SLAVE agent?

2011-02-19 Thread Cleber Rosa
On 02/19/2011 08:22 AM, Dan Candea wrote: On 19.02.2011 03:05, Cleber Rosa wrote: On 02/18/2011 10:36 PM, Jakov Sosic wrote: Hi. Would it be possible to use the MySQL replication as a way of achieving HA? When MASTER is down to take appropriate actions and declare SLAVE the NEW master, and

Re: [Linux-cluster] MySQL MASTER->SLAVE agent?

2011-02-19 Thread Dan Candea
On 19.02.2011 03:05, Cleber Rosa wrote: On 02/18/2011 10:36 PM, Jakov Sosic wrote: Hi. Would it be possible to use the MySQL replication as a way of achieving HA? When MASTER is down to take appropriate actions and declare SLAVE the NEW master, and take on IP address? Has anyone tested this

Re: [Linux-cluster] MySQL MASTER->SLAVE agent?

2011-02-18 Thread Cleber Rosa
On 02/18/2011 10:36 PM, Jakov Sosic wrote: Hi. Would it be possible to use the MySQL replication as a way of achieving HA? When MASTER is down to take appropriate actions and declare SLAVE the NEW master, and take on IP address? Has anyone tested this kind of setup? Obviously, failback should b

[Linux-cluster] MySQL MASTER->SLAVE agent?

2011-02-18 Thread Jakov Sosic
Hi. Would it be possible to use the MySQL replication as a way of achieving HA? When MASTER is down to take appropriate actions and declare SLAVE the NEW master, and take on IP address? Has anyone tested this kind of setup? Obviously, failback should be impossible and request manual action. This