[Pacemaker] [Openais] Filesystem vs. Master-Slave MySQL resource

[Jan Friesse]

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.gajdos at digmia.com
> 
> DIGMIA s.r.o.
> Lazaretská 12
> 81108 Bratislava
> 
> 
> 
> 
> _______________________________________________
> Openais mailing list
> Openais at lists.linux-foundation.org
> https://lists.linuxfoundation.org/mailman/listinfo/openais
>