We have looked at storage and server options from Amazon.  Thus, now it is time to look at one the database options.  Amazon Aurora is a relational database solution that is an excellent step up from MySQL.

Easy To Use

Aurora is currently MySQL compatible, and they are working on a PostgreSQL version as well.  This offering means that you can use all of your tools and knowledge with MySQL to administer and develop on Aurora.  There is no need to think of an Aurora solution as anything other than a production MySQL database.  An instance can be brought up in minutes.  The size and power, along with credentials, is all you need to get started.

An Enterprise Solution

Of course, this Begs the question, why use Aurora when MySQL is available?  It is due to the high-end features provided for an Aurora instance.  MySQL is perfect for development and can easily be utilized on a free tier server.  However, when it is time to go to production, there are measures that are worth taking.  These steps include security related features like encryption at rest and stability features like a distributed server in multiple zones.  Aurora has all of these features and highly available backup included as part of the solution.

You Get What You Pay For

It is important to note that there is no free tier option for Aurora.  If the free tier is what you want, then look at MySQL on EC2 or MariaDB.  We look at these in other posts.  The ability to transition from these free options to Aurora is one of its strengths.  Development and testing can be done at no cost.  Thus, there is plenty of money available to provide the best production solution.  The low-end version of Aurora runs about $10 per month and goes up in cost based on size and speed of the environment.  Therefore it is entirely affordable for even a small company that needs to comply with costly regulations.  This solution is perfect for those that need to be HIPPA or PCI/DSS compliant.
Amazon offers several database solutions.  There are relational and NoSQL options among a lengthy list of services.  Aurora is one of the options to consider for any company that wants to be comfortable with their chosen method to store data.

Rob Broadhead

Rob is a founder of, and frequent contributor to, Develpreneur. This includes the Building Better Developers podcast. He is also a lifetime learner as a developer, designer, and manager of software solutions. Rob is the founder of RB Consulting and has managed to author a book about his family experiences and a few about becoming a better developer. In his free time, he stays busy raising five children (although they have grown into adults). When he has a chance to breathe, he is on the ice playing hockey to relax or working on his ballroom dance skills.

Leave a Reply