by Manuj Aggarwal | Publisher: Packt Publishing | Release Date: June 2018 | ISBN: 9781789539127

Learn how to plan, deploy and operate a highly available and scalable MySQL database in the cloud with AWS RDSAbout This VideoThis course teaches you how to design, deploy, configure and manage your AWS RDS relational databases with AWS RDS.If you're serious about building scalable, flexible and robust AWS RDS databases for use in your cloud-based applications, then this course is for you.These database and Cloud Computing skills are in high demand, but there's no easy way to acquire this knowledge. Rather than rely on hit and trial method, this course will provide you with all the information you need to get started with your AWS RDS cloud database projects.In DetailAmazon Web Services is a cloud computing platform that offers a broad set of global compute, storage, database, analytics, application, and deployment services that help organizations move faster, lower IT costs, and scale applications. Ever since its inception - the relational database management systems have gained tremendous popularity across the world. Recently NoSQL databases like MongoDB has also gained a lot of traction - but still, RDBMS remains the de-facto choice of engineers when it comes to storing structured data. According to some estimates - relational databases are used in more than 90% of the software projects out there. With the advent of cloud computing - solution designers and architects had to deal with some unique challenges while attempting to migrate their relational databases to the cloud. You see, relational databases need high-performance hardware and disks to perform at the peak level. But IaaS cloud computing services provide us with virtual servers - which store their data on network connected disks. So to manage relational data in the cloud - we needed a specialized PaaS (platform as a service) which provided adequate hardware and redundancy to relational databases. Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). AWS RDS is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. Complex administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. Scaling storage and compute resources can be performed by a single API call. Introduction of AWS RDS along with its unique features has made it very simple for us to deploy and grow relational databases to a very large scale in the cloud. What's more - the tight integration that exists between most of the AWS services - makes it seamless to deploy multi-tier complex and scalable applications.

1. Chapter 1 : Introduction
   • Welcome and introduction 00:04:11
   • Course overview 00:03:11
   • Benefits of AWS RDS 00:05:53
   • Download course resources 00:00:43
   • Get ready for AWS RDS 00:00:41
2. Chapter 2 : Introduction to AWS RDS
   • Introduction to AWS RDS 00:00:52
   • Get introduced to AWS RDS 00:10:59
   • Setup AWS RDS instance 00:04:21
   • Deploy AWS RDS instance 00:06:40
   • Deploy AWS RDS instance # 2 00:10:13
   • Deploy AWS RDS instance # 3 00:09:06
3. Chapter 3 : Deploy AWS RDS in Custom AWS VPC
   • Deploy AWS RDS in AWS VPC 00:00:45
   • Introduction to AWS VPC 00:09:14
   • AWS VPC components 00:03:46
   • Deploy AWS VPC 00:05:26
   • Deploy AWS VPC components 00:09:35
   • Configure AWS VPC 00:08:45
   • Deploy subnet group 00:05:29
   • Deploy AWS RDS in a custom AWS VPC 00:08:06
   • Deploy AWS EC2 instance 00:09:19
   • Connection AWS RDS instance 00:05:44
4. Chapter 4 : AWS RDS Operational Guidelines
   • AWS RDS operational guidelines 00:00:58
   • Introduction to monitoring and alerting In AWS 00:08:33
   • Monitoring AWS RDS database 00:08:15
   • Performance and scalability of AWS RDS database 00:07:35
   • Other guidelines for AWS RDS 00:06:47
5. Chapter 5 : AWS RDS - Backup & Recovery
   • AWS RDS backup and recovery 00:00:53
   • Introduction to AWS RDS backup features 00:08:27
   • Backup AWS RDS database 00:10:55
   • Take AWS RDS database snapshot 00:06:55
   • Restore AWS RDS database snapshot 00:09:15
   • AWS RDS manual database snapshots 00:03:14
6. Chapter 6 : AWS RDS Multi-AZ Features
   • AWS RDS high availability features 00:00:50
   • AWS RDS Multi-AZ deployment 00:08:40
   • Benefits of Multi-AZ deployments for AWS RDS 00:04:36
   • Test AWS RDS failover 00:05:39
   • Test AWS RDS failover #2 00:09:15
   • Failover for CRUD operations 00:06:44
   • Failover for CRUD operations #2 00:06:43
   • Integrate a web application with AWS RDS 00:07:20
   • CRUD operations with the web application 00:05:36
   • Introduction to AWS RDS read replicas 00:03:27
   • Deploy an AWS RDS read replica 00:06:19
   • Connect to AWS RDS instances 00:03:39
   • AWS RDS read replica #2 00:04:54
   • AWS RDS read replica 00:09:39
7. Chapter 7 : Introduction to Cloud Computing and AWS
   • Introduction to cloud computing and AWS 00:00:55
   • Cloud computing 00:07:30
   • Why AWS? 00:08:09
   • Who uses AWS? 00:05:57
   • AWS services 00:03:48
   • More about AWS 00:08:51
8. Chapter 8 : Conclusion
   • Thank you 00:03:52