본문 바로가기

전체 글345

[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 .. 2022. 1. 6.
[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.. 2022. 1. 6.
[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.. 2022. 1. 6.
My Philosophy on Alerting My Philosophy on Alerting based my observations while I was a Site Reliability Engineer at Google Author: Rob Ewaschuk Introduction Vernacular Monitor for your users Cause-based alerts are bad (but sometimes necessary) Alerting from the spout (or beyond!) Causes are still useful Tickets, Reports and Email Playbooks Tracking & Accountability You're being naïve! Summary Summary When you are auditi.. 2022. 1. 5.
[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 .. 2022. 1. 5.
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개의 데이터 페이지를 읽는다고 가정 이 경우 .. 2021. 12. 20.

티스토리툴바