For general introduction for MariaDB java connector, please check on https://github.com/MariaDB/mariadb-connector-j. The source code here is in the latest version same with the related branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support. Take advantage of this client to improve the connection latency between application front end and Azure Database for MySQL/MariaDB. Following is a brief guide of how to install and test the driver.

This driver is now available from Maven central repository search from https://mvnrepository.com/artifact/com.microsoft.azure/azure-mariadb-connector-java. The version number is same with related branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support. You may use following sample pom definition to include the driver in your project:

<dependency>
    <groupId>com.microsoft.azure</groupId>
    <artifactId>azure-mariadb-connector-java</artifactId>
    <version>2.7.0</version>
</dependency>

The source code here is in the latest status same with the realted branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support(2020-06-03). Valid branches:

• master: based on MariaDB/mariadb-connector-j branch master with redirection support.
• 2.7.0-with-redirection: based on MariaDB/mariadb-connector-j tag 2.7.0 with redirection support.
• 2.6.0-with-redirection: based on MariaDB/mariadb-connector-j tag 2.6.0 with redirection support.
• 2.5.1-with-redirection: based on MariaDB/mariadb-connector-j tag 2.5.1 with redirection support.

Notice There is an issue traced for MariaDB/mariadb-connector-j 2.5.2+ on https://jira.mariadb.org/browse/CONJ-807. The problem has been fixed on 2.7.0. The recommended branch is 2.7.0-with-redirection or 2.5.1-with-redirection.

A new connection option is introduced for redirection and the option name is enableRedirect, default value: off.

The detailed usage of the option enableRedirect is as follows:

• Java 1.8+
• Maven

• Assuming the code directory is mariadb-connector-j
• Git clone https://github.com/Microsoft/mariadb-connector-j .
• cd mariadb-connector-j and checkout to target branch
• Use following command to build and run default unit test:

mvn package

The default test database names is testj which need to be created ahead, user is root, and without password. You can also specify the connection string as follows for test:

mvn -DdbUrl=jdbc:mariadb://localhost:3306/testj?user=root&password=xxx -DlogLevel=FINEST package

Please notice that the unit test sets is not designed fully compatibitale with Azure MySQL server, so don't run this test against Azure MySQL server and expect a full pass.

If you want to build without running unit tests and document check, use:

mvn -Dmaven.javadoc.skip=true -Dmaven.test.skip=true package

After build, you should have JDBC jar mariadb-java-client-x.y.z.jar in the 'target' subdirectory, e.g. mariadb-java-client-2.5.1.jar. Replace this jar with the mariadb-java-client jar package you currently used in your environemnt. Following are two use examples in different scenario:

• Jmeter test: Put the jar or replace the jar package in Jemter's lib directory, e.g. apache-jmeter-5.2.1\lib\
• A basic JDBC Java project: You may follow http://www.ccs.neu.edu/home/kathleen/classes/cs3200/JDBCtutorial.pdf to setup a basic JDBC Java project, add the jar path in Build Path - Libraries - Add External JARS.

After install, specify the connection string setting with enableRedirect option, e.g.

jdbc:mysql://xxx.mysql.database.azure.com/testj/?user=xx&password=xx&useSSL=true&serverSslCert=xx/BaltimoreCyberTrustRoot.crt.pem&enableRedirect=on"

Notice: Please notice that there is a limitation for Azure DB for MySQL where redirection is only possible when the connection is configured with SSL and only works with TLS 1.2 with a FIPS approved cipher for redirection.

• The pdf document http://www.ccs.neu.edu/home/kathleen/classes/cs3200/JDBCtutorial.pdf is a step by step guide to use JDBC with Eclipse. The difference here is that in step 2, you do not need to go to http://www.mysql.com/downloads/connector/j/ to download the jar, but using the one built in the ‘target’. After setup the environment, following is a version of sample code to test "SELECT 1" performance.

    // Load the JDBC driver
    Class.forName("org.mariadb.jdbc.Driver");
    System.out.println("Driver loaded");

    int count = 10;
    String query = "SELECT 1";
    int i=0;
    // Try to connect
    String url = "jdbc:mysql://xxx.mysql.database.azure.com"+
            "?verifyServerCertificate=false"+
            "&useSSL=true"+
            "&requireSSL=true" +
			"&enableRedirect=on";

    Connection connection = DriverManager.getConnection (url, "username", "password");
    double t1 = System.nanoTime();
    Statement s1 = connection.createStatement();
    for(i=0;i<count;i++)
    {
        s1.executeQuery(query);
    }
    double t2 = System.nanoTime();
    System.out.println (" time = " + (t2 - t1)/count/1000000);
    connection.close();