1 00:00:00,330 --> 00:00:01,620 So let's do a summary 2 00:00:01,620 --> 00:00:04,620 of what we learned in the Amazon RDS section. 3 00:00:04,620 --> 00:00:07,050 And if you need to go back into any of these points 4 00:00:07,050 --> 00:00:09,030 I suggest you go back to the old lectures. 5 00:00:09,030 --> 00:00:10,982 This here's a summary to summarize what you should know 6 00:00:10,982 --> 00:00:12,990 out of Amazon RDS. 7 00:00:12,990 --> 00:00:15,630 So this is a managed PostgreSQL 8 00:00:15,630 --> 00:00:18,900 MySQL or Oracle, SQL server, MariaDB 9 00:00:18,900 --> 00:00:22,410 or you have the custom version of RDS. 10 00:00:22,410 --> 00:00:25,671 In Amazon RDS you need to provision an RDS instant size 11 00:00:25,671 --> 00:00:28,560 as well as an EBS volume type and size. 12 00:00:28,560 --> 00:00:30,270 So everything is provisioned. 13 00:00:30,270 --> 00:00:32,940 Although you have auto-scaling capability 14 00:00:32,940 --> 00:00:35,460 for the storage layer. 15 00:00:35,460 --> 00:00:37,590 Amazon RDS supports read replicas 16 00:00:37,590 --> 00:00:39,450 to scale read capabilities. 17 00:00:39,450 --> 00:00:42,810 So if you have applications that need to run analytics 18 00:00:42,810 --> 00:00:44,280 against a production database 19 00:00:44,280 --> 00:00:46,620 it is much better to create a read replica. 20 00:00:46,620 --> 00:00:48,420 And for high availability purposes 21 00:00:48,420 --> 00:00:52,050 you can use the multi AZ to have a standby database. 22 00:00:52,050 --> 00:00:54,900 Although that database is just here for 23 00:00:54,900 --> 00:00:56,160 in case a disaster strikes. 24 00:00:56,160 --> 00:00:59,610 You cannot use it to perform queries against it. 25 00:00:59,610 --> 00:01:03,510 Security for your RDS database is done through IAM. 26 00:01:03,510 --> 00:01:04,800 So you can use for example 27 00:01:04,800 --> 00:01:06,660 username and password to connect to your database. 28 00:01:06,660 --> 00:01:10,080 But also you can use IAM authentication for some of them. 29 00:01:10,080 --> 00:01:12,300 You have security groups for network security 30 00:01:12,300 --> 00:01:16,230 on your Amazon RDS database, KMS for at rest encryption 31 00:01:16,230 --> 00:01:20,610 and you could have in transit encryption using SSL and TLS. 32 00:01:20,610 --> 00:01:22,560 Now, if you wanted to do backups 33 00:01:22,560 --> 00:01:24,870 you have the automated backup option 34 00:01:24,870 --> 00:01:26,790 which is up to 35 days. 35 00:01:26,790 --> 00:01:28,950 And if you use that, you can do point in time 36 00:01:28,950 --> 00:01:32,370 restore to any point of time in these 35 days. 37 00:01:32,370 --> 00:01:34,680 And this will create a new database out of it. 38 00:01:34,680 --> 00:01:38,130 Or if you want to retain backups for longer term recovery 39 00:01:38,130 --> 00:01:41,820 then you would use a manual database snapshot. 40 00:01:41,820 --> 00:01:44,910 There is a managed and scheduled maintenance 41 00:01:44,910 --> 00:01:46,980 which will bring downtime into your database. 42 00:01:46,980 --> 00:01:48,180 So this is due to the fact 43 00:01:48,180 --> 00:01:51,324 that you have to provision it and that you have to update. 44 00:01:51,324 --> 00:01:54,900 AWS has to update at some point database engine 45 00:01:54,900 --> 00:01:57,450 or the underlying EC2 instance 46 00:01:57,450 --> 00:01:59,733 for patches of security and so on. 47 00:02:00,810 --> 00:02:03,990 There is support for IAM authentication on RDS 48 00:02:03,990 --> 00:02:07,260 and you can enforce it through the RDS proxy. 49 00:02:07,260 --> 00:02:09,660 And it has integration with secrets manager 50 00:02:09,660 --> 00:02:11,790 to manage the database credentials. 51 00:02:11,790 --> 00:02:15,780 If you wanted to have access to the underlying instance 52 00:02:15,780 --> 00:02:19,800 and customize it, then you can reuse the RDS custom option. 53 00:02:19,800 --> 00:02:22,200 And this is available for the Oracle 54 00:02:22,200 --> 00:02:25,590 and SQL server type of databases. 55 00:02:25,590 --> 00:02:27,900 So the use cases of Amazon RDS 56 00:02:27,900 --> 00:02:30,600 is to store relational databases. 57 00:02:30,600 --> 00:02:32,820 For example, using the RDBMS 58 00:02:32,820 --> 00:02:36,510 or have an online transaction processing database so OLTP. 59 00:02:36,510 --> 00:02:38,700 If you wanted to perform SQL queries 60 00:02:38,700 --> 00:02:41,340 on top of it and transactions. 61 00:02:41,340 --> 00:02:43,440 Okay, so hopefully nothing is new for you here. 62 00:02:43,440 --> 00:02:45,000 Nothing is new for you here. 63 00:02:45,000 --> 00:02:46,050 I hope you liked it. 64 00:02:46,050 --> 00:02:48,000 And I will see you in the next lecture.