Re: Replication doesn't write to database.
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.
Subject
Views
Written By
Posted
1842
February 14, 2014 05:13PM
890
February 16, 2014 12:16AM
1364
February 16, 2014 09:07AM
864
February 17, 2014 11:44AM
1015
February 17, 2014 01:31PM
958
February 20, 2014 12:44PM
968
February 26, 2014 12:21PM
873
February 26, 2014 03:33PM
796
February 27, 2014 08:20PM
811
February 28, 2014 11:07AM
Re: Replication doesn't write to database.
877
March 03, 2014 04:35PM
927
March 05, 2014 10:15AM
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.