I want to use failover mode and load balancing mode of MariaDB connector / j.

[nw-engineer]

I'm using AWS RDS (aurora).
I want to use failover mode and load balancing mode of MariaDB connector / j.

However, using the mariadb connector / j does not work as expected.

Looking at the source below, I realized that I needed to make some changes.

★Source
guice/src/main/java/org/mybatis/guice/datasource/helper/JdbcHelper.java

★Change before
　83 MariaDB("jdbc:mysql://${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),
★Change after
　83 MariaDB("jdbc:mysql:aurora://${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),

https://mariadb.com/kb/en/about-mariadb-connector-j/#failover-and-load-balancing-modes

Because there are multiple parameters, I hope I can set it later.

Is there a way?
Thank you.

[nw-engineer]

Is the quickest way, prepare variables for the parameters?
↓

DB2("jdbc:db2://${JDBC.host|localhost}:${JDBC.port|50000}/${JDBC.schema}", "com.ibm.db2.jcc.DB2Driver"),

DB2_DataDirect("jdbc:datadirect:db2://${JDBC.host|localhost}:${JDBC.port|50000}/DatabaseName=${JDBC.schema}",
"com.ddtek.jdbc.db2.DB2Driver"),

If there is no contradiction in recognition, Send pull reqest in order to enable failover and load balancing modes of MariaDB connector / j.

[christianpoitras]

You should set the JDBC.url property for your connection instead of relying on the JdbcHelper class.
See http://mybatis.org/guice/core.html and http://mybatis.org/guice/datasources/builtin.html

[nw-engineer]

Thank you very much!

[nw-engineer]

If I use a binder, can I use the specified method?

The following parameters are configured to be set individually as needed.

JDBC.host
JDBC.port
JDBC.schema

Then, when JDBC.url is set, the function conflicts.

Execution result

A binding to java.lang.String annotated with @com.google.inject.name.Named(value=JDBC.url) was already configured at org.mybatis.guice.datasource.helper.JdbcHelper.configure(JdbcHelper.java:169).

JdbcHelper.java

  public void configure(Binder binder) {
    binder.bindConstant().annotatedWith(named(JDBC_DRIVER)).to(driverClass);
    binder.bind(Key.get(String.class, named(JDBC_URL))).toProvider(guicify(new JdbcUrlAntFormatter(urlTemplate)));
  }`

[christianpoitras]

I would not use JdbcHelper at all since it should only be used if your URL matches the one provided by the class.
If you look at the examples on the links I provided, the JdbcHelper class is not used.

[nw-engineer]

Thank you for your reply. I understand. But, the proposed content requires hard coding for each connection destination, which is not realistic.
If possible, I would like a method using JDBC Helper.

Is it difficult to add the following content to a JDBC Helper class?

MariaDB_Aurora("jdbc:mysql:aurora//${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),
MariaDB_Sequential("jdbc:mysql:sequential//${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),
MariaDB_Loadbalance("jdbc:mysql:loadbalance//${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),
MariaDB_Replication("jdbc:mysql:replication//${JDBC.host|localhost}:${JDBC.port|3306}/${JDBC.schema}", "org.mariadb.jdbc.Driver"),

[nw-engineer]

We are confident that adding this will bring many benefits to anyone who uses or plans to use AWS Aurora.

I also want to contribute to the project!

Thank you in advance for your consideration.

[christianpoitras]

I see your point. I will probably add these values to the JdbcHelper class.

[nw-engineer]

Thank you very much! Are you sure you want to submit a pull request?

[christianpoitras]

You can submit a pull request if you want. That would be easier for me. :)

[nw-engineer]

You have sent a pull request. Please check it.

[christianpoitras]

Fixed in revision e2a9906.