[CONJ-767] permit using Aurora RO endpoint Created: 2020-03-06  Updated: 2020-06-01  Resolved: 2020-03-06

Status: Closed
Project: MariaDB Connector/J
Component/s: aurora
Affects Version/s: None
Fix Version/s: 2.6.0

Type: New Feature Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

Modified reg-ex patterns to match Aurora's read-only endpoints
see https://github.com/mariadb-corporation/mariadb-connector-j/pull/146



 Comments   
Comment by Peter Lebedev [ 2020-06-01 ]

Tried using ro-cluster end point and the driver is unable to connect. Put back the cluster end point, and it worked again:

Caused by: java.sql.SQLException: Communications link failure with primary. No active connection found for master. 
	at org.mariadb.jdbc.internal.failover.AbstractMastersListener.throwFailoverMessage(AbstractMastersListener.java:563) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.checkInitialConnection(MastersSlavesListener.java:350) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.initializeConnection(MastersSlavesListener.java:179) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.internal.failover.FailoverProxy.<init>(FailoverProxy.java:120) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:607) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) ~[mariadb-java-client-2.6.0.jar:?]
	at org.mariadb.jdbc.MariaDbDataSource.getConnection(MariaDbDataSource.java:275) ~[mariadb-java-client-2.6.0.jar:?]
        at org.mariadb.jdbc.MariaDbDataSource.getXAConnection(MariaDbDataSource.java:453) ~[mariadb-java-client-2.6.0.jar:?]
	at com.atomikos.jdbc.AtomikosXAConnectionFactory.createPooledConnection(AtomikosXAConnectionFactory.java:43) ~[transactions-jdbc-4.0.6.jar:?]
	... 24 more

The connection string is something like this, with aurora mode:
jdbc:mariadb:aurora://<some.cluster-ro.region.rds.amazonaws.com>/db

Generated at Thu Feb 08 03:18:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.