Building and managing a highly available relational database system is not a trivial task. It involves the time-consuming...
tasks of building servers, installing software, configuring networking, enabling replication and dealing with manual failovers during system maintenance.
Amazon Relational Database Service (RDS) allows developers to not only run common database server engines such as MySQL, MariaDB, Oracle, Microsoft SQL Server and PostgreSQL, but also to easily deploy applications to multiple Availability Zones (AZs) through Amazon RDS replication.
With Amazon RDS Multi-AZ deployments, developers provision a database instance; behind the scenes, AWS configures a standby instance in another AZ that receives database updates from the primary server through synchronous replication. The RDS web-based console enables developers to create a new database instance, choose a database engine and select the option to enable Multi-AZ deployments.
AWS manages backup and patching with RDS and Multi-AZ deployments automatically failover database services to a standby instance during maintenance periods or when issues arise (e.g., availability zone outages, hardware failures, network disruption or storage issues).
AWS Security Quiz
With the increasing number of public cloud security breaches, it's important to make sure your AWS account is protected. Take our 10 question security quiz to find out how much you know about protecting your data and which security tools are offered by Amazon Web Services.
RDS database instances have a single DNS endpoint from which applications connect to the database server. Whether the RDS database instance is publicly available or private to the systems within an Amazon Virtual Private Cloud, AWS updates the DNS record during the failover process. During failover, there's no need to modify clients and application servers that have been pointed to the RDS database instance; no manual intervention is required.
In addition to common database engine options, AWS also offers Amazon Aurora through RDS. Aurora is an SSD-backed database system that is highly scalable and durable. AWS handles automatic Amazon RDS replication of data six different ways across three AZs. It supports five times the throughput of MySQL and up to 64 TB of auto scaling storage. Aurora also enables IT teams to create Amazon RDS replication of a database in a secondary AZ to enable a Multi-AZ deployment. Based on those features, and the fact that it is a MySQL compatible database, Aurora is now the recommended database engine for running managed relation database services on AWS.
Evaluate your Amazon RDS engine options
Where to look when AWS databases aren't cutting it
Plot out a thorough DR strategy to mitigate outage damage
Dig Deeper on AWS database management
Related Q&A from Mike Pfeiffer
We use Amazon CloudWatch to track cloud performance and create notifications for service metrics. How can we automate events to respond to the ... Continue Reading
Runbooks help admins automate certain processes within the Azure cloud. But what capabilities do I gain if I kick-off Azure runbooks through a ... Continue Reading
Our enterprise wants to create a central repository for users and groups to facilitate a cloud implementation. What directory choices do we have with... Continue Reading