MySQL Forums
Forum List  »  Replication

Replication Not taking update script
Posted by: waiyuen tham
Date: January 18, 2017 03:24AM

Hi Guys,

I'm using Mysql 5.6 on both Master and Replication.

In my Master i have 2 databases where 1 is the Base table and another one is having some tables viewing from the Base table.

When my program did some insert and update to the view table i have the updates on my Base table.

The problem is at my replication server. I only have the insert statement run to my replication but do not have the update statement run at my replication server.

I've check the binlog at Master server and replication server. The insert is present in both master and replication server. But then the update statement only present inside Master binlog but not in my replication binlog.

Anything i need to check?

Please help.

Thanks in advance.

Options: ReplyQuote

Written By
Replication Not taking update script
January 18, 2017 03:24AM

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.