Experience Alibaba Cloud RDS activation and MySQL cloud database setup tutorial

If we only build websites, MySQL database can be directly used in the direct cloud server configuration. However, recently Lao Zuo saw that some users' micro engine client or other large database projects separate the database from the website, and some projects do not need to use the cloud server, but only need the database, In fact, ordinary ECS is not particularly suitable at this time. What they need to use is a direct cloud database. This cloud database has better performance than its own cloud server, and has more supporting security functions.

A netizen hoped Lao Zuo would help him the day before yesterday Alibaba Cloud RDS The binding settings of the version have not been operated before, so I didn't dare to try it. I'm not going to start a test cloud database today. Learn the RDS version of Alibaba Cloud Cloud Database by yourself first, and then dare to operate in such cases. AliCloud ECS servers or lightweight servers have been the most frequently contacted before, but Alibaba Cloud databases have not been contacted before.

First, Alibaba Cloud RDS solution configuration

Considering the security of this student's account, I'd better buy a test database in my own account. Don't damage the products in others' accounts, and I can't afford to pay back. 【 Purchase RDS MySQL 】

The region, database type, version, and storage disk are selected just like Alibaba Cloud ECS servers. Select the region according to the region where our project is located. If we need to use it in combination with ECS, it is recommended that we share the same region with ECS. Because Lao Zuo has an ECS in Hangzhou, I choose Hangzhou's cloud database.

Later, with the help of this opened machine, test whether the website uses cloud database stably. It has been found that many netizen websites are separated from the database.

Here Lao Zuo chooses the cheapest configuration, storage space, and purchase duration (automatic renewal is the default, and I will remove the check here). In this way, the machine will be opened later.

Second, AliCloud RDS account settings

1. Set the whitelist of external network or internal network

Here we need to set the whitelist or internet address according to whether we use the intranet in ECS or the internet. The white list setting is simple. We can add the IP address of the corresponding ECS directly.

After setting the whitelist IP address, we can see the external and internal network addresses, which we need to use when we need to connect to the database configuration file. We used to use localhost as our local address, remember?

2. Create database account

We just open Alibaba Cloud database, and we haven't created database users yet.

I'm familiar with it, but I can see the difference between an advanced account and an ordinary account.

Here we need to create a common account, which will be used in the project later.

After creating a database user, we must also create a database bound user, so that the complete database can be created.

Third, Alibaba Cloud RDS security configuration

default Alibaba Cloud RDS is automatically backed up on Monday, Wednesday, Friday and Sunday. Lao Zuo also said that the cloud database is safer than our own server configuration. Or it wouldn't be so expensive.

Here we can also modify the backup cycle.

In this article, Lao Zuo simply experienced the launch of Alibaba Cloud RDS MySQL and the subsequent logical relationship. The database has been created. The next day, when you have time to experience remote database connection or intranet use, see how it works. Because recently, we are also studying how to put the website databases of some customers of the company together, so that the local server can reduce resource consumption.