반응형
2024년 SAA-C03 자격증 준비하면서 필요한 노트 정리했습니다
강의는 유데미 "Ultimate AWS Certified Solutions Architect Associate SAA-C03" 통해 공부했습니다
https://www.udemy.com/course/aws-certified-solutions-architect-associate-saa-c03
같이 공부해서 합격해보자구요 !
Section 9 : AWS Fundamentals : RDS + Aurora + ElastiCache
87. Amazon RDS Overview
- rds - relational database service
- db, use sql as a query language
- rds vs db on ec2
- rds is managed, automated provisioning, os patching
- continues backup & restore to specific timestamp
- monitoring
- multi az setup
- scaling capability
- backed up by ebs
- cant ssh into your instance**, it's managed by aws
- rds - storage auto scaling
- increase storage of db instance dynamically
- avoid manually scaling your db storage
- need to set maximum storage threshold (max limit for db stroage)
- useful for : unpredictable workloads
- supports all rds db engines
88. RDS Read Replicas for scalability
- Read replicas
- up to 15 read replicas
- within az, cross az or cross region
- replication is async
- application must update the connectino string to leverage read replicas
- use cases
- you need to runa reporting application to run some analytics, what should you do that will not effect the product env ?
- rds read replicas because only select from db is necessary hence the perfect solution for read replicas. it will not effect prod env traffic as well. it might be async in replication but it will be same eventually
- read replicas are used only for SELECT only kind of statements (not INSERT, UPDATE, DELETE)
- you need to runa reporting application to run some analytics, what should you do that will not effect the product env ?
- network cost
- there is always a network cost when data goes to from one az to another
- but for rds read replicas, if there are in the same region it will be free
- BUT if replicas is done for a different region, it will cost fee
- ex. east-1a -> replication to -> east-1b = free
- ex. east-1a -> replication to -> west-1b = not free
- RDS multi az (diaster recovery)
- sync replication
- one dns name
- increase availability
- not used for scaling
- the read replicas can be setup as multi az for disaster recovery
- from single az to multi az
- zero downtime operation
- a snap shot is taken
- a new db is restored form the snapshot in a new az
- synchronization is established between two databases
90. RDS custom for oracle and microsoft sql server
- can access the underlying ec2 instance with ssh
- de-activate automation mode
- take db snapshot before perform rds custom
- rds - entire db and os is managed by asws
- rds custom - full admin access to user
91. Amazon Aurora
- storage automatically grows
- costs more than 20% than rds
- high availability and read scaling
- 6 copies of your data across 3 az
- shared storage volume
- backtrack : restore data at any point of time without backups
93. Amazon Aurora - advanced concepts
- custom endpoints - the reader endpoints is generally not used after defining custom endpoints
- aurora serverless - automated database instantiation and auto scaling based on actual usage, pay per second, good for unpredicatable workloads
- global aurora - useful for diaster recovery, simple, cross-region replication takes less than 1 sec
94. RDS & Aurora - backups and monitoring
- Rds backups / aurora backups
- automated backups
- backed up every 5 minutes
- 1 ~ 35 days retention and will be deleted afterwards
- manual db snapshots
- manual
- backedup as long as needed
- trick : if you have stopped rds db, you still pay for storage. take snapshot and delete the db, restore it once needed to minimize costs
- automated backups
- aurora db cloning
- faster than snapshot and restore
- useful to create a staging db from production db without impact on product env
94. RDS Security
같이 파이팅해서 합격해봅시당 ㅎㅎ
저는 24년 10월 중순에 시험 볼 예정입니다 ! (후기 남기도록 하겠습니다 후후)
토니이츠얼랏 : 네이버 블로그
너무너무너무 많이 먹는 토니입니당 :) 개발 블로그도 방문해주세용 (제꺼에요 :p) https://tonyzorz.tistory.com/
blog.naver.com
반응형
