Hello all,
Is there a scriptable way to determine if a slave in a replication setup has been fully synchronized with its master?
Kind of like the following:
echo "SHOW SLAVE STATUS" | mysql -u root | awk -f somescript.awk
I'm not asking you to write the awk script for me ;) Just would like to know if there is a parameter that indicates full (or not) synchronization with the master that I can obtain through a perl/shell/python script or C program.
The mysql version is 3.23.57.
Thanks for any input.
Ian.
Ian:
You can use a comination of
SHOW MASTER STATUS on the master
and SELECT MASTER_POS_WAIT() on the slave
this is how the MySQL test suite deals with master/slave sync issue
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]