September 9th, 2013, 04:26 AM
How to replicate MySQL users?
i'm trying desperatly to replicate the MySQL users from one MySQL server to another.
General situtaion: Two Debian 7.1 servers with MySQL (5.5.31-0+wheezy1-log (Debian)) on each.
Master-Master replication between them is working fine - for my custom database.
But when it comes to sync the MySQl users from DB MySQL nothing is happen. No errors. Just no users on node 2.
Didn't find anything at web / forum search.
Thanks in advance for hints.
September 10th, 2013, 08:02 AM
September 11th, 2013, 06:02 AM
Thanks for your advice Stefan.
Unfortunately I've checked this several times without result.
Here's the current slave status (from node2):
mysql> show slave status \G
Slave_IO_State: Waiting for master to send event
And this is the master status (from node1):
mysql> show master status \G
September 16th, 2013, 08:17 AM
Perform a GRANT and then check by extracting the SQL commands from the binlog to find out if the changes are written to the binlog.
That way you will know if the problem is on the master och slave side.
If the changes to the mysql database is present in the binlog then the master is performing correctly and you will have to look a the slave.
But if the changes aren't written to the binlog then you will have to troubleshoot on the master.