본문 바로가기

AWS Database/AWS RDS & Aurora

 (7)
RDS & Aurora 비교 https://notemusic.tistory.com/69 AWS Aurora란? [1탄 - RDS MySQL과 AWS Aurora의 큰 차이점] 항상 시작만 하고 제대로 끝마무리를 짓지 못한 상태로 티스토리를 이어가는 것 같습니다. 또 오랜만의 글인데요. 이번에는 Aurora에 대한 글입니다. AWS 상에서 Aurora를 구성하고 또 운영하시는 분 notemusic.tistory.com
[AWS Certificate]-Amazon Aurora MySQL and PostgreSQL-compatible relational database in the cloud (that means your drivers will work as if Aurora was a Postgres or MySQL DB) 5x faster than standard MySQL databases 3x faster than standard PostgreSQL databases 1/10th the cost of commerical-grade RDBMS Up to 15 read replicas (Multi AZ, Auto Scaling Read Replicas) "Aurora Serverless" (Automatic start/stop, Autoscaling, Self-healing..
[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 ..
[AWS Certificate]-Amazon RDS Monitoring and Logs RDS Monitoring Common metrics CPU, RAM, disk space consumption, Network traffic, DB Connection, IOPS metrics Native logs / extensions e.g. pgaudit extension in PostgreSQL for auditing (DML, DCL, DDL, etc) Manual Monitoring Tools RDS console (DB Connections, R/W ops, storage consumption, memory utilization, N/W traffic) AWS Trusted Advisor (cost optimization, security, fault tolerance, performanc..
[AWS Certificate]-Amazon RDS Replication & DR Multi-AZ Deployments in RDS For high availability, data durability and fault-tolerance (not used for scaling) Offers SYNC replication to standby instance in another AZ over low latency links Performs automatic failover to standby instance in another AZ in case of planned or unplanned outage Uses DNS routing to point to the new master (no need to update connection strings) Failover time (RTO) are..
[AWS Certificate]-Amazon RDS Backup & Restore RDS Backup RDS Supports automatic backups Capture transaction logs in real time Enabled by default with a 7-days retention period (0-35 days retention, 0=disable automatic backups) You can provide backup window (daily time range) and backup retention period (no. of days) The first backup is a full backup. Subsequent backups are incremental Data is stored in a S3 bucket (owned and managed by RDS ..
AWS RDS Aurora 스토리지 및 IO 비용 계산 1. 기본 요금 정책 Region: 아시아 태평양(서울) 스토리지 요금 월별 GB당 0.12 USD I/O 요금 1백만 요청당 0.24 USD 2. 예시 기준 DB: RDS Aurora 기간: 30일 사용량: 1,000GB 매일 2%, 20G 용량 증가 2.1 용량 기준 비용 예시 이때 요금은 해당월의 남은 일수 기준으로 비례하여 부과 즉, 용량에 관한 요금은 30일간 1,000GB의 요금 부과 29일간 추가 20GB의 요금 부과 28일간 추가 20GB의 요금 부과 ... 총 1,290GB가 되고 총 요금은 129USD 2.2 IO 기준 비용 예시 IO 관련 요금은 Read I/O: 동일한 데이터베이스에서 실행되는 쿼리를 충족히가 위해 스토리지에서 초당 100개의 데이터 페이지를 읽는다고 가정 이 경우 ..

티스토리툴바