With this knowledge, the AWS JDBC Driver for MySQL can more closely monitor the database cluster status so that a connection to the new primary DB instance can be established as quickly as possible. This topology is provided via a direct query to the MySQL database, providing a shortcut to bypass the delays caused by DNS resolution.

It achieves this by maintaining a cache of the MySQL cluster topology and each instance's role (replica or primary DB instance). The AWS JDBC Driver for MySQL is designed to coordinate with this behavior in order to provide minimal downtime. This process can take up to several minutes. It achieves this by electing a database replica to become the new primary DB instance, so that the cluster can provide maximum availability to a primary read-write DB instance.īefore a replica instance can be elevated to the role of primary DB instance, the DNS record must be updated in order to properly direct the connection. In Amazon Aurora, failover is a mechanism by which the database automatically repairs the cluster status when a primary DB instance becomes unavailable. The AWS JDBC Driver for MySQL is optimally configured to enable applications to connect to and take advantage of the features of clustered MySQL database deployments. A driver converts SQL queries in an application into a protocol language to communicate with the database and returns query results to the application. HOW IT WORKSĭevelopers use software libraries, known as database connectivity drivers (or simply drivers), to connect applications to databases. Support for additional features of clustered databases, including features of Amazon RDS for MySQL and on-premises MySQL deployments is planned. The AWS JDBC Driver for MySQL also supports fast failover for Amazon Aurora with MySQL compatibility. It is based on and can be used as a drop-in compatible for the MySQL Connector/J driver, and is compatible with all MySQL deployments. Amazon Web Services (AWS) JDBC Driver for MySQL DOWNLOAD HOW IT WORKS BENEFITS FAQsĪmazon Web Services (AWS) JDBC Driver for MySQL allows an application to take advantage of the features of clustered MySQL databases.

Mysql jdbc driver for mac