MySQL Forums
Forum List  »  Replication

Re: Replication doesn't write to database.
Posted by: Nathan Wilkerson
Date: March 03, 2014 04:35PM

I have been doing more testing and I have stumbled across the fact that the slave will replicate CREATE TABLE statements but not INSERT, OR UPDATE.

Below is the permissions to one of our databases folders and its contents. The rest all match this one.

drwx------ 2 mysql mysql 4096 2014-03-03 14:25 pt_heartbeat
-rw-rw---- 1 mysql mysql 65 2014-02-11 13:46 db.opt
-rw-rw---- 1 mysql mysql 8788 2014-03-03 10:47 heartbeat.frm
-rw-rw---- 1 mysql mysql 98304 2014-03-03 10:50 heartbeat.ibd
-rw-rw---- 1 mysql mysql 8564 2014-03-03 14:25 TEST_TABLE.frm
-rw-rw---- 1 mysql mysql 98304 2014-03-03 14:25 TEST_TABLE.ibd

The slave process runs as a system user so it shouldn't be mysql user privilege.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Replication doesn't write to database.
877
March 03, 2014 04:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.