-
Notifications
You must be signed in to change notification settings - Fork 63
/
databases.txt
92 lines (77 loc) · 1.98 KB
/
databases.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
AWS Database Types
RDS - OTLP (Online Transaction Processing)
- SQL Server
- Oracle
- MySQL
- PostgreSQL
- Amazon Aurora
- MariaDB
- DynamoDB
- RedShift OLAP (Online Analytics Processing, Datawarehousing)
- Elasticache
Non-Relational Database Structure
- Database
- Collection (table)
- Document (row)
- Key/Value Pairs (fields)
Data Warehousing
- Used for Business Intelligence (Cognos, Jaspersoft, etc.)
- OLTP Vs. OLAP
--- OLTP (Online Transaction Processing)
--- --- Order number 2120121
--- --- Pulls up a row of data (name, date, address, status)
--- OLAP (Online Analytics Processing, used for Datawarehousing)
--- --- Pull in large number of records
--- --- Uses different type of architecture for database and infrastructure
Elasticache
- Web service that makes it easy to deploy, operate, and scale in-memory cache in the cloud
- Types
- Memcached
- Redis
Summary
Database Types
- RDS (OLTP)
- SQL
- MySQL
- PostgreSQL
- Oracle
- Aurora
- MariaDB
- DynamoDB (NoSQL)
- RedShift (OLAP)
- Elasticache (in-memory)
- Memcached
- Redis
Multi-AZ
- Used for DR
- Not used for performance gains
Read Replicas
- Used for scaling, performance gains
- You can have up to five Read Replicas
Aurora scaling
- 2 copies of data in each AZ, 3 AZ's minimunm (total of 6 copies)
- Designed to handle losses transparently
- Self-healing storage
Aurora Replicas
- Up to 15 Replicas
MySQL Replicas
- Up to 5 Replicas
DynamoDB vs RDS
- DynamoDB offers "push button" scaling
- RDS requires bigger instance size or to add Read Replica
DynamoDB
- stored on SSD storage
- spread across 3 geographically distinc data centers
- Types
- eventually consistent reads (default)
- strongly consistent reads
Redshift Configuration
- Single Node (160GB)
- Multi-Node
- Leader Node (manages client connections)
- Compute Node (stores data, performs queries, up to 128 nodes)
Elasticache
- Memcached
- Multi-AZ NOT available
- Redis
- Multi-AZ available