[
https://issues.apache.org/jira/browse/OPENJPA-2943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jody Grassel updated OPENJPA-2943:
----------------------------------
Description:
MySQLDictionary.decorate() has a check to determine if the MySQL driver is of
type "com.mysql.jdbc.ReplicationDriver" (for utilizing read-only replica nodes
to relieve read-work on the primary database) – if it is, then it calls
conn.setReadOnly(true). This is to ensure that, by default, reads are going to
the reader nodes, instead of the writer nodes.
Later versions of the MySQL Connect J driver (as of v8) have done away with the
"com.mysql.jdbc.ReplicationDriver" class (see
[https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html
section|https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html,]).
This means the current means of detecting whether the environment is using
read-replicas is no longer valid, and needs to be updated to support more
modern versions of Connect J.
was:
MySQLDictionary.decorate() has a check to determine if the MySQL driver is of
type "com.mysql.jdbc.ReplicationDriver" (for utilizing read-only replica nodes
to relieve read-work on the primary database) – if it is, then it calls
conn.setReadOnly(true). This is to ensure that, by default, reads are going to
the reader nodes, instead of the writer nodes.
Later versions of the MySQL Connect J driver (as of v8) have done away with the
"com.mysql.jdbc.ReplicationDriver" class (see
[https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html
section|https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html,]).
This means the current means of detecting whether the environment is using
read-replicas is no longer valid, and needs to be updated to support more
modern versions of Connector J.
> MySQLDictionary.decorate() is out of date with MySQL Driver Changes
> -------------------------------------------------------------------
>
> Key: OPENJPA-2943
> URL: https://issues.apache.org/jira/browse/OPENJPA-2943
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Jody Grassel
> Priority: Major
>
> MySQLDictionary.decorate() has a check to determine if the MySQL driver is of
> type "com.mysql.jdbc.ReplicationDriver" (for utilizing read-only replica
> nodes to relieve read-work on the primary database) – if it is, then it calls
> conn.setReadOnly(true). This is to ensure that, by default, reads are going
> to the reader nodes, instead of the writer nodes.
> Later versions of the MySQL Connect J driver (as of v8) have done away with
> the "com.mysql.jdbc.ReplicationDriver" class (see
> [https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html
> section|https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html,]).
> This means the current means of detecting whether the environment is using
> read-replicas is no longer valid, and needs to be updated to support more
> modern versions of Connect J.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
