Search code examples
amazon-web-servicesjdbcamazon-aurora

Can I use aws-advanced-jdbc-wrapper with MySQL?


My com has two environments.

  • dev: MySQL Community with no cluster
  • qa: Aurora MySQL cluster.

I'm planning to use aws-advanced-jdbc-wrapper with my new application.

Can I use the driver with both environments?


Solution

  • Yes, you can use the AWS JDBC Driver with both environments. The driver is designed to work with MySQL-compatible databases, like MySQL Community and Amazon Aurora MySQL.

    However, there could be some Performance Considerations: Some features optimized for Aurora (e.g., cluster topology discovery) might add minor overhead in a standalone MySQL setup.

    If you’re using the same JDBC URL format and connection properties in both environments, it should work seamlessly. However, your connection strings may differ slightly between environments. For Aurora, you'll likely use the cluster endpoint, while in dev, you'll connect directly to the standalone MySQL instance