AWS Relational Database Service (RDS)

1. Create a RDS

Standard create is to see all the options and Easy create is to go fast over it.

AWS Relational Database Service (RDS)_第1张图片


There are templates we can specify to meet our use case, which are going to be pre-filling some configuration parameters in here.

Choose Production because we want to see all the options. But we'll make sure to choose an instance that is compliant with using the Free tier of AWS RDS.

AWS Relational Database Service (RDS)_第2张图片


AWS Relational Database Service (RDS)_第3张图片


We need to include a previous generation and choose dbt2.micro.
This is to make sure that you remain within the free tier.

AWS Relational Database Service (RDS)_第4张图片


To remain within the free tier yet again, we need to choose a general purpose SSD type.

When we select Enable storage autoscaling, this provides dynamic scaling support for our database storage.

The more we use our storage, if we get close to 20 gigabytes automatically, the storage will be increased by AWS without us doing anything.

AWS Relational Database Service (RDS)_第5张图片


If we did enable multi-AZ, we would get a standby instance for our RDS database, which is recommended for production usage.

And this standby instance is going to be here for data redundancy. In case we have I/O freezes for backups, and to minimize latency spikes during backups as well.

It's not something that gets used by applications, it's something that in case our main instance has an issue or a reboot or something like this.
So for now we'll disable multi-AZ.

AWS Relational Database Service (RDS)_第6张图片


Select Public access because we want to be able to connect to and test our database publicly.

AWS Relational Database Service (RDS)_第7张图片
AWS Relational Database Service (RDS)_第8张图片


AWS Relational Database Service (RDS)_第9张图片
AWS Relational Database Service (RDS)_第10张图片
AWS Relational Database Service (RDS)_第11张图片
AWS Relational Database Service (RDS)_第12张图片


AWS Relational Database Service (RDS)_第13张图片


We have the end point right here and the port 3306, and it's linked to a security group.

AWS Relational Database Service (RDS)_第14张图片


The security group has an inbound rule on TCP port 3306 coming from just our IP address.

AWS Relational Database Service (RDS)_第15张图片

2. Install the SQLECTRON

AWS Relational Database Service (RDS)_第16张图片

Take the end point which is showed above and we're going to connect to it using Sqlectron.

AWS Relational Database Service (RDS)_第17张图片

If the connection test is not successful, please have a look at whether or not the database was set to be a public database, or, have a look at the security group settings to make sure that our IP is allowed in.

3. Create a Read Replica

AWS Relational Database Service (RDS)_第18张图片


AWS Relational Database Service (RDS)_第19张图片


4. Delete the Database

AWS Relational Database Service (RDS)_第20张图片


We go to Modify, disable the Delete protection setting.

AWS Relational Database Service (RDS)_第21张图片


AWS Relational Database Service (RDS)_第22张图片

Then delete the database in the management console by selecting delete action.

你可能感兴趣的