Handling enterprise-grade databases with AWS

Support your most complex data analytics projects with the computing power of Amazon Aurora, an advanced relational database that was built for the cloud.

Amazon Aurora

A cutting edge relational database built for the cloud

Managing a relational database can bring frustrations to technical teams in many organisations, especially those with massive data analytics needs. In some cases, basic cloud computing options simply won’t do, the open-source alternatives could prove unsound or not fast enough, and on-premise solutions might require quite a lot of maintenance… Many IT teams also lack some technical expertise or even time to best utilise their cloud resources. 

Amazon Aurora can help organisation address these common challenges:

  • Provisioning for sustained growth
  • Protecting against data loss
  • Controlling associated costs

What is Amazon Aurora?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

A relational database for enterprise use can be quite different from a normal relational database: besides tables being more complicated, there is also a significant need for speed, reliability, availability and security; and Amazon Aurora provides just that. It is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases, at 1/10th the cost of commercial databases. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which by automating normally time-consuming, high-resource tasks (provisioning, database setup, patching and backups), efficiently meets scalability challenges, while keeping costs down.

Benefits

While performance is key to Amazon Aurora, the three key benefits to using this database revolve around simplicity, cost, and security.

Simplicity

Amazon Aurora is fully managed by Amazon Relational Database Service (RDS). The complexity when it comes to an enterprise-grade database in the cloud is usually related to the provisioning, maintenance, scaling, patching, backups, and updating. But with RDS handling all that, your team no longer needs to worry about these management tasks. 

For your staff, the initial setup looks and functions similar to an open-source database on RDS. You no longer need to worry about database management tasks such as hardware provisioning, software patching, setup, configuration, or backups. Also, thanks to the connection between Aurora and Amazon S3 (Simple Storage Service), monitoring and backups are automatic and continuous.

Cost

Scaling up your Big Data project typically depends on a significant infrastructure investment. With Amazon Aurora, you can get 5X the throughput of standard MySQL and 3X the throughput of standard PostgreSQL. This performance is on par with commercial databases, at 1/10th the cost. You can easily scale your database deployment up and down from smaller to larger instance types as your needs change, or let Aurora Serverless handle scaling automatically for you.

To scale read capacity and performance, you can add up to 15 low latency read replicas across three Availability Zones. Amazon Aurora automatically grows storage as needed, up to 64TB per database instance.

High Security

With any Big Data project, data being hacked can present a major obstacle to further development, so endpoint security is a key aspect. Amazon Aurora provides technologies like network isolation, encryption at rest using key encryption, and encryption of data in transit using SSL. Amazon Aurora also uses S3 for storage – a highly secure service, where the underlying data used for a given Big Data project is archived automatically in the same cluster. Since the database and the storage are so closely linked, data leaks are extremely unlikely to happen.

We can help

Maximising Amazon Aurora’s advantages requires the dedicated support of a trusted team. As an AWS Advanced Consulting Partner with certified AWS Database specialists, we have a robust experience in managing complex SQL and MySQL environments. Our solutions address many common challenges related to relational database service (RDS) management. So whether your concern is provisioning, data security or simply performance tuning, our AWS certified engineers have the expertise and tools to support your workloads at scale.

Contact us today

for a planning session with one of our AWS certified DBAs.