본문 바로가기

AWS Database27

[AWS Certificate]-DynamoDB Best Practice DynamoDB Best Practices Efficient Key Design Partition key should have many unique values Distribute reads / writes uniformly across partitions to avoid hot partitions Store hot and cold data in separate tables Consider all possible query patterns to eliminate use of scans and filters Choose sort key depending on your application's needs Use indexes based on when your application's query pattern.. 2022. 1. 8.
[AWS Certificate]-DynamoDB Partition DynamoDB Partitions Store DynamoDB table data (physically) Each (physical) partition = 10GB SSD volume Not to be confused with table's partition/hash key (which is a logical partition) One partition can store items with multiple partition keys A table can have multiple partitions Number of table partitions depend on its size and provisioned capacity Managed internally by DynamoDB Provisioned cap.. 2022. 1. 8.
[AWS Certificate]-DynamoDB Amazon DynamoDB - Overview Non-relational Key-Value store 클라우드 완전 관리형, 서버리스, NoSQL 데이터베이스 Fast, Flexible, Cost-effective, Fault Tolerant, Secure Multi-region, multi-master database (Global Tables) Backup and restore with PITR (Point-in-time Recovery) 모든 규모에서 한 자리수 밀리초 성능 제공(Single-digit millisecond performance at any scale) DAX를 사용한 In-memory 캐싱 (DynamoDB Accelerator, microsecond latency) API를 통.. 2022. 1. 8.
[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.. 2022. 1. 6.
[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.

티스토리툴바