Amazon Web Services (AWS) is a global computing, storage, database, analytics, application, and deployment service. As part of their offering, AWS offers a relational database solution, RDS. Here are just a few reasons why we love AWS RDS (especially for MySQL).
1. Scale — Vertically or Horizontally.
If you want to set up, operate, and scale a relational database in the cloud, Amazon RDS is an excellent option for keeping up with the increasing demands of your application or applications. To scale your RDS instance vertically, you can resize your instance type and apply the change immediately. And for scaling your database horizontally, you can use read replicas and add a load balancer between your application and database servers, both of which improve the performance of a read-heavy database.
2. Multi-database support for structured data.
With support for six popular database engines — Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server — Amazon RDS is an excellent option for storing structured data. We especially like that AWS RDS supports MySQL, the most popular open source database in the world.
As a web service running “in the cloud”, RDS lets you simplify the setup, operation, and scaling of a relational database for use in applications. This ease of use is a huge benefit for DevOps specialists, engineering managers, and developers.
4. Automatic Management.
One thing we love about Amazon RDS is that we don’t have to worry about patching the database software, backing up databases, replication, or enabling point-in-time recovery. All these tasks are managed automatically — and with a single API call.
5. Robust MySQL Support.
MySQL is the world's most popular open source relational database. By hosting Fusion with Amazon RDS, we can scale MySQL databases in the cloud without getting caught up in database administration tasks. As of October 2018, Amazon RDS for MySQL supports the latest version, MySQL 8.0, in all AWS Regions.
6. Minimal Downtime.
Importing Data to an Amazon RDS MySQL instance is easy to do without significant downtime. You can move data in and out of Amazon RDS using backup files, Amazon S3, or import data from an external MySQL database that supports a live application to an Amazon RDS MySQL. So whether you’re transferring a copy of your database to an EC2 instance, replication is straightforward and lightweight, with little downtime.
Hosting data on AWS helps organizations to move faster and scale at lower costs. Compared to other solutions, RDS is highly affordable. You can pay for your database by the hour with no long-term commitments or upfront fees, which means you don’t have to buy database capacity ahead of time. This pay-as-you-go model is ideal for development, test and other short-lived workloads.
8. Speed & Performance.
Amazon RDS Performance Insights helps us tune and monitor database load to determine when and where to take action with an easy-to-understand dashboard. Because DB load condenses the overall performance health of a MySQL database into a single metric that reflects the level of stress on a system, we can ensure our data warehouses import records faster every day.
9. Automated Backup.
Amazon RDS for MySQL creates a backup of our data warehouses and restores the backup file onto a new Amazon RDS DB instance running MySQL. This functionality automatically performs a full daily snapshot of a database’s data (during a preferred window of time set up by the user). It also captures your transaction logs as well as any updates to your RDS database.
Security with Amazon RDS is also top notch. We get Amazon VPC, encryption at rest, certificates signed by a certificate authority, and SSL connections with DB instances running the MySQL database engine, a safeguard against spoofing attacks.
In summary, AWS RDS is a maintenance-free system. With it, you don’t have to provision hardware, patch software, backup data, or manage read replicas. You can switch to a larger instance when you need, with automatic scaling, up or down, vertically or horizontally, with world class performance. ♦
Fusion is a cloud data warehouse whose MySQL database is hosted on AWS RDS. If you’d like to take it for a free test drive, you can do so for free by creating your account today.