[Pacemaker] Replication MYSQL does not work in pacemaker
Andrew Beekhof
andrew at beekhof.net
Mon Nov 14 00:36:27 UTC 2011
On Tue, Nov 8, 2011 at 7:42 AM, Joe <weester at hotmail.com> wrote:
> 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
The resource agent is claiming some necessary part of mysql is not installed.
Hence the "not installed" message.
> 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"
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at 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://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
>
>
More information about the Pacemaker
mailing list