RE: 2PC on master-slave with replication

2007-07-10 Thread Rick James
t; To: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: 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 th

2PC on master-slave with replication

2007-07-10 Thread Darpan Dinker
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