Web Hosting Talk







View Full Version : mysql replication new table failure


netserve
12-09-2002, 03:49 PM
I've got 2 mysql servers set up one as master one as slave.
All writes go to the master and most reads to the slave.

System works well for most things but is failing where a table has been created on the master server. For some reason it doesn't look like they're being created on the slave. Is this a known limitation?

Could it be a lack of permissions for the replication user?

lotuslnd
12-09-2002, 05:47 PM
I've just scanned a few threads in groups.google.com and although I wasn't able to find an answer, I did see someone saying that their replication setup wouldn't create databases, but subsequent table creates would get created (although the database didn't exist, so it would error out). Check the permissions on your replication user on the master and flush privileges after making any modifications.

Good luck!

netserve
12-09-2002, 07:03 PM
Not been able to find anything here. Errors suggest an odd query on the slave that couldn't be run but it's cropping up a couple of times a week.

Bit of a mess because replicating the server to maximise uptime is great but not if I've got to stop the master server 2 or 3 times a week for 10 to 15 mins each time to create a backup copy for the slave. :-(