Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 751
Rpj Avatar asked Jul 06 '15 16:07

Rpj


1 Answers

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.

like image 144
jebeaudet Avatar answered Oct 02 '22 14:10

jebeaudet