본문 바로가기

AWS Database

(27)
RDS & Aurora 비교 https://notemusic.tistory.com/69 AWS Aurora란? [1탄 - RDS MySQL과 AWS Aurora의 큰 차이점] 항상 시작만 하고 제대로 끝마무리를 짓지 못한 상태로 티스토리를 이어가는 것 같습니다. 또 오랜만의 글인데요. 이번에는 Aurora에 대한 글입니다. AWS 상에서 Aurora를 구성하고 또 운영하시는 분 notemusic.tistory.com
[AWS Certificate]-AWS Database Encryption, Security and Auditing AWS KMS (Key Management Service) Anytime you hear "encryption" for an AWS Service, it's most likely KMS Easy way to control access to your data, AWS manages keys for us Fully integrated with IAM for authorization Seamlessly integrated into: Amazon EBS: encrypt volumes Amazon S3: Server side encryption of objects Amazon Redshift: encyrption of data Amazon RDS: encryption of data Amazon SSM: param..
[AWS Ceritificate]-Database Migration, DMS and SCT Why database migration? (Use cases) Move from legacy to cloud Switch the database solution Replicate databases across regions Replicate to streaming platforms In place DB upgrades Archive data to S3 Migration Scenarios: On-premise --> AWS Cloud Relational --> Non-relational DBs hosted on EC2 --> Nanaged AWS Services Migration tools Native tools (e.g. mysqldump) SCT (Schema Conversion Tool) AWS D..
Comparison of AWS Database Database type of data Workload Size Performance Operational overhead RDS DBs Structured Relational / OLTP / simple OLAP Low TB range Mid-to-high throughput, low latency Moderate Aurora MySQL Structured Relational / OLTP / simple OLAP Mid TB range High throughput, low latency Low-to-moderate Aurora PostgreSQL Sturctured Relational /OLTP / simple OLAP Mid TB range High throughput, low latency Low-..
Keyspaces (Cassandra) Amazon Keyspaces - overview A scalable, highly available, and fully-managed database service Lets you run. your Cassandra workloads on AWS Cassandra is an open-source, wide-column, NoSQL data store Is serverless, so you pay for what you use + autoscaling Supports thousands of requests per second with virtually unlimted throughput and storage Compatible with the CQL (Cassandra Query Language) API..
[AWS Certificate]-Amazon QLDB Amazon QLDB - Overview QLDB = Quantum Ledger Database Fully managed, serverless ledger database Has built-in, immutable journal to record all the change history of your data Transparent and cryptographically verifiable ledger Tracks each application data change and maintains a complete and verifiable history of changes over time. Supports ACID transactions Uses query lanague named PartiQL (SQL-l..
[AWS Certificate]-Amazon Timestream Amazon Timestream - Overview Fully managed, fast, scalable, serverless time-series database service Time-series data measures how things change over time Store and analyze trillions of time-ordered events per day 1,000x faster query performance at 1/10th the cost of relational databases Automates rollups, retention, tiering, and compression of data Use cases: Log data for DevOps Sensor data for ..
[AWS Certificate]-Amazon Elasticsearch Service Amazon Elasticsearch Service - Overview May be called Amazon ES at the exam Managed version of ElasticSearch (Open source project) The ELK Stack on AWS Cloud ( ElasticSearch + Logstash + Kibana) ElasticSearch - provides search and indexing functionality Logstash - provides log ingestion mechanism, alternative to CloudWatch Logs Kibana - provides real-time dashboards for ES data, is a visualizati..