Re: [ClusterLabs] MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi Andrei, On Tue, Aug 18, 2015 at 2:24 PM, Andrei Borzenkov arvidj...@gmail.com wrote: I made master-master replication on Pacemaker. But it causes error 0_monitor_2. It's not an error, it is just operation name. Sorry. I'm comfused. If one of them boots Heartbeat and another doesn't,

Re: [ClusterLabs] MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi, On Tue, Aug 18, 2015 at 5:07 PM, Kiwamu Okabe kiw...@debian.or.jp wrote: ``` 2015-08-18 16:50:38 7081 [ERROR] Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the

Re: [ClusterLabs] MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Andrei Borzenkov
On Tue, Aug 18, 2015 at 9:15 AM, Kiwamu Okabe kiw...@debian.or.jp wrote: Hi Andrei, On Tue, Aug 18, 2015 at 2:24 PM, Andrei Borzenkov arvidj...@gmail.com wrote: I made master-master replication on Pacemaker. But it causes error 0_monitor_2. It's not an error, it is just operation name.

Re: [ClusterLabs] MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi Andrei, On Tue, Aug 18, 2015 at 3:58 PM, Andrei Borzenkov arvidj...@gmail.com wrote: How to shape nodes such like above? Did you setup mySQL replication before bringing it under pacemaker control? If not, my guess is that resource agent sees both instances as independent and hence

Re: [ClusterLabs] Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi Ulrich, On Tue, Aug 18, 2015 at 9:34 PM, Ulrich Windl ulrich.wi...@rz.uni-regensburg.de wrote: I feel the message Aug 18 18:21:35 centillion.db01 lrmd: [15607]: info: RA output: (mysql:0:promote:stderr) Error performing operation: The object/attribute does not exist is a problem (why

[ClusterLabs] Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Ulrich Windl
Kiwamu Okabe kiw...@debian.or.jp schrieb am 18.08.2015 um 11:48 in Nachricht CAEvX6dky8=_w6l2nhndfbowux+ol7ktaa44salru7a9-xed...@mail.gmail.com: Hi Andrei, On Tue, Aug 18, 2015 at 6:28 PM, Andrei Borzenkov arvidj...@gmail.com wrote: You should attach full logs from both nodes starting with

Re: [ClusterLabs] Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Andrei Borzenkov
On Tue, Aug 18, 2015 at 3:34 PM, Ulrich Windl ulrich.wi...@rz.uni-regensburg.de wrote: Kiwamu Okabe kiw...@debian.or.jp schrieb am 18.08.2015 um 11:48 in Nachricht CAEvX6dky8=_w6l2nhndfbowux+ol7ktaa44salru7a9-xed...@mail.gmail.com: Hi Andrei, On Tue, Aug 18, 2015 at 6:28 PM, Andrei

Re: [ClusterLabs] upgrade from 1.1.9 to 1.1.12 fails to start

2015-08-18 Thread Digimer
On 18/08/15 10:15 AM, Streeter, Michelle N wrote: I created a whole new virtual and installed everything with the new version and pacemaker wouldn’t start. I have not yet learned how to use the logs yet to see what they have to say. No, I did not upgrade corosync. I am running the latest

Re: [ClusterLabs] Mysql M/S, binlogs - how to delete them safely without failing over first?

2015-08-18 Thread Brett Moser
Hi Attila, It sounds like on failover the new slave is not having it's master replication file position updated. What Resource Agent are you using to control the M/S mysql resource? Have you investigated the Percona agent? I performs the CHANGE MASTER TO commands for you, and I have found it

Re: [ClusterLabs] Antw: Re: Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi, On Wed, Aug 19, 2015 at 12:08 PM, Kiwamu Okabe kiw...@debian.or.jp wrote: I tried to find ocf-tester command but not found. And resource-agents package is also not installed! It's miss understanding. Package resource-agents is already installed. But ocf-tester command is not found...

Re: [ClusterLabs] Antw: Re: Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Kiwamu Okabe
Hi Ulrich, On Tue, Aug 18, 2015 at 10:43 PM, Ulrich Windl ulrich.wi...@rz.uni-regensburg.de wrote: I haven't looked there, but there should be a manual page (ocf-tester(8)). I use it like this: -- /usr/sbin/ocf-tester -n your_resource_name \ -o param1=value1 \ ... path_to_RA -- When

Re: [ClusterLabs] MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Andrei Borzenkov
On Tue, Aug 18, 2015 at 11:57 AM, Kiwamu Okabe kiw...@debian.or.jp wrote: Hi, On Tue, Aug 18, 2015 at 5:07 PM, Kiwamu Okabe kiw...@debian.or.jp wrote: ``` 2015-08-18 16:50:38 7081 [ERROR] Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids;

Re: [ClusterLabs] upgrade from 1.1.9 to 1.1.12 fails to start

2015-08-18 Thread Streeter, Michelle N
I created a whole new virtual and installed everything with the new version and pacemaker wouldn't start. I have not yet learned how to use the logs yet to see what they have to say. No, I did not upgrade corosync. I am running the latest which will work with rhel6. When I tried later versions,

[ClusterLabs] Antw: Re: Antw: Re: MySQL resource causes error 0_monitor_20000.

2015-08-18 Thread Ulrich Windl
Kiwamu Okabe kiw...@debian.or.jp schrieb am 18.08.2015 um 14:55 in Nachricht caevx6dnufyi7_dgd4dxbmxb0ptznspxiaxumymqjj5f2b6h...@mail.gmail.com: Hi Ulrich, On Tue, Aug 18, 2015 at 9:34 PM, Ulrich Windl ulrich.wi...@rz.uni-regensburg.de wrote: I feel the message Aug 18 18:21:35