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: [email protected]
DIGMIA s.r.o.
Lazaretská 12
81108 Bratislava
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Openais mailing list [email protected] https://lists.linuxfoundation.org/mailman/listinfo/openais
