[ClusterLabs] MySQL resource causes error "0_monitor_20000".

[Kiwamu Okabe]

Hi,

On Tue, Aug 18, 2015 at 5:07 PM, Kiwamu Okabe <kiwamu at 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
> --replicate-same-server-id option must be used on slave but this does
> not always make sense; please check the manual before using it).
> Error_code: 1593
> ```

I fixed it, and get following settings;

```
centillion.db01# mysql> show slave status\G
...
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
...
centillion.db01# mysql> stop slave;
centillion.db02# mysql> start slave;
centillion.db02# mysql> show slave status\G
...
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
...
```

But the error message of crm is not changed...

```
============
Last updated: Tue Aug 18 17:41:48 2015
Stack: Heartbeat
Current DC: centillion.db02 (0302e3d0-df06-4847-b0f9-9ebddfb6aec7) -
partition with quorum
Version: 1.0.13-a83fae5
2 Nodes configured, unknown expected votes
2 Resources configured.
============

Online: [ centillion.db01 centillion.db02 ]

vip_192.168.10.200      (ocf::heartbeat:IPaddr2):       Started centillion.db01
 Master/Slave Set: mysql-clone
     mysql:1    (ocf::heartbeat:mysql): Master centillion.db02 FAILED
     Masters: [ centillion.db01 ]

Failed actions:
    mysql:1_monitor_20000 (node=centillion.db02, call=26, rc=8,
status=complete): master
    mysql:1_monitor_30000 (node=centillion.db02, call=27, rc=8,
status=complete): master
```

Thank's,
-- 
Kiwamu Okabe at METASEPI DESIGN