- Read replica can be made writable (for MySQL/MariaDB)
- For other engines
- read replica cannot be made writable, but you can promote it to make it writable
- For Oracle and SQL Server
- Automatic backups or manual snapshots are not supported on the replica
- For Oracle
- Does not yet support Oracle RAC (a cluster DB with a shared cache archtiecture)
- For SQL Server
- Supports both Multi-AZ options - Database Mirroring and Always On
- For PostgreSQL
- Only manual snapshots are supported on the replica (no automatic backups)
- Set log retention with parameter rds.log_retention_period
- For MySQL/MariaDB
- Set log retention with stored procedures
- e.g. call mysql.rds_set_configuration("binlog retention hours', 24);
https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html
'AWS Database > AWS RDS & Aurora' 카테고리의 다른 글
RDS & Aurora 비교 (1) | 2022.02.08 |
---|---|
[AWS Certificate]-Amazon Aurora (0) | 2022.01.06 |
[AWS Certificate]-Amazon RDS Monitoring and Logs (0) | 2022.01.06 |
[AWS Certificate]-Amazon RDS Replication & DR (0) | 2022.01.06 |
[AWS Certificate]-Amazon RDS Backup & Restore (0) | 2022.01.05 |