Support MySQL 8.4.3

[willzhang]

when will support mysql 8.4.3?

root@mysql-node31:~# mysql --version
mysql  Ver 8.4.3 for Linux on x86_64 (MySQL Community Server - GPL)

root@replication-manager01:~# replication-manager-osc version
Replication Manager v3.0.9 for MariaDB 10.x and MySQL 5.7 Series
Full Version:  v3.0.9
Build Time:  2025-01-03T10:45:39+0000

error logs:

root@replication-manager01:~# journalctl --no-pager -u replication-manager
Feb 06 11:05:23 replication-manager01 replication-manager-osc[2604]: time="2025-02-06T11:05:23+08:00" level=debug msg="Could not get master status 192.168.72.32:3306 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1" cluster=cluster1
Feb 06 11:05:23 replication-manager01 replication-manager-osc[2604]: time="2025-02-06T11:05:23+08:00" level=error msg="Could not get master status 192.168.72.32:3306 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1" cluster=cluster1 error="Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1" module=Monitor server="192.168.72.32:3306" sql="SHOW MASTER STATUS"
Feb 06 11:05:23 replication-manager01 replication-manager-osc[2604]: time="2025-02-06T11:05:23+08:00" level=debug msg="Could not get slaves status 192.168.72.33:3306 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1" cluster=cluster1
Feb 06 11:05:23 replication-manager01 replication-manager-osc[2604]: time="2025-02-06T11:05:23+08:00" level=error msg="Could not get slaves status 192.168.72.33:3306 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1" cluster=cluster1 error="Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1" module=Monitor server="192.168.72.33:3306" sql="SHOW SLAVE STATUS"
Feb 06 11:05:24 replication-manager01 replication-manager-osc[2604]: time="2025-02-06T11:05:24+08:00" level=debug msg="Could not get slaves status 192.168.72.32:3306 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1" cluster=cluster1

SHOW MASTER STATUS ，The command is no longer supported

Removed	Replacements
START SLAVE	START REPLICA
STOP SLAVE	STOP REPLICA
SHOW SLAVE STATUS	SHOW REPLICA STATUS
SHOW SLAVE HOSTS	SHOW REPLICAS
RESET SLAVE	RESET REPLICA
CHANGE MASTER TO	CHANGE REPLICATION SOURCE TO
RESET MASTER	RESET BINARY LOGS AND GTIDS
SHOW MASTER STATUS	SHOW BINARY LOG STATUS
PURGE MASTER LOGS	PURGE BINARY LOGS
SHOW MASTER LOGS	SHOW BINARY LOGS

[svaroqui]

Hi willzhang, i'm curious when we will release this can you test if tagged replication works this is equivalent to domain in MariaDB but with 10 year late ?

[willzhang]

I have build develop branch

 1985  ls
 1986  git clone https://github.com/signal18/replication-manager.git -b develop
 1987  cd replication-manager/
 1988  ls
 1989  git branch
 1990  make bin

version info

root@replication-manager01:~# cat /etc/replication-manager/cluster.d/cluster1.toml
[cluster1]
title = "cluster1"
prov-orchestrator = "onpremise"
db-servers-hosts = "msyql-node31:3306,mysql-node32:3306,mysql-node33:3306"
db-servers-prefered-master = "mysql-node31:3306"
db-servers-credential = "root:Mysql#123456"
replication-credential = "repl:password"
root@replication-manager01:~# ^C
root@replication-manager01:~# replication-manager-osc version
Replication Manager v3.0.15 for MariaDB 10.x and MySQL 5.7 Series
Full Version:  v3.0.15-84-g4093739af
Build Time:  2025-02-07T11:42:48+0800

error log

root@replication-manager01:~# journalctl --no-pager -u replication-manager
....
Feb 08 16:17:30 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:30+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:30 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:30+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:32 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:32+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:32 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:32+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:34 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:34+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:34 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:34+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:36 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:36+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:17:36 replication-manager01 replication-manager-osc[119655]: time="2025-02-08T16:17:36+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
root@replication-manager01:~# 

debug error logs

