본문 바로가기

AWS Database

 (27)
[AWS Certificate]-DynamoDB Accelerator (DAX) DAX(DynamoDB Accelerator)란 In-Memory Caching, microsecond latency Sits between DynamoDB and Client Application (acts a proxy) Saves costs due to reduced read load on DynamoDB Helps prevent hot partitions Minimal code changes required to add DAX to your existing DynamoDB app Supports only eventual consistency (strong consistency requests pass-through to DynamoDB) Not for write-heavy applications ..
[AWS Certificate]-DynamoDB Storing Larger Item DynamoDB - Storing larger items DynamoDB supports item sizes up to 400 KB each This includes attribute name and attribute value (=entire JSON object) Options for storing larger items Compress large attribute values, OR Store large attribute values in S3 and store the corresponding S3 path in DynamoDB DynamoDB - Large Objects Pattern DynamoDB - Indexing S3 objects metadata DynamoDB Operations Tab..
[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..
[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..
[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를 통..
[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..

티스토리툴바