Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-966

Support Replication-enabled MySQL

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-M1, 2.0.0-M2
    • Fix Version/s: 2.0.0-M1, 2.0.0-M2
    • Component/s: jdbc
    • Labels:
      None
    • Environment:
      MySQL

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              ppoddar@apache.org Pinaki Poddar
              Reporter:
              ppoddar@apache.org Pinaki Poddar
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified