Amazon Relational Database Service: Difference between revisions

Revision as of 01:08, 8 March 2021

Revision as of 12:42, 30 April 2021

Line 29:

===Read replicas===

Read replicas allow different use cases such as to scale in for read-heavy database workloads. There are up to five replicas available for MySQL, MariaDB, and PostgreSQL. Instances use the native, [[asynchrony (computing)|asynchronous]] [[database replication|replication]] functionality of their respective database engines.<ref>{{cite web | url=http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html | title=Working with PostgreSQL, MySQL, and MariaDB Read Replicas | work=[[Amazon.com]] | access-date=2015-12-15}}</ref> They have no backups configured by default and are accessible and can be used for read scaling.<ref name="Read Replicas">{{Cite web|url=https://aws.amazon.com/rds/details/read-replicas/|title=Amazon RDS Read Replicas|website=Amazon Web Services, Inc.}}</ref> MySQL and MariaDB read replicas can be made writeable again since October 2012;<ref>{{Cite web|url=https://aws.amazon.com/blogs/aws/amazon-rds-for-mysql-promote-read-replica/|title=Amazon RDS for MySQL – Promote Read Replica|date=October 11, 2012|website=Amazon Web Services}}</ref> PostgreSQL read replicas do not support it.<ref name="Read Replicas" /> Replicas are done at database serverinstance level and do not support replication at database instance or table level.<ref>{{Cite web|url=https://stackoverflow.com/questions/18370746/can-you-replicate-a-specific-database-or-table-using-amazons-rds|title=mysql - Can you replicate a specific database or table using Amazon's RDS|website=Stack Overflow}}</ref>

===Performance metrics and monitoring===