MySQL Forums
Forum List  »  Replication

Re: InnoDB Slave not updating
Posted by: Don Pardon
Date: October 31, 2012 09:06AM

> That's either a syntax error or a duplicate key. So nothing will be inserted.
No, there was no error. The data was perfectly inserted into the table on Master, but it wasn't updated on Slave (when I used SELECT * FROM db.table), hence the "INSERT ..." was in mysql-relay-bin.***** log file on Slave.

The table is pretty simple:
CREATE TABLE IF NOT EXISTS table
(
ID INT NOT NULL PRIMARY KEY,
VALUE INT
)
ENGINE = InnoDB;

Options: ReplyQuote


Subject
Views
Written By
Posted
4643
October 11, 2012 02:35AM
1471
October 11, 2012 10:44PM
1410
October 12, 2012 06:12AM
1542
October 26, 2012 07:58AM
1242
October 27, 2012 06:15AM
Re: InnoDB Slave not updating
1174
October 31, 2012 09:06AM
971
November 01, 2012 10:43PM
1105
November 02, 2012 02:07AM
1086
November 02, 2012 11:36PM


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.