root@replication-manager01:~# journalctl --no-pager -fu replication-manager
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:32 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:32+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Monitoring server loop" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Servers not nil : [0xc0018afc08 0xc0018b0308 0xc0018b0a08]\n" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Servers loops k : 0, url : msyql-node31:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server [0]: URL: msyql-node31:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Servers loops k : 1, url : mysql-node32:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server [1]: URL: mysql-node32:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Servers loops k : 2, url : mysql-node33:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server [2]: URL: mysql-node33:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Failure detection of no master FailCount 5 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Failure detection of no master FailCount 5 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Failure detection of no master FailCount 5 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server msyql-node31:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server mysql-node32:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Server mysql-node33:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:34 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:34+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Monitoring server loop" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Servers not nil : [0xc0018afc08 0xc0018b0308 0xc0018b0a08]\n" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Servers loops k : 0, url : msyql-node31:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server [0]: URL: msyql-node31:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Servers loops k : 1, url : mysql-node32:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server [1]: URL: mysql-node32:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Servers loops k : 2, url : mysql-node33:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server [2]: URL: mysql-node33:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Failure detection of no master FailCount 6 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Failure detection of no master FailCount 6 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Failure detection of no master FailCount 6 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server msyql-node31:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server mysql-node32:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Server mysql-node33:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:36 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:36+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Monitoring server loop" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Servers not nil : [0xc0018afc08 0xc0018b0308 0xc0018b0a08]\n" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Servers loops k : 0, url : msyql-node31:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server [0]: URL: msyql-node31:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Servers loops k : 1, url : mysql-node32:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server [1]: URL: mysql-node32:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Servers loops k : 2, url : mysql-node33:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server [2]: URL: mysql-node33:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Failure detection of no master FailCount 7 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Failure detection of no master FailCount 7 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Failure detection of no master FailCount 7 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server msyql-node31:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server mysql-node32:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Server mysql-node33:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:38 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:38+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Monitoring server loop" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Servers not nil : [0xc0018afc08 0xc0018b0308 0xc0018b0a08]\n" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Servers loops k : 0, url : msyql-node31:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server [0]: URL: msyql-node31:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Servers loops k : 1, url : mysql-node32:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server [1]: URL: mysql-node32:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Servers loops k : 2, url : mysql-node33:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server [2]: URL: mysql-node33:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Failure detection of no master FailCount 8 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Failure detection of no master FailCount 8 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Failure detection of no master FailCount 8 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server msyql-node31:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server mysql-node32:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Server mysql-node33:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:40 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:40+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Monitoring server loop" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Servers not nil : [0xc0018afc08 0xc0018b0308 0xc0018b0a08]\n" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Servers loops k : 0, url : msyql-node31:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server [0]: URL: msyql-node31:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Servers loops k : 1, url : mysql-node32:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server [1]: URL: mysql-node32:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Servers loops k : 2, url : mysql-node33:3306, state : Suspect, prevstate Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server [2]: URL: mysql-node33:3306 State: Suspect PrevState: Suspect" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Failure detection of no master FailCount 9 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=error msg="Driver Error mysql-node32:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Failure detection of no master FailCount 9 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=error msg="Driver Error mysql-node33:3306 1698 " cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Master not defined" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Failure detection of no master FailCount 9 MaxFail 5" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server msyql-node31:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server mysql-node32:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Server mysql-node33:3306 has no slaves " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Check for relay server msyql-node31:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Check for relay server mysql-node32:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Check for relay server mysql-node33:3306: relay: false" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Refresh proxy start" cluster=cluster1 module=proxy type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Refresh proxy end" cluster=cluster1 module=proxy type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server msyql-node31:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node32:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Inter cluster multi-source check drop unlinked server mysql-node33:3306 source cluster  cluster1 vs this cluster cluster1  " cluster=cluster1 module=topology type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Master not discovered, skipping failover check" cluster=cluster1 module=general type=log
Feb 08 16:22:42 replication-manager01 replication-manager-osc[119819]: time="2025-02-08T16:22:42+08:00" level=debug msg="Election matrice: [] " cluster=cluster1 module=election type=log
^C
root@replication-manager01:~# 

mysql master slave status

mysql> show replicas;
+-----------+--------------+------+-----------+--------------------------------------+
| Server_Id | Host         | Port | Source_Id | Replica_UUID                         |
+-----------+--------------+------+-----------+--------------------------------------+
|        33 | mysql-node33 | 3306 |        31 | c2847b99-e5e7-11ef-9c61-005056aa3e12 |
|        32 | mysql-node32 | 3306 |        31 | c06a6c6d-e5e7-11ef-b5f3-005056aa349a |
+-----------+--------------+------+-----------+--------------------------------------+
2 rows in set (0.00 sec)