AWS|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.
文章图片
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.
文章图片
文章图片
We need to include a previous generation and choose dbt2.micro.
This is to make sure that you remain within the free tier.
文章图片
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.
文章图片
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.
文章图片
Select Public access because we want to be able to connect to and test our database publicly.
文章图片
文章图片
文章图片
文章图片
文章图片
文章图片
文章图片
We have the end point right here and the port 3306, and it's linked to a security group.
文章图片
The security group has an inbound rule on TCP port 3306 coming from just our IP address.
文章图片
2. Install the SQLECTRON
文章图片
Take the end point which is showed above and we're going to connect to it using Sqlectron.
文章图片
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
文章图片
文章图片
4. Delete the Database
文章图片
We go to Modify, disable the Delete protection setting.
文章图片
文章图片
【AWS|AWS Relational Database Service (RDS)】Then delete the database in the management console by selecting delete action.
推荐阅读
- 数据技术|一文了解Gauss数据库（开发历程、OLTP&OLAP特点、行式&列式存储，及与Oracle和AWS对比）
- 澳洲国立大学|澳洲国立大学 COMP6240 Relational Databases 笔记
- 云原生 Serverless Database 使用体验
- django.db.backends.postgresql' isn't an available database backend.解决方法
- [译]|[译] 使用 Go 和 AWS Lambda 构建无服务 API
- 有奖征文|【AWS征文】用什么方法来挖掘提升 EBS、S3 和 EFS 的潜在性能
- AWS VPC -- 使用AWS Management Console创建VPC
- Database|【sql】sqlserver因设置最大内存（256）过小导致无法启动的修复
- AWS 上 Java Lambda 应用记要
- 一个C#实现的数据库访问帮助类DatabaseHelper