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 Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com

Received on Tue Jul 10 03:39:55 2007

This message: [ Message body ]
Next message: Rick James: "RE: 2PC on master-slave with replication"
Previous message: Rick James: "RE: Is Replicating Data from Firewalled Master Possible?"
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:19 EDT