>4. Slave mysql session query shows no change to the test record.
Did you have opened transaction? for instance:
On slave host you start new session 'A':
mysql> START TRANSACTION;
mysql> select * from tblInnoDBCheck;
+-----------+
| a |
+-----------+
| hello |
| bye |
| bye again |
+-----------+
3 rows in set (0.00 sec)
On master database, insert new record in tblInnodbCheck table
mysql> insert into tblInnoDBCheck values ('GO');
Query OK, 1 row affected (0.00 sec)
go back to session 'A' and run 'select' query again:
mysql> select * from tblInnoDBCheck;
+-----------+
| a |
+-----------+
| hello |
| bye |
| bye again |
+-----------+
3 rows in set (0.00 sec)
You would see the same three rows. However, if you close the current transaction i.e. commit and rerun select then you would see the new row. Alternatively if you kill current session and go back in, you would see the new record.
See:
http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html#isolevel_repeatable-read
Edited 2 time(s). Last edit at 08/31/2012 04:44AM by Aftab Khan.