본문 바로가기

AWS Database/AWS RDS & Aurora

[AWS Certificate]-Amazon RDS Good thing to know

  • 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