[Pacemaker] Replication MYSQL does not work in pacemaker

Joe weester at hotmail.com
Mon Nov 7 20:42:17 UTC 2011


Hi
I try to configure simple two nodes(Master/Slave) MYSQL/DRBD/PACEMAKER 
with MYSQL replication but it does not work. Everytime I start 
mysql(M/S) RA,it won't start with these error below.  PLease help if you 
see if I am doing anything wrong ( attached crm configure show).  thank 
you.

( Failed actions:
     p_mysql:0_monitor_0 (node=mysqldrbd02, call=501, rc=5, 
status=complete): not installed
     p_mysql:1_monitor_0 (node=mysqldrbd01, call=251, rc=5, 
status=complete): not installed

Reconnecting...[root at mysqldrbd01 etc]# tail -f /var/log/messages
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: info: run_graph: 
====================================================
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition 
795 (Complete=6, Pending=0, Fired=0, Skipped=0, Incomplete=0, 
Source=/var/lib/pengine/pe-input-895.bz2): Complete
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: info: te_graph_trigger: 
Transition 795 is now complete
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition 
795 status: done - <null>
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS 
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov  7 14:33:13 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
Starting PEngine Recheck Timer
Nov  7 14:33:13 mysqldrbd01 cibadmin: [28166]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:33:13 mysqldrbd01 cibadmin: [28171]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:33:17 mysqldrbd01 lrmd: [8607]: info: RA output: 
(FAILOVER-ADDR:start:stderr) ARPING 192.168.1.160 from 192.168.1.160 
eth1 Sent 5 probes (5 broadcast(s)) Received 0 response(s)
Nov  7 14:33:33 mysqldrbd01 cibadmin: [28513]: info: Invoked: cibadmin -Ql
Nov  7 14:34:08 mysqldrbd01 cibadmin: [28974]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:34:08 mysqldrbd01 crm_resource: [28975]: info: Invoked: 
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v 
started
Nov  7 14:34:08 mysqldrbd01 crm_resource: [28986]: info: Invoked: 
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v 
started
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <cib admin_epoch="0" epoch="244" num_updates="24" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <configuration >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <resources >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <master id="ms_mysql" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <primitive id="p_mysql" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <meta_attributes id="p_mysql-meta_attributes" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <nvpair value="stopped" 
id="p_mysql-meta_attributes-target-role" />
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </meta_attributes>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </primitive>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </master>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </resources>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </configuration>
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: abort_transition_graph: 
need_abort:59 - Triggered transition abort (complete=1) : Non-status change
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </cib>
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting on 
change to admin_epoch
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <cib admin_epoch="0" epoch="245" num_updates="1" >
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC 
cause=C_FSA_INTERNAL origin=abort_transition_graph ]
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <configuration >
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: All 
2 cluster nodes are eligible to run resources.
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <resources >
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query 
1487: Requesting the current CIB: S_POLICY_ENGINE
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <master id="ms_mysql" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <primitive id="p_mysql" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <meta_attributes id="p_mysql-meta_attributes" >
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <nvpair value="started" 
id="p_mysql-meta_attributes-target-role" />
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </meta_attributes>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </primitive>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </master>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </resources>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </configuration>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </cib>
Nov  7 14:34:08 mysqldrbd01 cib: [8606]: info: cib_process_request: 
Operation complete: op cib_modify for section resources 
(origin=local/crm_resource/4, version=0.245.1): ok (rc=0)
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_pe_invoke_callback: 
Invoking the PE: query=1487, ref=pe_calc-dc-1320698048-1740, seq=1368, 
quorate=1
Nov  7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents: 
Archived previous version as /var/lib/heartbeat/crm/cib-29.raw
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_config: On 
loss of CCM Quorum: Ignore
Nov  7 14:34:08 mysqldrbd01 cib: [28988]: info: write_cib_contents: 
Wrote version 0.245.0 of the CIB to disk (digest: 
031a742e444fdb356e1d0657a8a1f516)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: unpack_config: Node 
scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0
Nov  7 14:34:08 mysqldrbd01 cib: [28988]: info: retrieveCib: Reading 
cluster configuration from: /var/lib/heartbeat/crm/cib.mHBHHN (digest: 
/var/lib/heartbeat/crm/cib.66XEVP)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: 
determine_online_status: Node mysqldrbd02 is online
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: 
determine_online_status: Node mysqldrbd01 is online
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: 
Operation DRBD:0_monitor_0 found resource DRBD:0 active on mysqldrbd02
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard 
error - p_mysql:0_monitor_0 failed with rc=5: Preventing ms_mysql from 
re-starting on mysqldrbd02
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: find_clone: 
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: 
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master mode 
on mysqldrbd01
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard 
error - p_mysql:1_monitor_0 failed with rc=5: Preventing ms_mysql from 
re-starting on mysqldrbd01
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: group_print:  
Resource Group: AP-CLUST
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: native_print:      
SRV-MOUNT       (ocf::heartbeat:Filesystem):    Started mysqldrbd01
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: native_print:      
FAILOVER-ADDR   (ocf::heartbeat:IPaddr2):       Started mysqldrbd01
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:  
Master/Slave Set: DRBD-DATA
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:      
Masters: [ mysqldrbd01 ]
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:      
Slaves: [ mysqldrbd02 ]
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:  Clone 
Set: PING-NET-CLONE
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:      
Started: [ mysqldrbd02 mysqldrbd01 ]
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: clone_print:  
Master/Slave Set: ms_mysql
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: short_print:      
Stopped: [ p_mysql:0 p_mysql:1 ]
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color: 
Promoting DRBD:1 (Master mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color: 
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color: 
Promoting DRBD:1 (Master mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color: 
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color: 
Resource p_mysql:0 cannot run anywhere
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: native_color: 
Resource p_mysql:1 cannot run anywhere
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: master_color: 
ms_mysql: Promoted 0 instances of a possible 1 to master
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource SRV-MOUNT     (Started mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource FAILOVER-ADDR (Started mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource DRBD:0        (Slave mysqldrbd02)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource DRBD:1        (Master mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource PING-NET:0    (Started mysqldrbd02)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource PING-NET:1    (Started mysqldrbd01)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource p_mysql:0     (Stopped)
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource p_mysql:1     (Stopped)
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [ 
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: unpack_graph: Unpacked 
transition 796: 0 actions in 0 synapses
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_te_invoke: Processing 
graph 796 (ref=pe_calc-dc-1320698048-1740) derived from 
/var/lib/pengine/pe-input-896.bz2
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: run_graph: 
====================================================
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition 
796 (Complete=0, Pending=0, Fired=0, Skipped=0, Incomplete=0, 
Source=/var/lib/pengine/pe-input-896.bz2): Complete
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: te_graph_trigger: 
Transition 796 is now complete
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition 
796 status: done - <null>
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS 
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov  7 14:34:08 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
Starting PEngine Recheck Timer
Nov  7 14:34:08 mysqldrbd01 pengine: [8609]: info: process_pe_message: 
Transition 796: PEngine Input stored in: /var/lib/pengine/pe-input-896.bz2
Nov  7 14:34:08 mysqldrbd01 cibadmin: [28990]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:34:21 mysqldrbd01 cibadmin: [29177]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:34:21 mysqldrbd01 crm_resource: [29178]: info: Invoked: 
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v 
stopped
Nov  7 14:34:23 mysqldrbd01 crm_resource: [29190]: info: Invoked: 
/usr/sbin/crm_resource --meta -t primitive -r p_mysql -p target-role -v 
stopped
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <cib admin_epoch="0" epoch="245" num_updates="1" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <configuration >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <resources >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <master id="ms_mysql" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <primitive id="p_mysql" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <meta_attributes id="p_mysql-meta_attributes" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - <nvpair value="started" 
id="p_mysql-meta_attributes-target-role" />
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </meta_attributes>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </primitive>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </master>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </resources>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </configuration>
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: abort_transition_graph: 
need_abort:59 - Triggered transition abort (complete=1) : Non-status change
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: - </cib>
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: need_abort: Aborting on 
change to admin_epoch
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <cib admin_epoch="0" epoch="246" num_updates="1" >
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_IDLE -> S_POLICY_ENGINE [ input=I_PE_CALC 
cause=C_FSA_INTERNAL origin=abort_transition_graph ]
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <configuration >
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: All 
2 cluster nodes are eligible to run resources.
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <resources >
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_pe_invoke: Query 
1488: Requesting the current CIB: S_POLICY_ENGINE
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <master id="ms_mysql" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <primitive id="p_mysql" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <meta_attributes id="p_mysql-meta_attributes" >
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + <nvpair value="stopped" 
id="p_mysql-meta_attributes-target-role" />
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </meta_attributes>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </primitive>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </master>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </resources>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </configuration>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: log_data_element: 
cib:diff: + </cib>
Nov  7 14:34:23 mysqldrbd01 cib: [8606]: info: cib_process_request: 
Operation complete: op cib_modify for section resources 
(origin=local/crm_resource/4, version=0.246.1): ok (rc=0)
Nov  7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents: 
Archived previous version as /var/lib/heartbeat/crm/cib-30.raw
Nov  7 14:34:23 mysqldrbd01 cib: [29192]: info: write_cib_contents: 
Wrote version 0.246.0 of the CIB to disk (digest: 
b2c10b5780b5ffd9825112ab624861b5)
Nov  7 14:34:23 mysqldrbd01 cib: [29192]: info: retrieveCib: Reading 
cluster configuration from: /var/lib/heartbeat/crm/cib.blvW7w (digest: 
/var/lib/heartbeat/crm/cib.zrI8Li)
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_pe_invoke_callback: 
Invoking the PE: query=1488, ref=pe_calc-dc-1320698063-1741, seq=1368, 
quorate=1
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_config: On 
loss of CCM Quorum: Ignore
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: unpack_config: Node 
scores: 'red' = -INFINITY, 'yellow' = 0, 'green' = 0
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: 
determine_online_status: Node mysqldrbd02 is online
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: 
determine_online_status: Node mysqldrbd01 is online
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: 
Operation DRBD:0_monitor_0 found resource DRBD:0 active on mysqldrbd02
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard 
error - p_mysql:0_monitor_0 failed with rc=5: Preventing ms_mysql from 
re-starting on mysqldrbd02
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: find_clone: 
Internally renamed DRBD:0 on mysqldrbd01 to DRBD:1
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: 
Operation DRBD:0_monitor_0 found resource DRBD:1 active in master mode 
on mysqldrbd01
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: unpack_rsc_op: Hard 
error - p_mysql:1_monitor_0 failed with rc=5: Preventing ms_mysql from 
re-starting on mysqldrbd01
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: group_print:  
Resource Group: AP-CLUST
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: native_print:      
SRV-MOUNT       (ocf::heartbeat:Filesystem):    Started mysqldrbd01
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: native_print:      
FAILOVER-ADDR   (ocf::heartbeat:IPaddr2):       Started mysqldrbd01
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:  
Master/Slave Set: DRBD-DATA
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:      
Masters: [ mysqldrbd01 ]
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:      
Slaves: [ mysqldrbd02 ]
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:  Clone 
Set: PING-NET-CLONE
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:      
Started: [ mysqldrbd02 mysqldrbd01 ]
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: clone_print:  
Master/Slave Set: ms_mysql
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: short_print:      
Stopped: [ p_mysql:0 p_mysql:1 ]
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color: 
Promoting DRBD:1 (Master mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color: 
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color: 
Promoting DRBD:1 (Master mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color: 
DRBD-DATA: Promoted 1 instances of a possible 1 to master
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color: 
Resource p_mysql:0 cannot run anywhere
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: native_color: 
Resource p_mysql:1 cannot run anywhere
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: master_color: 
ms_mysql: Promoted 0 instances of a possible 1 to master
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource SRV-MOUNT     (Started mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource FAILOVER-ADDR (Started mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource DRBD:0        (Slave mysqldrbd02)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource DRBD:1        (Master mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource PING-NET:0    (Started mysqldrbd02)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource PING-NET:1    (Started mysqldrbd01)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource p_mysql:0     (Stopped)
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: notice: LogActions: Leave   
resource p_mysql:1     (Stopped)
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [ 
input=I_PE_SUCCESS cause=C_IPC_MESSAGE origin=handle_response ]
Nov  7 14:34:23 mysqldrbd01 pengine: [8609]: info: process_pe_message: 
Transition 797: PEngine Input stored in: /var/lib/pengine/pe-input-897.bz2
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: unpack_graph: Unpacked 
transition 797: 0 actions in 0 synapses
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_te_invoke: Processing 
graph 797 (ref=pe_calc-dc-1320698063-1741) derived from 
/var/lib/pengine/pe-input-897.bz2
Nov  7 14:34:23 mysqldrbd01 cibadmin: [29194]: info: Invoked: 
/usr/sbin/cibadmin -Ql
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: run_graph: 
====================================================
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: notice: run_graph: Transition 
797 (Complete=0, Pending=0, Fired=0, Skipped=0, Incomplete=0, 
Source=/var/lib/pengine/pe-input-897.bz2): Complete
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: te_graph_trigger: 
Transition 797 is now complete
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: notify_crmd: Transition 
797 status: done - <null>
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
State transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS 
cause=C_FSA_INTERNAL origin=notify_crmd ]
Nov  7 14:34:23 mysqldrbd01 crmd: [8610]: info: do_state_transition: 
Starting PEngine Recheck Timer
++++++++++++++++++++++++++++++++++++++
crm configure show:
----------------------

[root at mysqldrbd01 etc]# crm configure show
node mysqldrbd01 \
         attributes standby="off"
node mysqldrbd02 \
         attributes standby="off"
primitive DRBD ocf:linbit:drbd \
         params drbd_resource="repdata" \
         operations $id="DRBD-operations" \
         op start interval="0" timeout="240" \
         op stop interval="0" timeout="100" \
         op monitor interval="120" \
         meta target-role="started"
primitive FAILOVER-ADDR ocf:heartbeat:IPaddr2 \
         params ip="192.168.1.160" nic="eth1" \
         operations $id="FAILOVER-ADDR-operations" \
         op monitor start-delay="0" interval="10" \
         meta target-role="started"
primitive PING-NET ocf:pacemaker:ping \
         params dampen="5s" multiplier="100" host_list="192.168.209.4" \
         op monitor interval="60s" timeout="60" \
         op start interval="0" timeout="60s" \
         op stop interval="0" timeout="60s" \
         meta target-role="started"
primitive SRV-MOUNT ocf:heartbeat:Filesystem \
         params device="/dev/drbd0" directory="/data/" fstype="ext3" \
         operations $id="SRV-MOUNT-operations" \
         op start interval="0" timeout="60" \
         op stop interval="0" timeout="60" \
         meta target-role="started"
*primitive p_mysql ocf:heartbeat:mysql \
         params binary="/usr/bin/mysqld_safe" \
         operations $id="p_mysql-operations" \
         op start interval="0" timeout="120" \
         op promote interval="0" timeout="120" \
         op demote interval="0" timeout="120" \
         op stop interval="0" timeout="120" \
         op monitor interval="10" timeout="30" start-delay="0" \
         meta target-role="stopped"*
group AP-CLUST SRV-MOUNT FAILOVER-ADDR
*ms DRBD-DATA DRBD \
         meta clone-max="2" notify="true" target-role="started"
ms ms_mysql p_mysql \
         meta clone-max="2"*
clone PING-NET-CLONE PING-NET
location connected_node DRBD-DATA \
         rule $id="connected_node-rule" -inf: not_defined pingd or pingd 
lte 0
location master-prefer-node-1 FAILOVER-ADDR 25: mysqldrbd01
colocation AP-CLUST_on_DRBD inf: AP-CLUST DRBD-DATA:Master
order AP-CLUST_after_DRBD-DATA inf: DRBD-DATA:promote AP-CLUST:start
property $id="cib-bootstrap-options" \
         expected-quorum-votes="2" \
         stonith-enabled="false" \
         dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87" \
         no-quorum-policy="ignore" \
         cluster-infrastructure="openais" \
         last-lrm-refresh="1320686593"
rsc_defaults $id="rsc-options" \
         resource-stickiness="100"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20111107/681ac68e/attachment.htm>


More information about the Pacemaker mailing list