Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Message-ID: <1140026433.1236527636117.JavaMail.jira@brutus>
Date: Sun, 8 Mar 2009 08:53:56 -0700 (PDT)
From: "Pinaki Poddar (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Created: (OPENJPA-966) Support Replication-enabled MySQL
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Support Replication-enabled MySQL  
-----------------------------------

                 Key: OPENJPA-966
                 URL: https://issues.apache.org/jira/browse/OPENJPA-966
             Project: OpenJPA
          Issue Type: New Feature
          Components: jdbc
    Affects Versions: 2.0.0-M1, 2.0.0
         Environment: MySQL
            Reporter: Pinaki Poddar
            Assignee: Pinaki Poddar
             Fix For: 2.0.0-M1, 2.0.0


Starting with Connector/J 3.1.7, a MySQL JDBC driver is available [2] that will automatically send queries to a read/write master, or a failover or round-robin loadbalanced set of slaves based on the state of Connection.getReadOnly() . 
OpenJPA can take advantage of this driver by setting up read-only property of the connection based on the dirty nature of the current transaction [1]. 

[1] http://n2.nabble.com/Mysql-Connector-J-ReplicantConnection-tc2431984.html
[2] http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-replication-connection.html

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.