Matej, this is really question for pacemaker mailing list. > Hello, > > I have the following setup: > > 2 nodes: db-01, db-02 > Groups of resources: > fs-01: iscsi+lvm+fs at db-01 > fs-02: iscsi+lvm+fs at db-02 > > fs-01 is for mounting data files for MySQL at db-01, fs-02 for db-02 > > MySQL resources: > > primitive p_mysql mysql \ > params binary="/usr/bin/mysqld_safe" config="/etc/my.cnf" > datadir="/var/lib/mysql/db" replication_user=replicant > replication_passwd=**** test_user=test test_passwd=**** \ > op start timeout=120 interval=0 \ > op stop timeout=120 interval=0 \ > op promote timeout=120 interval=0 \ > op demote timeout=120 interval=0 \ > op monitor role=Master timeout=30 interval=5 \ > op monitor role=Slave timeout=30 interval=8 > > ms ms_mysql p_mysql \ > meta notify=true master-max=1 clone-max=2 target-role=Started > is-managed=true > > > To force groups at right nodes I have following: > > location loc_mysql-1 fs-01 inf: db-01 > location loc_mysql-1n fs-01 -inf: db-02 > location loc_mysql-2 fs-02 inf: db-02 > location loc_mysql-2n fs-02 -inf: db-01 > > I have troubles with order. > > I need to configure startup of ms_mysql after FS mounts. > There are several scenarios: > > 1) Both nodes online > - start both fs-01 and fs-02 > - start ms_mysql, one node as Master, other as Slave > > 2) Only one node online > - start related fs-0x > - start ms_mysql at one node > > 3) Running both nodes, standby slave > - stop ms_mysql:Slave > - stop related fs > > 4) Running both nodes, standby master > - demote master > - promote slave to became master > - stop slave (ex master) > - stop related fs > > I have troubles to configure the right dependecies betwen fs-01, fs-02, > ms_mysql:start, ms_mysql:promote, etc... > > I can provide more detais as needed. > > Thanks for your help. > > Best regards > Matej Gajdos > > — > e-mail: matej.gaj...@digmia.com > > DIGMIA s.r.o. > Lazaretská 12 > 81108 Bratislava > > > > > _______________________________________________ > Openais mailing list > open...@lists.linux-foundation.org > https://lists.linuxfoundation.org/mailman/listinfo/openais >
_______________________________________________ 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