Connecting to Multi-AZ DB clusters with the Amazon drivers for Amazon RDS - Amazon Relational Database Service
Connecting to Multi-AZ DB clusters with the Amazon JDBC DriverConnecting to Multi-AZ DB clusters with the Amazon Python Driver
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Connecting to Multi-AZ DB clusters with the Amazon drivers for Amazon RDS

The Amazon suite of drivers has been designed to provide support for faster switchover and failover times, and authentication with Amazon Secrets Manager, Amazon Identity and Access Management (IAM), and Federated Identity. The Amazon drivers rely on monitoring DB cluster status and being aware of the cluster topology to determine the new writer. This approach reduces switchover and failover times to single-digit seconds, compared to tens of seconds for open-source drivers.

As new service features are introduced, the goal of the Amazon suite of drivers is to have built-in support for these service features.

Connecting to Multi-AZ DB clusters with the Amazon Web Services (Amazon) JDBC Driver

The Amazon Web Services (Amazon) JDBC Driver is designed as an advanced JDBC wrapper to help applications take advantage of the features of clustered databases. This wrapper is complementary to and extends the functionality of an existing JDBC driver. The driver is drop-in compatible with the following community drivers:

  • MySQL Connector/J

  • MariaDB Connector/J

  • pgJDBC

To install the Amazon JDBC Driver, append the Amazon JDBC Driver .jar file (located in the application CLASSPATH), and keep references to the respective community driver. Update the respective connection URL prefix as follows:

  • jdbc:mysql:// to jdbc:aws-wrapper:mysql://

  • jdbc:mariadb:// to jdbc:aws-wrapper:mariadb://

  • jdbc:postgresql:// to jdbc:aws-wrapper:postgresql://

For more information about the Amazon JDBC Driver and complete instructions for using it, see the Amazon Web Services (Amazon) JDBC Driver GitHub repository.

Connecting to Multi-AZ DB clusters with the Amazon Web Services (Amazon) Python Driver

The Amazon Web Services (Amazon) Python Driver is designed as an advanced Python wrapper. This wrapper is complementary to and extends the functionality of the open-source Psycopg driver. The Amazon Python Driver supports Python versions 3.8 and higher. You can install the aws-advanced-python-wrapper package using the pip command, along with the psycopg open-source packages.

For more information about the Amazon Python Driver and complete instructions for using it, see the Amazon Web Services (Amazon) Python Driver GitHub repository.