Amazon Aurora - A Boost on Standard MySQL
Overall Satisfaction with Amazon Aurora
As a senior consultant I recently configured an Amazon Aurora database to serve as the back-end of an organization software. This software included a main server providing services for mobile applications and also as a back-office web application to manage transaction information. These services relied on the Amazon Aurora database to collect and save information. Customer needed a database accessible from everywhere, with high availability, fast, always up to date and scalable as it was expected the business to grow as well as its storage needs. The Amazon Aurora turned out to be a stable solution with high performance when compared with in-house solutions like MySQL.
- Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
- Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
- Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
- The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
- Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
- Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
- The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
- The database replication and schedule for backup tasks are much easier, so less prone to errors.
- We have never had a database downtime on our applications, which is essential for our customer business.
Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.