'What database driver should be used to access AWS Aurora?
What ruby database driver should be used to access AWS Aurora?
We intend to use this db as the backend for a Rails app.
amazon-web-servicesSolution 1:[1]
as stated by Amazon, Aurora is 100% compatible to MySql at the service layer, so, you should use the driver you use to connect to MySql.
Solution 2:[2]
Question was edited after this answer, this answer is for the JVM ecosystem.
At a conference at re:Invent 2016, it was mentioned that using MariaDB driver can make failovers faster since the driver register the IPs of the nodes so your application don't have to wait for DNS propagation in case of a failover.
At around the 28 minutes mark https://youtu.be/duf5uUsW3TM?t=27m40s.
Update March 5th, 2018
Since this answer, the support has been officially documented. See https://mariadb.com/kb/en/failover-and-high-availability-with-mariadb-connector-j-for-2x-driver/#specifics-for-amazon-aurora for the specifics.
Update February 11th, 2022
MariaDB driver 3.x unfortunately dropped the support for Aurora since they lacked the support of the community for PRs and testing infrastructure.
AWS is developing its own JDBC driver adapted for Aurora but it's still in preview.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | user2576266 |
| Solution 2 |