AWS Database/AWS RDS & Aurora
[AWS Certificate]-Amazon RDS Good thing to know
Clark Shim
2022. 1. 6. 12:24
- 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
Amazon Aurora MySQL 모범 사례 - Amazon Aurora
Aurora MySQL 1.22 이전 버전의 경우, Aurora MySQL 1 버전에서 해시 조인을 활성화하는 방법은 aurora_lab_mode 세션 수준 설정을 사용하는 것입니다. 이러한 Aurora MySQL 버전에서는 해시 조인에 대한 optimizer_sw
docs.aws.amazon.com