Advertisement
Guest User

pacemaker config for mysql RA with VIPs

a guest
Nov 11th, 2011
258
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. node testvirtbox1 \
  2. attributes standby="off" testvirtbox3-log-file-p_mysql="mysql-bin.000045" testvirtbox3-log-pos-p_mysql="106" testvirtbox2-log-file-p_mysql="mysql-bin.000052" testvirtbox2-log-pos-p_mysql="106"
  3. node testvirtbox2 \
  4. attributes testvirtbox3-log-file-p_mysql="mysql-bin.000045" testvirtbox3-log-pos-p_mysql="106"
  5. node testvirtbox3 \
  6. attributes standby="off" testvirtbox2-log-file-p_mysql="mysql-bin.000052" testvirtbox2-log-pos-p_mysql="106"
  7. primitive p_mysql ocf:heartbeat:mysql \
  8. params config="/etc/mysql/my.cnf" pid="/var/run/mysqld/mysqld.pid" socket="/var/run/mysqld/mysqld.sock" replication_user="root" replication_passwd="rootpass" max_slave_lag="15" evict_outdated_slaves="false" binary="/usr/bin/mysqld_safe" test_user="root" test_passwd="rootpass" \
  9. op monitor interval="5s" role="Master" OCF_CHECK_LEVEL="1" \
  10. op monitor interval="2s" role="Slave" OCF_CHECK_LEVEL="1"
  11. primitive reader_vip_1 ocf:heartbeat:IPaddr2 \
  12. params ip="10.2.2.171" nic="eth0"
  13. primitive reader_vip_2 ocf:heartbeat:IPaddr2 \
  14. params ip="10.2.2.172" nic="eth0"
  15. primitive reader_vip_3 ocf:heartbeat:IPaddr2 \
  16. params ip="10.2.2.173" nic="eth0"
  17. primitive writer_vip ocf:heartbeat:IPaddr2 \
  18. params ip="10.2.2.170" nic="eth0" \
  19. meta target-role="Started"
  20. ms ms_MySQL p_mysql \
  21. meta master-max="1" master-node-max="1" clone-max="3" clone-node-max="1" notify="true" globally-unique="false" target-role="Master" is-managed="true"
  22. location No-reader-vip-1-loc reader_vip_1 \
  23. rule $id="No-reader-vip-1-rule" -inf: readerOK eq 0
  24. location No-reader-vip-2-loc reader_vip_2 \
  25. rule $id="No-reader-vip-2-rule" -inf: readerOK eq 0
  26. location No-reader-vip-3-loc reader_vip_3 \
  27. rule $id="No-reader-vip-3-rule" -inf: readerOK eq 0
  28. colocation reader_vip_1_dislike_reader_vip_2 -200: reader_vip_1 reader_vip_2
  29. colocation reader_vip_1_dislike_reader_vip_3 -200: reader_vip_1 reader_vip_3
  30. colocation reader_vip_2_dislike_reader_vip_3 -200: reader_vip_2 reader_vip_3
  31. colocation writer_vip_coloc_master inf: ms_MySQL:Master writer_vip
  32. order order_writer_vip_master inf: ms_MySQL:promote writer_vip:start
  33. property $id="cib-bootstrap-options" \
  34. dc-version="1.0.11-a15ead49e20f047e129882619ed075a65c1ebdfe" \
  35. cluster-infrastructure="openais" \
  36. expected-quorum-votes="3" \
  37. stonith-enabled="false" \
  38. no-quorum-policy="ignore" \
  39. last-lrm-refresh="1321041246"
  40. rsc_defaults $id="rsc-options" \
  41. resource-stickiness="100"
  42.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement