Create a MySQL DB Instance in Amazon RDS

Use the Amazon RDS console to launch a MySQL DB instance. If you choose a Multi-AZ deployment this ensures that your database will failover and continue to be available if the master DB instance goes out of service. But for our purposes we will launch a single instance db in a single AZ that is eligible for the free tier.

To launch an RDS DB instance in a default VPC

1. Open the RDS console.
2. Choose Instances in the navigation pane.
3. Choose Launch DB Instance.
4. Choose a DB Engine and preset configuration (Select MySQL).
5. Choose Dev/Test
6. Choose Only enable options eligible for RDS Free Usage Tier
7. Under Specify DB Details, choose a DB Instance Class. For high availability, set Multi-AZ Deployment to No.
8. Under Settings, enter values for DB Instance Identifier, Master Username, and Master Password (and Confirm Password). Note the values that you entered for later.
9. • DB Instance Identifier* – mydbinstance
10. • Master Username* – rdsuser
11. • Master Passord* – rdspassword
12. Choose Next.
13. For Network and Security settings, choose the following:
14. • VPC – Default VPC
15. • Subnet Group – default
16. • Publicly Accessible – No
17. • Availability Zone – No Preference
18. • VPC Security Groups – Default VPC Security Group
19. For Database Name, type rdsdb, and verify the default settings for the remaining options. Note the values of the following options:
20. • Database Name – rdsdb
21. • Database Port – 3306
22. Choose Launch DB Instance.

Scott Waddell

I’ve always had a passion for solving complex problems, but I’ve never liked to do it the “normal” way. The digital product space is still the Wild West of technology, a place you can imagine an idea, prototype it quickly and cheaply, and bring it to market on your own (or at least with a small, tight team). There’s an ethos you have to follow, sure, but how you do it isn’t as important as that you get it done. I’m a huge advocate for renegade product makers out to change the world.