Ravindra BagaleCourses & study guides

15. Amazon RDS for MySQL: Create, Connect, Back Up and Keep It Private

By Last updated:

Chala mitrano, Part 5 madhe aapan MySQL swatah EC2 var install kela – install, mysql_secure_installation, users, GRANT, backups sagla aaplya haatat. Companies madhe production database sathi bahutek vela Amazon RDS vapartat: AWS server chalavto, patching karto, automatic backups gheto, aani aapan fakt database vaparto. Aaj aapan RDS MySQL banvu, tyala EC2 varun connect karu, app sathi vegla user banvu, backups aani restore baghu. Aani ek niyam aadhich doktyat bhara – RDS kadhi public nako. He khup important aahe, lakshat theva.

What you will learn in this chapter

  • What RDS manages for you and what is still your job
  • Planning the network: VPC, DB subnet group and security groups
  • Creating an RDS MySQL instance step by step (console and CLI)
  • Connecting from EC2 and creating a least-privilege application user
  • Automated backups, snapshots and point-in-time restore
  • Hardening RDS: never public, encryption, TLS, deletion protection and monitoring

Concepts in this chapter

  1. 15.1What RDS Is and Why Companies Use It
  2. 15.2Planning the Network: Subnet Group and Security Groups
  3. 15.3Creating an RDS MySQL Instance Step by Step
  4. 15.4Connecting from EC2 and Creating the Application User
  5. 15.5Automated Backups, Snapshots and Restore
  6. 15.6Hardening RDS: Never Public, Encrypted, Monitored

The chapter recap is at the end of the last concept page.