InnoDB Slave not updating
Date: October 11, 2012 02:35AM
I have a primary MySQL server and am trying set up a replication for InnoDB database.
I perform a Master and Slave configuration, create a dump of Master station DB, restore it on Slave station and run replication. Everything looks fine but no updates are reflected on Slave. The Slave is running, the Read_Master_Log_Pos on Master and Slave are identical. I even look up the mysql-relay-bin.00000X file and there are updates from the Master. But no changes when I run "SELECT * FROM db.table;".
I tried to create an empty database, dump it and restore from it on the Slave, start replication and then create tables on Master and fill them. In this case replication is doing well. But I also need a way to replicate already created and filled database.
I also tried to switch tables engine to MyISAM and the situation is the same.
What should I do?
my.cnf on Master:
my.cnf on Slave:
SHOW MASTER STATUS\G
SHOW SLAVE STATUS\G
Slave_IO_State: Waiting for master to send event
SHOW PROCESSLIST on Master:
| 16 | slave1 | 10.0.13.140:54683 | NULL | Binlog Dump | 2062 | Has sent all binlog to slave; waiting for binlog to be updated | NULL |
SHOW PROCESSLIST on Slave:
| 14 | system user | | NULL | Connect | 2203 | Waiting for master to send event | NULL |
| 15 | system user | | NULL | Connect | 2203 | Has read all relay log; waiting for the slave I/O thread to update it | NULL |
I'm running both Master and Slave station from virtual CentOS 6.0, MySQL 5.1.61.
I implemented a little behavior test: I created am empty database on Master, run a replication script (everything went well - Master and Slave were running). Then I created an InnoDB table (CREATE TABLE tbl (id INT, data VARCHAR(10)) engine=InnoDB;), the table appeared on Slave. Then I filled table with data (INSERT tbl values (1, "1");), the data was updated on Slave. Then I stopped Master (service mysqld stop) and Slave IO also stopped (SHOW SLAVE STATUS - Slave_IO_Running: No, Slave_SQL_Running: Yes). Then I started MySQL on Master and Slave IO also started in some time. But since updates are not available on Slave, hence they are present in mysql-relay-bin.00000X on Slave.
Edited 1 time(s). Last edit at 10/11/2012 04:14AM by Don Pardon.
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.