5

I'm exploring the possibility of using Aurora as a database backend for a large-ish Drupal 7 site because of the potential performance gains. Before I do that, though, I'd like to know if there are any outstanding issues with this kind of setup.

So far, the only resource I've found are this fixed Drupal.org issue and a number of rather old questions on this site. I'm still a bit concerned because the Aurora FAQ states:

Q: What does "MySQL-compatible" mean?

It means that most of the code, applications, drivers and tools you already use today with your MySQL databases can be used with Aurora with little or no change. The Amazon Aurora database engine is designed to be wire-compatible with MySQL 5.6 using the InnoDB storage engine. Certain MySQL features like the MyISAM storage engine are not available with Amazon Aurora.

(Emphasis mine)

It's the "most" that has me worried, specifically. Are there any pitfalls when using Drupal 7 with Aurora?

  • Welcome to Drupal Answers! How much a database engine is compatible with MySQL is not a Drupal-specific question. – kiamlaluno Nov 15 '16 at 17:36
  • 1
    @kiamlaluno I'm asking specifically whether any incompatibility between Aurora and MySQL affects Drupal, not how compatible it is with MySQL. If I were asking that, I'd post to the DBA StackExchange. – Jules Nov 15 '16 at 17:55
  • Since Drupal uses the PDO classes PHP has, your question gets the same answer it would be given for a plain PHP application using the same classes. If the FAQ doesn't list which features aren't compatible with MySQL, I am not sure in which way we could know that. – kiamlaluno Nov 16 '16 at 8:13
  • If you are worried about some modules not working fine with Aurora, you could test those modules with a site using that database engine. A generic answer about that is not possible. – kiamlaluno Nov 16 '16 at 8:13
  • 1
    I am not sure in which way we could know that. Honestly, I was hoping people could speak from experienced because of the lack of details on the page -- but you make a good point. I'll post to DBA.SE if this question doesn't get answers in the next few hours. – Jules Nov 16 '16 at 16:05
3

Aurora isn't widely used in the community, but all the materials I've seen say it works (like this post).

To test a setup using AWS you could use the test drives setup by Acquia. I'm not sure if they are running Aurora on those or not, but it is probably worth a look.

As for testing custom modules there is a degree to which you cannot know until you either check a module and test it out, but most Drupal 7 contrib modules make use of Drupal's internal query APIs and therefore should not present issues on Aurora.

6

We are running a couple of projects on Amazon Aurora with no issues so far. Our largest project is a D7 project with many contributed modules, and a large amount of data being moved.

We've never noticed any DB related issues aside from normal MySQLisms. It's really transparent to Drupal. We use normal Mysql connection strings and zero core changes.

Aurora is more expensive. A lot more expensive. It only starts at the db.r3.large tier, and works out to a monthly (non upfront rate of 0.190 per hour). So the price difference must be considered.

  • This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review – Shawn Conn Nov 22 '16 at 1:26
  • 5
    I contest that. He is asking if Amazon Aurora has any issues with Drupal I stated that I use Amazon Aurora on a number of projects with no issues. How is this not an answer? – Remog Nov 22 '16 at 2:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.