AWS 02: Launch mySQL service with Amazon RDS

This time I will launch first Amazon RDS to replace existing mySQLserver on Subnet_02 which was created on previous session. RDS is a database service available in AWS, and you can choose various types of database platform, such as mySQL, MS-SQL, Oracle or DynamoDB. Using RDS means that you are free from launching EC2 instance, such as Linux / Windows for setting up database.

I will launch free version of RDS and choose mySQL as database platform, and try to connect from web server sitting on Subnet_01.

Followings are brief description of each steps.

1. Navigate to RDS console.
2. Hit "Create Database" and make basic settings, such as choose database or set master user and password etc.
3. It will take a while to boot up the database.
4. Confirm DNS name assigned and login from each EC2 instances.
5. By default, security groups for your RDS needs to be corrected, otherwise you will not be able to connect and login to the database from remote servers.
6. After you confirm the connectivity has no problem, then try to login from phpMyAdmin via internet access. Don't forget to update your config.inc.php file with correct host name.

Please watch a video for more detail.