Re: [Pacemaker] MySQL not starting

2012-06-08 Thread Yves Trudeau
Hi, please use the latest version of the agent and look here for documentation: https://github.com/jayjanssen/Percona-Pacemaker-Resource-Agents/blob/master/doc/PRM-setup-guide.rst Regards, Yves Le 2012-05-16 08:29, Stallmann, Andreas a écrit : Hi! I try to get a mysql master / slave set

Re: [Pacemaker] MySQL not starting

2012-06-08 Thread Yves Trudeau
Hi, the agent does a RESET SLAVE now and check for master log file afterward. I think this is handled correctly. Regards, Yves Le 2012-05-29 10:19, Stallmann, Andreas a écrit : Hi! MySQL has changed CHANGE MASTER TO syntax in 5.1 (IIRC), and it won't accept an empty host argument anymo

Re: [Pacemaker] MySQL not starting

2012-06-01 Thread Sabin Iacob
On 29 May 2012 17:19, Stallmann, Andreas wrote: > Hi! > > > MySQL has changed CHANGE MASTER TO syntax in 5.1 (IIRC), and it won't > accept > > an empty host argument anymore. I had to manually patch the RA to use > '-' as the host argument if it's empty. > > Did you send your patch to Yves? Yves,

Re: [Pacemaker] MySQL not starting

2012-05-29 Thread Stallmann, Andreas
Hi! > MySQL has changed CHANGE MASTER TO syntax in 5.1 (IIRC), and it won't accept > an empty host argument anymore. I had to manually patch the RA to use '-' as > the host argument if it's empty. Did you send your patch to Yves? Yves, did you include this patch in the newest resource agent? C

Re: [Pacemaker] MySQL not starting

2012-05-18 Thread Taneli Leppä
On 16.5.12 15:29, Stallmann, Andreas wrote: I find nothing of any (obvious) relevance in /var/log/syslog besides May 16 13:27:20 proto-cms-appl01 mysql[1300]: ERROR: ERROR 1210 (HY000) at line 1: Incorrect arguments to MASTER_HOST May 16 13:27:20 proto-cms-appl01 mysql[1300]: ERROR: Failed to set

Re: [Pacemaker] MySQL not starting

2012-05-17 Thread Yves Trudeau
Hi Andreas, make sure the pid defined in pacemaker is the same has the one define in /etc/mysql/my.cnf. Although it may not be that since you have the replication info set. Have you verified that MySQL is indeed not running? maybe you just forgot to cleanup the errors. The updated version

[Pacemaker] MySQL not starting

2012-05-16 Thread Stallmann, Andreas
Hi! I try to get a mysql master / slave setup running, according to http://www.e-rave.nl/prm-mysql-ha-and-pacemaker-in-the-mix. I had this setup running already, but now as we are switching from SLES to Ubuntu, I have to set it up anew. Here’s the primitive for mysql: primitive p_mysql ocf:he