[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    2PC on master-slave with replication
From:       Darpan Dinker <darpandinker () gmail ! com>
Date:       2007-07-10 7:37:12
Message-ID: 46933728.9080101 () gmail ! com
[Download RAW message or body]

Hi,
Is it possible to have a transaction with an update statement pointed to 
the master and a select statement pointed to the slave. If the isolation 
level of this transaction is REPEATABLE_READ or SERIALIZABLE, will a 
commit involve 2PC?
Thanks,
Darpan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]