Problem scenario
You know that Amazon Aurora is compatible with either PostgreSQL or MySQL. While RDS supports these database types as well as Oracle and SQL Server, RDS does not offer all of the advantages that Aurora offers.
You have read about the benefits of Aurora a database PaaS or DBaaS. You want to deploy Amazon Aurora because it has numerous features for high availability, performance, and scalability. What do you do?
Solution
1. Log into AWS.
2. Go here in the web browser: https://console.aws.amazon.com/rds
3. Click the button to "Get Started".
4. For the "Engine options", choose "Amazon Aurora".
5. At the bottom, choose the "Edition" (e.g., MySQL or PostgreSQL).
6. Click "Next".
7. For "Specify DB details", choose and enter settings you think are appropriate. It should be self-explanatory. Remember the username and password entered here.
8. Click "Next".
9.a. For "Configure advanced settings" most of the options will be self-explanatory based on your preference.
9.b. In the "Public accessibility" section, choose "Yes".
9.c. For "Network & Security" there is a section for "Availability zone" options. If you do not see the zone you want, go to the upper right hand corner of the AWS console. Between your name and the "Support" option, do you see the region you expect? You may need to change this region and start over creating your Aurora instance if you need a specific Availability Zone.
9.d. Click "Launch DB Instance".
10. Click "View DB Instances" in the lower right hand corner.
11. Connect to your database via a SQL front end (e.g., such as HeidiSQL). Go to "Endpoint" and find the FQDN. Go to "DB Name" and find the name. Use these in your SQL front end application. Use the username and password entered in step #7 above. Once connected, try it out. You may want to run a command such as this: SELECT current_database();
Or you may want to run a command like this: create table contint(column1 int)
12. If you want to delete your Aurora instance go to "Instance actions" in the upper right hand corner, and go to "Delete". You are now done.
You may want to view this link to learn more about the costs and benefits of Aurora.