Can I use load balancing to reader instance for read-only transactions, as the mariadb connector supports? about aws-mysql-jdbc HOT 2 CLOSED

Hello @21kyu,

Thank you for giving the AWS JDBC Driver for MySQL a try!

It seems that logic you're trying to achieve is supported. You may consider to use jdbc:mysql:replication:// protocol and do necessary adjustments to your configuration and to your application code. More details are available at: https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-source-replica-replication-connection.html.

Would you mind to provide more details about the context key that you use for your implementation of AbstractRoutingDataSource? Does this context key change according to whether read or write operation is needed? Assuming the context key has a proper value for both read and write cases, the rest of the logic relies on data sources. You may also need to make sure that replica data source is configured with replication protocol and a proper list of nodes.

If you use an Aurora MySQL cluster, you may consider to use cluster reader endpoint to connect to a random replica node.

from aws-mysql-jdbc.

jdbc:mysql:replication:// worked fine the way I wanted it to.
However, there is a delay between wrier/reader, so it was not suitable for my business logic.
I tested it in several diffrent modes, and as a result I decied to only use the Fast Failover feature via jdbc:mysql:aws:// protocol.
Thank you!

from aws-mysql-jdbc.