Database replication
I tried to follow the steps outlined at http://www.howtoforge.com/mysql_database_replication for database replication. I created a database exampledb and create some tables and load them with values.
But when I execute USE exampledb; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS;
I am not getting any output, it says 0 rows were affected. why is it so?
+2
a source to share
1 answer
Generally, I've found that "Show Master Status" says very little about the replication status. Using Show Slave Status on a slave is much more useful to display the current status of replication. For example: replication reported to the master, whether there were any errors, whether the transaction score matches the master.
0
a source to share