View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:47 AM
Darpan Dinker
 
Posts: n/a
Default 2PC on master-slave with replication

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
Reply With Quote