Availability

                  AWS RDS is a highly available relational database that offers a feature called Multi-AZ, which provides a SLA up-time of 99.95%. With the Multi-AZ feature enabled in a production database, AWS provides a synchronous “standby” replica of every database in another “zone.” Since both the database and its replica are in sync, there is no chance of data loss.

                  AWS also offers a domain name server (DNS) to access RDS, so even if the master database instance goes down, an RDS automatic failover mechanism will change the master DNS to a replica in order to achieve high availability.

Scalability

                  Database scalability can prove to be a real challenge if you try to scale your own, self-hosted database. Handling mandatory down times due to upgrades or infrastructure requirements can be quite tricky and is just the beginning of your scalability responsibilities. That is why one of AWS RDS key advantages is its scaling service. Moreover, MySQL RDS offers two levels of scalability features: vertical and horizontal.

            Vertical Scalability /Scaling Up – With RDS, Amazon enables push-button vertical scaling. This means that you can scale the size of an RDS instance [memory, CPU, PIOPS etc] or disk, either up or down, with the click of a button. AWS may need to stop the instance for vertical scaling, but if you have enabled the Multi-AZ feature, AWS will apply any scaling to your replicas first to ensure that they are available for use when the master is being scaled. AWS also offers the option to either configure immediate scaling or scale during weekly maintenance during non-peak hours.

            Horizontal Scalability /Scaling Out – Horizontal scalability is an approach that distributes the total database across many RDS instances that will work together.RDS MySQL offers read replica functionality using MySQL’s built-in replication feature, offering read-only database instances to serve read traffic. In order to achieve true database elasticity, a database needs to scale out beyond a simple master-slave set-up.  Amazon recommends that data be distributed across multiple RDS instances. This way, each RDS contains a portion of the complete database. By utilizing ScaleBase’s AWS AMI, you can create a real distributed relational database with many RDS instances working together as one, and without making modifications to your application. This brings you massive horizontal scaling, and after scaling out to a distributed RDS database, all AWS value-added services continue to work.

Performance

                  AWS RDS offers PIOPS (Provisioned IOPS) in order to achieve fast, consistent and predictable Input/Output (I/O) performance. This is ideal for online transaction processing (OLTP) databases or high I/O centric applications. With MySQL RDS, you can set up as many as 30,000 IOPS. The more IOPS you have set up, the more concurrent request processes increase, which in turn increases throughput and decreases latency to achieve higher database performance.

Backup

                  AWS RDS provides two types of backup mechanisms which are both very easy to setup:

            Automated backup – 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.

            Point-in-Time snapshots – RDS database snapshots are user initiated. Unlike automated backup, which is performed once a day, point-in-time snapshots can be performed as many times as desired. Generally, they are useful to backup set database states, like before a major release or an application upgrade.

Security

                  RDS provides same default configurations, which prevents the security missteps that occur during system set-up. Additionally, RDS provides security groups, enabling control over incoming/outgoing traffic.

More>>

Tags:

Amazon RDSAWSMySQL

RECENT PROJECTS