As innovators in the hosting space, we\u2019re constantly testing hardware and software solutions here at Pagely to find the optimum balance between price and performance for the unique demands of WordPress.\r\n\r\nThrough all of that testing, <a href="https:\/\/aws.amazon.com\/rds\/">Amazon RDS<\/a> emerged as the clear winner for our database solution. We've built our hosting solution on it so it's fair to say we're fans. In this post we\u2019ll give an <a href="https:\/\/pagely.com\/kb\/kb\/wordpress-aws-rds-relational-database-service">overview of RDS<\/a>, how it works, and its features and benefits.\r\n\r\nFor us, as it does for many other businesses, it comes down to a mixture of reliability, flexibility, and, most importantly of all, it integrates seamlessly with the powerful <a href="https:\/\/pagely.com\/wp-aws\/">AWS cloud ecosystem<\/a>.\r\n<h2><strong>What is RDS?<\/strong><\/h2>\r\n<iframe src="https:\/\/www.youtube.com\/embed\/eMzCI7S1P9M" width="800" height="500" frameborder="0" allowfullscreen="allowfullscreen"><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start">\ufeff<\/span><span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start">\ufeff<\/span><\/iframe>\r\n\r\nWhen Amazon Relational Database Service (RDS) <a href="https:\/\/aws.amazon.com\/blogs\/aws\/introducing-rds-the-amazon-relational-database-service\/">burst onto the scene in 2009<\/a>, it was immediately hailed as a game-changer. It was a revolutionary \u201cdatabase as a service\u201d solution that made it simple and easy to set up, manage, and scale a database that included built-in scalability, redundancy, and failover protection.\r\n\r\nOne of its biggest innovations was separating the database from the server. \u201cWhen you buy a server, you get CPU, memory, storage, and IOPS, all bundled together. With Amazon RDS, these are split apart so that you can scale them independently. If you need more CPU, less IOPS, or more storage, you can easily allocate them.\u201d <a href="https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/Welcome.html">Source<\/a>\r\n\r\nRDS is a managed solution so you won\u2019t have shell access and there\u2019s restricted access on advanced privileges but the majority of what you would need to do is handled for you so this is a non-issue in most cases.\r\n\r\n \r\n<h2><strong>RDS versus other cloud database solutions<\/strong><\/h2>\r\nWhen it comes to cloud database solutions, AWS is the industry leader by a landslide:\r\n\r\n[caption id="attachment_19974" align="aligncenter" width="871"]<img class="lazy wp-image-19974 size-full" src="https:\/\/pagely.com\/wp-content\/uploads\/2019\/05\/Image-2019-05-09-at-2.58.57-PM.png" alt="RDS market share" width="871" height="539" \/> Amazon RDS market share[\/caption]\r\n\r\n<a href="https:\/\/www.infoclutch.com\/installed-base\/cloud-computing-software\/amazon-rds\/">Source<\/a>\r\n\r\nWhile alternatives from <a href="https:\/\/cloud.google.com\/">Google<\/a>, <a href="https:\/\/azure.microsoft.com\/en-us\/free\/cloud-services\/search\/?&OCID=AID719825_SEM_iTWuFT0U&lnkd=Google_Azure_Brand&gclid=EAIaIQobChMI49OTtM764QIVlVuGCh0sZwAUEAAYASAAEgIrcvD_BwE">Microsoft<\/a>, <a href="https:\/\/cloud.oracle.com\/home">Oracle<\/a>, and <a href="https:\/\/www.ibm.com\/cloud\/">IBM<\/a> exist, they have not become as popular in spite of aggressive pricing aimed at stealing market share from AWS.\r\n\r\nRDS\u2019s preeminent advantage over other cloud database solutions is that it integrates seamlessly with AWS\u2019s robust ecosystem of cloud-based tools, services, and solutions. AWS is far and away the leading cloud provider with the most powerful, reliable, and flexible suite of cloud services that integrate flawlessly with one another.\r\n\r\nToday, Amazon offers an incomparable array of <a href="https:\/\/aws.amazon.com\/">over 170 cloud services<\/a> and continuously introduces more to complement existing services and add new functionality:\r\n<ul>\r\n \t<li>EC2 Instances<\/li>\r\n \t<li>Amazon Simple Storage Solution (S3)<\/li>\r\n \t<li>Amazon Aurora<\/li>\r\n \t<li>AWS Lambda<\/li>\r\n \t<li>Amazon LightSail<\/li>\r\n \t<li>Amazon CloudFront<\/li>\r\n \t<li>Amazon Elastic Block Store (Amazon EBS)<\/li>\r\n \t<li>Amazon Route 53<\/li>\r\n \t<li>See the <a href="https:\/\/aws.amazon.com\/">full list of services here<\/a><\/li>\r\n<\/ul>\r\nCloud services like these have become the building blocks of the internet as we know it today. These services can be combined to create powerful new solutions that are greater than the sum of their parts, like our <a href="https:\/\/pagely.com\/blog\/managed-wordpress-hosting\/">Managed WordPress Hosting<\/a>.\r\n<h2><strong>How does RDS work?<\/strong><\/h2>\r\nRDS operates within an instance (an isolated, cloud-based database environment). When you create a new database, you choose the database engine it runs.\r\n\r\nRDS is compatible with the most popular engines:\r\n<ul>\r\n \t<li>MySQL<\/li>\r\n \t<li>MariaDB<\/li>\r\n \t<li>PostgreSQL<\/li>\r\n \t<li>Oracle<\/li>\r\n \t<li>Microsoft SQL Server<\/li>\r\n \t<li><a href="https:\/\/aws.amazon.com\/rds\/aurora\/">Aurora<\/a><\/li>\r\n<\/ul>\r\nThe computation and memory resources allocated to the database are determined by what AWS calls its \u201cinstance class.\u201d As a database grows, its instance class can easily be upgraded with very little downtime to provide more resources making it a highly scalable and flexible solution.\r\n\r\nThere are currently <a href="https:\/\/en.wikipedia.org\/wiki\/Amazon_Relational_Database_Service#Current_generation">27 instance classes<\/a> to choose from with a range of resource options. Instances can have as little as 1 GB of memory up to 256 GB and provide a single processing core up to 64 cores. There\u2019s an instance class to fit pretty much every use case and all of these instance sizes are available to <a href="https:\/\/pagely.com\/">Pagely<\/a> customers so RDS is part of what makes Pagely such a flexible, customizable hosting solution for companies with unique technical demands.\r\n<h3><strong>High availability<\/strong><\/h3>\r\nFor enterprises that rely on their databases, one of the most important features offered by RDS is its <a href="https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/Concepts.MultiAZ.html">Multi-AZ (Multiple Availability Zone) option<\/a>. Two distinct copies of the database are created \u2014 a primary that handles read and write requests and a secondary that is only written to. If there is an availability issue, the secondary database is promoted into the primary role and the traffic is re-routed using DNS.\r\n\r\n<img class="lazy aligncenter wp-image-19977 size-full" src="https:\/\/pagely.com\/wp-content\/uploads\/2019\/05\/Image-2019-05-09-at-3.10.47-PM.png" alt="" width="899" height="460" \/>\r\n\r\nIt\u2019s important to note that the Multi-AZ feature is not a scaling solution because the secondary database cannot serve read traffic. For scaling, Amazon has Read Replicas.\r\n<h3><strong>Read Replicas<\/strong><\/h3>\r\nUsing Read Replicas \u201cyou can elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads.\u201d <a href="https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/USER_ReadRepl.html">Source<\/a>\r\n\r\nTo get started with Read Replicas you first pick a database that will operate as the source. A snapshot is created to duplicate the database and that duplicate version is updated whenever there is a change to the source database.\r\n\r\nNote that Read Replicas are only compatible with MariaDB, MySQL, Oracle, and PostgreSQL engines.\r\n<h2><strong>Benefits of RDS<\/strong><\/h2>\r\nRDS\u2019s feature set makes it an attractive database solution:\r\n<h3><strong>A managed solution<\/strong><\/h3>\r\nAWS takes care of backups, software patching, automatic failure detection, and recovery so your administrative burden is close to nil. They have a nearly impeccable track record in this department so you can rest easy knowing your database is being managed by experts.\r\n<h3><strong>High performance<\/strong><\/h3>\r\nRDS uses Solid State Drives (SSDs) to achieve high input\/output (IO) throughput and also has an option for Provisioned IOPS (SSD) Storage, which allows you to specify a target input\/output operations per second (IOPS) rate when creating the database instance.\r\n<h3><strong>Scalability<\/strong><\/h3>\r\nRDS users can easily and quickly scale their compute and storage resources with very little downtime. They also offer read replicas that allow users to scale out read-heavy databases.\r\n<h3><strong>Superior availability and durability<\/strong><\/h3>\r\nRDS offers automated backups for point-in-time recovery for a user-specified retention period. This means you can restore to literally any second within the retention period. In the event of a hardware failure, AWS will automatically replace the hardware on that compute instance.\r\n<h3><strong>Robust security<\/strong><\/h3>\r\nIf an instance is running with RDS encryption, the data, its backups, replicas, and snapshots are all encrypted and SSL is used to encrypt data in transit. Resource-level permissions give granular control over who has access to the database and what capabilities they have.\r\n<h3><strong>Manageability<\/strong><\/h3>\r\nAmazon <a href="https:\/\/aws.amazon.com\/cloudwatch\/">CloudWatch<\/a> is included so you\u2019ll have detailed analytics on your databases\u2019 performance at no additional charge. You can receive text and email alerts through Amazon SNS. AWS Config records and audits changes to the database config to support governance and compliance needs. Amazon\u2019s <a href="https:\/\/aws.amazon.com\/rds\/performance-insights\/">Performance Insights<\/a> makes analyzing performance data to tune your database easier than ever.\r\n\r\nIf you\u2019re already using the AWS ecosystem, there\u2019s no compelling reason to choose anything else. Even if you\u2019re not, the RDS solution offers a superior feature set, with a much longer track record of reliability, than competing solutions.\r\n\r\n \r\n\r\nAmazon RDS offers many advantages over traditional database solutions. It's flexible, reliable, and easily manageable. If you're researching RDS for WordPress website hosting, you may want to consider a <a href="https:\/\/pagely.com">Managed WordPress Hosting solution that uses RDS<\/a>, like <a href="https:\/\/pagely.com">Pagely<\/a>.\r\n\r\nPagely masks the complexity and eliminates the time costs associated with managing your own database and server. If you're interested in hassle-free WordPress hosting powered by AWS infrastructure and optimized by a team of WordPress hosting experts, <a href="https:\/\/pagely.com\/contact\/">start a discussion with our sales team<\/a> or <a href="https:\/\/pagely.com\/plans-pricing\/">see our plans and sign up here<\/a>.