MySQL Forums
Forum List  »  Replication

Replication Slave update question
Posted by: Thomas Hoskins
Date: August 30, 2012 12:56PM

I am an old Oracle guy new to MySQL - so please bear with me.

Scenario:

I have a setup a master and one slave (MySQL 5.5.16 Community). Autocommit is shut off on both servers and using STATEMENT based replication.

Steps:

1. Open mysql session on slave's node so I can query my test table.

2. On master node - connect and execute UPDATE statement on a record in test table, followed by a COMMIT (due to autocommit setting).

3. Both MASTER and SLAVE statuses seem to update fine.

4. Slave mysql session query shows no change to the test record.

5. Exit out of slave mysql session and go back in.

6. Magically, query now shows record updated.

Question:
Why can my slave session not see the update unless I exit and reconnect ?

Is there something I am missing here ?

Thanks in advance for any insight.



Edited 1 time(s). Last edit at 08/30/2012 01:02PM by Thomas Hoskins.

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Slave update question
2803
August 30, 2012 12:56PM
1085
August 31, 2012 04:43AM
1115
August 31, 2012 10:20AM
1159
August 31, 2012 06:53PM


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.