Please enable JavaScript.
Coggle requires JavaScript to display documents.
DB on AWS :star: (RDS (MS SQL (Port 1433), Oracle (Port 1521), MySQL (Port…
DB on AWS :star:
RDS
MS SQL
Port 1433
Oracle
Port 1521
MySQL
Port 3306
PostGreSQL
Amazon Aurora
Port 3306
Maria DB
Aurora
2 copies in each AZ, at least 3 AZs
Use Cluster Endpoint in attachment strings
MySQL Compatible
Replica Types
Aurora Replicas
up to 15 replicas
Tier 1-15 for failover
Automatic Failover
MySQL Read Replica
Up to 5 Replicas
Manual Failover
Scales in 10GB Increments
Pricing
Amazon Redshift DW
Pricing
Configurations
Single Node
Leader and Computer on one Node
Multi-node
1 Leader Node - not charged
Compute Nodes (up to 128)
Columnar Data Store
Advanced Columnar Based Compression
Massively Parellel Processing (MPP)
DynamoDB
JSON Format
Consistency
Eventual =~ 1 second
Best read performance
Strict - Transactional < 1 sec
Most consistent
Elasticache
memcached
Redis
DB Concepts
OLAP vs OLTP
Relational vs NoSQL
NoSQL
Collection
Document
Key-Value Pairs
Relational
Table
Row
Fields
Multi AZ
Backups