The Problem: Your MySQL databases are growing, but the users expect and demand top performance and reliability. these usually come with a price tag of commercial databases. So how do you keep MySQL low cost that?
The solution is Amazon Aurora, Amazon Aurora is a MySQL compatible relational database.
Amazon has taken the good old MySQL open source database and developed an engine that provides speed and availability that compete with commercial databases
Existing MySQL applications can be migrated and run on Aurora, the transition might require small or no change at all
Any Application that runs or developed in MySQL 5.6, any code applications drivers and tools used today MySQL databases can be utilized with Aurora.
Aurora Price and Performance Problem
The Amazon RDS delivers a consistent baseline of 3 IOPS per Provisioned GB this allow you to burst up to 3,000 IOPS that mean he can handle up 3000 Input/Output operations per second.
Amazon says Aurora’s 5x that speed.
When we review AWS customers that use AWS Aurora, they report that queries per second on a high traffic were able to achieve between 5% to 50% increase in speed.
It seems that when working with AWS experts reviewing the specific application query’s that I/O AWS Aurora they were able to achieve better performance, so plan that onto your migration into AWS Aurora
You need to make sure you understand the improved ‘IOPS’ cost, the AWS Aurora storage cost is higher so make sure you plan it correct.
So Why not just use standard MySQL?
- Aurora is five times faster from standard MySQL running on the same hardware.
- Stability performance -Amazon is working very hard to develop a code that promises consistent performance.
- Security. Aurora implement security for your database by integrating the AWS security tools: Amazon VPC for isolating your network, Encryption using AWS key management, Aurora instance are encrypted.
- Hige Availability and DR solution, Aurora storage is an AWS service so Amazon is maintaining six copies of your data across three availability zones and continuously backed up to Amazon s3.
Six easy steps to start with AWS Aurora:
- Sign up in the Aurora details page or through the AWS management console.
- In AWS Management Console on the services menu click RDS.
- on the “Select Engine” screen select the Amazon Aurora Option.
- Configure the DB settings and press Next
- In the next screen, you can select various options to link the DB to storage and VPC network that already exist or just create new.
- Click Launch DB Instance.In about a minute your new DB server will be available.
If you would like to learn more on AWS Aurora, I recommend the following AWS re: Invent 2015 lecture “Amazon Aurora Deep Dive” Video