Digital Marketing

Loading...

Monitor MySQL replication

The most important variables are Slave_IO_Running, Slave_SQL_Running and Seconds_Behind_Master. Two first variables should be equal to ‘Yes’, and Seconds_Behind_Master should be 0 or close to it. These variables indicate that both replication threads are running and slave is up to date with master.

Comments

Post a Comment

Popular posts from this blog

MySQL Sandbox with the Sakila sample database

You can go to https://www.katacoda.com/mysql-db-sandbox/scenarios/mysql-sandbox to access the MySQL Sandbox, which has the Sakila sample database loaded in a MySQL instance. You’ll have to set up a (free) Katacoda account. Then, click the Start Scenario button. See also: https://dev.mysql.com/doc/index-other.html
Read more