MySQL Forums :: Replication :: Replication Slave update question


Advanced Search

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 1816 Thomas Hoskins 08/30/2012 12:56PM
Re: Replication Slave update question 807 Aftab Khan 08/31/2012 04:43AM
Re: Replication Slave update question 785 Thomas Hoskins 08/31/2012 09:02AM
Re: Replication Slave update question 838 Aftab Khan 08/31/2012 10:20AM
Re: Replication Slave update question 851 Rick James 08/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.