How to verify galera is synced

Posted on

Question :

I have been using mysql master:master replication and was always able to check the status of replication using this command:
mysql > show slave statusG
I was able to see this in the show slave status command:
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0

The seconds_behind_master always let me know if I was behind on one of my servers.

I am not using galera and am not sure how to verify if everything is up to date.
I have come across this article “Monitoring Cluster Status”
I realize I can use this command to see how many nodes are in the cluster:
SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';

But I am not sure if this command if good enough to tell whether or not they are exactly up to date:
SHOW GLOBAL STATUS LIKE 'wsrep_local_state_comment';
This command currently show synced but I cannot tell if this is the best way to tell if I am good to go.

Answer :

If wsrep_local_state_comment, wsrep_ready, and wsrep_connected show the correct values, then that particular node is good.

There’s no Seconds_Behind_Master equivalent, because Galera is synchronous — a healthy node can’t be lagging, by definition and by design… a slow node slows down all the others, it doesn’t lag behind them.

Leave a Reply

Your email address will not be published. Required fields are marked *