Hosting Provided By

2PC on master-slave with replication

From: Darpan Dinker <darpandinker(at)gmail.com>
Date: Tue Jul 10 2007 - 03:37:12 EDT

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=lists@pantek.com

Received on Tue Jul 10 03:39:41 2007

This message: [ Message body ]
Next message: Octavian Rasnita: "error"
Previous message: eric: "Database persistent read error"
Next in thread: Rick James: "RE: 2PC on master-slave with replication"
Reply: Rick James: "RE: 2PC on master-slave with replication"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jul 16 2007 - 05:12:13 EDT