forked from avizway1/jan2021
-
Notifications
You must be signed in to change notification settings - Fork 0
/
RDS.txt
142 lines (73 loc) · 4.09 KB
/
RDS.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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
RDS : Relational Database Service
--> Data stores in tabular format.
--> Amazon Aurora : Mysql compatable & PostGreSQL compatable : Mysql workbench / Pgadmin
--> Mysql : Mysql Workbench
--> Microsoft SQL : SSMS (Sql server management studio)
--> PostGreSQL : PgAdmin
--> MariaDB : Workbench
--> Oracle : Orcle native, TOAD
--> NoSQL DB : Data stores in JSON format. : Serverless
--> DynamoDB
--> Caching :
--> Elasticache : supports 2 caching engines
--> Memcached
--> Redis
--> Datawarehousing solution
--> Amazon Redshift
--> Database Migration : DMS : Database Migration service
--> We cannot get connect and see what is happening at OS level.
--> We always run our WEB Servers and Database Servers in PRIVATE SUBNET.
--> Public Access : NO
--> We use Jump server to connect to DB instances.
--> Whenever we perform any major modification, RDS creates a backup copy automatically.
Backup retention : It keeps last 7 days backup copies.
--> For RDS instance, we will get an Endpoint, not an IP Address.
Task : Launch Mysql Databse in CustomVPC's Private SUbnet. Launch Jump server in customVPC public SUbnet, install Mysql Workbench then connect to the RDS DB.
*Make sure you follow Security group standards as we discussed.
________________________________________________________________________________________
D: 05/03/21
MultiAZ Deployment :
--> create a standby instance in Another AZ.
--> We will get same enedpoint for both the instances.
--> Multi-AZ is for DR (Disaster Recovery) purpose only.
--> Not for scaling purpose.
ReadReplica :
--> RR Designed for scaling purpose.
--> We can offload the read operations from master copy to replica copies.
--> We can create 5 Mysql replicas, 15 aurora replicas.
_____________________________________________________________________________
D: 08/03/2021
Snapshots : Backup copy of our RDS instance.
--> Point-in-time-recovery
--> It's not an Inplace restoration.
System Backups/Automated backups : Backup copies created by AWS. We cannot delete these backups.
--> Based on "Backup Retention" value we will get these Automated backups.
--> When we delete instance, these backups delete.
--> Min backup retention period : 1 Day / Defualt 7 days / Max 35 Days
Manual Backups : We need to crete manual backups.
--> WOn;t delete along with rds instance.
--> We can share this snapshot to another region / We can share to another aws account also.
--> Percona Xtra Backup is an 3rd party backup software, we can integrate with s3.
Elasticache : It's a caching service for our RDS instances.
--> Duplicated requests execuiting on RDS instance, will be delovered by this service.
--> It supprts 2 open source caching engines.
--> MemcacheD
--> Redis (it's own authentication RedisAUTH,, MultiAZ failover)
DMS : Database Migration Service :
Homogenious migration : If source and destination contains same db engine. (mysql --> mysql) Source --> DMS --> Destination
Heterogenious migration : If source and destination contains differnt db engine. (db3 --> mysql) Source --> DMS --> SCT (Schema Convertion tool) --> Destination
https://www.youtube.com/watch?v=iRhJDGp-ew8
Task : Launch RDS instance 1 in Default VPC, and restore the shared database to the RDS instance 1.
Launch another RDS instance 2 in CUstom VPC and keep it with no data.
Launch DMS instance, Create Source, destinations and Create a replication job.
--> Once job is completed, you should able to see all the data in RDS inatnce 2.
_____________________________________________________________________________________
D: 09/03/2021
DynamoDB :
--> Dynamodb is a serverless architecture.
--> We can start creating our Db tables.
--> Single digit millisecond latency at any scale.
Task : https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TicTacToe.html
DAX : DynamoDB Accelerator : In-Memory caching for our Dynamodb table.
SQL : Data stores in Table format.
NoSQL : Data stores in JSON format. (Key and Value)