Amazon Aurora

The advantages are many and many, and it is easy to use and safe. as for the problems, they are few and do not affect the user, such as the difficulty of using it at the beginning, and this is not a problem from my point of view, because this problem is present in the program, application and site .

Years ago, as our product and userbase grew enough that basic RDS wasn't cutting it, our IT team was surprised at how affordable the move to Aurora was, considering all the improvements. We've never looked back and don't have to spend nearly any working hours on scaling, migrations, and backups. We couldn't do what we do with out it.

Amazon Aurora has been very useful in my projects, as we have production workloads running queries on millions of records, and so far the performance has been good and very consistent. We have practically not had to worry about database administration tasks, and most of the management is done very easily through the console.

We had been on RDS for a number of years, happily running mySQL, when Aurora came out. The timing felt good: Oracle was just about buy mySQL (I think - not 100% sure on timing), so we were already feeling a bit edgy about what future support for mySQL was going to cost. It was hyped as a cheaper, faster alternative to mySQL -- and once we dipped our toes in the water, we discovered that's pretty much exactly what it is. We run a number of enterprise-class websites on an RDBMS backend, and we migrated from mySQL to Aurora within a few weeks. It was as simple as running database dumps, importing them into Aurora, and changing the pointers. Really. The interfaces are all identical, we didn't have to change any code at all (except for one thing -- see below), and once we cut over, it just worked. Which is basically what you want from your database. I'm very happy we switched over, and honestly, I still just kind of think of our database as mySQL. I use mySQL GUI tools to connect to it, write regular mySQL SQL queries to interact with it, and everything else just feels like the mySQL I grew up with. Only it's significantly cheaper, and feels faster. Win. The only caveat: there was one plugin we had in our mySQL install (it was a thing that let you do Levenshtein distance calculations) that was incompatible with Aurora. The plugin didn't exist. If you have a SUPER customized mySQL setup, look into whether Aurora supports all you do. But for us we never looked back.