[ClusterLabs] MS MySQL resource not beeing promoted?

[Michael Schwartzkopff]

Hi,


I set up a mariadb on CentOS7 as master/slave-.

Manually the sync works.


when I confiure a ms resource in pacmaker, it comes up correctly on the
first glance.


"show master status" and "show slave status" in mysql works and shows
the correct status.


When I set the master node to standby, pacemaker promotes the database
server correctly, at least in the pacemaker status. BUT: "show master
status" on the now promoted server shows nothing. The database definitly
in NOT in the master state.

Setting the first node online again, pacemaker starts the database and
shows it as a slave. "show master status" in the database shows, that
the first node is master again.


So, the status in pacemaker does not agree to the real status of the
database.

Any ideas?

Mit freundlichen Grüßen,

-- 

[*] sys4 AG
 
https://sys4.de, +49 (89) 30 90 46 64
Schleißheimer Straße 26/MG,80333 München
 
Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer, Wolfgang Stief
Aufsichtsratsvorsitzender: Florian Kirstein


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 213 bytes
Desc: OpenPGP digital signature
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20190208/564d8def/attachment.sig>