As Patrick pointed here: http://serverfault.com/questions/405982/mysql-pacemaker-cannot-start-the-failed-master-as-a-new-slave
I need to set the additional variables to tells the script its a master/slave resource. So, I've appended the following variables to my |~/.bash_profile|: |export OCF_RESKEY_CRM_meta_clone_max="2" export OCF_RESKEY_CRM_meta_role="Slave"| Make it take effect |. ~/.bash_profile| and manually start mysql resource: |sh -x /usr/lib/ocf/resource.d/percona/mysql start|: http://fpaste.org/EMwa/ and it works fine: |mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.6.38 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000072 Read_Master_Log_Pos: 1428602 Relay_Log_File: mysqld-relay-bin.000006 Relay_Log_Pos: 39370 Relay_Master_Log_File: mysql-bin.000072 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1428602 Relay_Log_Space: 39527 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 123 1 row in set (0.00 sec)| I've been turing on the debug, stop corosync and restart, here're the logs: http://fpaste.org/mZzS/ As you can see, nothing details than 'unknown error': 1. Jul 13 10:48:06 serving-6192 crmd: [3341]: debug: get_xpath_object: No match for //cib_update_result//diff-added//crm_config in /notify/cib_update_result/diff 2. Jul 13 10:48:06 serving-6192 lrmd: [3338]: WARN: Managed p_mysql:1:start process 3416 exited with return code 1. 3. Jul 13 10:48:06 serving-6192 crmd: [3341]: info: process_lrm_event: LRM operation p_mysql:1_start_0 (call=4, rc=1, cib-update=10, confirmed=true) unknown error Any thoughts? On 07/10/2012 09:27 AM, quanta wrote: > > On 07/10/2012 05:08 AM, Andreas Kurz wrote: >> and you also use the latest mysql RA from resource-agents github? > Yes. >> Not enough logs ... at least for me ... to give more hints. Regards, >> Andreas > Sorry, here for you: http://fpaste.org/AyOZ/
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
