Hello,
My two database nodes are now slaves after an unsuccessful attempt to switch from slave to master.
I am looking for a way to switch my primary node back to MASTER status. Currently, it is the active one operating in the HA setup.
Previous command
# pcs resource move ms_mysql Error: to move promotable clone resources you must use the promotable clone id (ms_mysql-clone)
Error: Errors have occurred, therefore pcs is unable to continue
# pcs resource move ms_mysql-clone Warning: Creating location constraint 'cli-ban-ms_mysql-clone-on-BDD_SECONDARY_NODE' with a score of -INFINITY for resource ms_mysql-clone on BDD_SECONDARY_NODE.r
This will prevent ms_mysql-clone from running on BDD_SECONDARY_NODE until the constraint is removed
This will be the case even if BDD_SECONDARY_NODE is the last node in the cluste
Result:
[root@BDD_SECONDARY_NODE]# /usr/share/centreon-ha/bin/mysql-check-status.sh
Connection SLAVE Status 'BDD_PRIMARY_NODE' [OK]
Connection SLAVE Status 'BDD_SECONDARY_NODE' [OK]
Slave Thread Status [KO]
Error reports:
No slave (maybe because we cannot check a server).
Position Status [SKIP]
Error reports:
Skip because we can't identify a unique slave.