On the Database menu, choose Driver Manager.On the DBeaver tool, you can add the AWS JDBC Driver for MySQL. When the database is set up and ready, use an open-source database management tool such as DBeaver to connect to your database.Provide the remaining required information.Īfter the cluster is successfully provisioned, you can select your cluster on the Databases page, and the reader and writer endpoints are displayed as shown in the following screenshot.Leave the default selection for Engine options as Aurora and choose the MySQL 5.7-compatible edition.On the Amazon RDS console, choose Databases in the navigation pane.At the end of this section, we provide more information about using the driver with build automation tools.Īfter you install the driver, the next step is to create an Aurora cluster. The complete installation guide is on the GitHub repo. jar file to connect to the Aurora cluster. Through a package manager like Maven or Gradle.You can install the AWS JDBC Driver for MySQL two different ways: To deploy the AWS JDBC Driver for MySQL, complete the following steps. Failover with the AWS JDBC Driver for MySQL.In this post, we discuss the following topics: Decreasing database failover time can increase your overall application availability.

With this knowledge, the AWS JDBC Driver for MySQL can more closely monitor the Aurora DB cluster status so that a connection to the new primary DB instance can be established as fast as possible. This topology is provided via a direct query(by the driver) to the Aurora database, essentially providing a shortcut to bypass the delays caused by DNS resolution. The AWS JDBC Driver for MySQL fully utilizes failover behavior by maintaining a cache of the Aurora cluster topology and each DB instance’s role (Aurora replicas or primary DB instance). This is partially due to the time required for the DNS of the new primary DB instance to be fully resolved in order to properly direct the connections. You can use this driver as a drop-in replacement for the MySQL Connector/J Driver to connect to an Amazon Aurora MySQL-Compatible Edition cluster.Īmazon Aurora is able to provide high availability through the use of failover, but existing client drivers don’t currently take full advantage of this functionality. In this post, we demonstrate how to use the Amazon Web Services (AWS) JDBC Driver for MySQL, which allows an application to take advantage of the features of clustered MySQL databases.

Amazon jdbc driver for mac