Experience Alibaba Cloud Cloud Database RDS activation and setting up MySQL cloud database tutorial

If we are just building a website, we can directly configure the MySQL database in the cloud server and use it directly. However, recently, Snail has seen that some netizens’ Weiqing clients or other relatively large database projects separate the database from the website. Yes, there are also some projects that do not need a cloud server but only a database. In fact, ordinary cloud servers are not particularly suitable at this time. What they need to use is a direct cloud database. Compared with the cloud server built by themselves, this kind of cloud database will have better performance and more supporting security functions.

The day before yesterday, some netizens asked Snail to help check the binding settings of the RDS version of the Alibaba Cloud cloud database. Since I have never done it before, I didn’t dare to try it. I am planning to buy a test cloud database today. First, learn this Alibaba Cloud Database RDS version by yourself, and only dare to operate it if you encounter such a situation in the future. In the past, I had more contact with Alibaba Cloud ECS servers or lightweight servers, but I had never been exposed to cloud databases before.

First, Alibaba Cloud database RDS solution configuration

Considering the security of this classmate’s account, I would still purchase a test database in my own account. Don’t ruin the products of other people’s accounts because I won’t be able to afford the compensation later. [Purchase cloud database RDS MySQL version]

Here we select the region, database type, version, and storage disk just like we selected the Alibaba Cloud ECS server. Select the region based on the region where our project is located. If we need to use it in conjunction with a cloud server, it is recommended to be in the same region as the cloud server. Because Snail has a cloud server in Hangzhou, I chose the cloud database in Hangzhou.

Later, with the help of this activated machine, we will test whether the cloud database used by the website is stable. I have previously discovered that many netizen websites are separated from their databases.

Here Snail chooses the cheapest configuration, selects the storage space, and the purchase period (the default is automatic renewal, I want to remove the check here). This will enable the machine later.

Second, Alibaba Cloud Database RDS account settings

1. Set up an external or intranet whitelist

Here, depending on whether we are using the cloud server on the internal network or on the external network, we need to set up a whitelist or an external network address. The whitelist setting is very simple, we can directly add the IP of the corresponding cloud server.

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

2. Create a database account

We have only opened the Alibaba Cloud database, and we have not created a database user yet.

It's quite familiar, but I saw the difference between premium accounts and ordinary accounts.

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

After creating the database user, we must also create the database binding user, so that the complete database creation can be considered complete.

Third, Alibaba Cloud Database RDS security configuration

By default, Alibaba Cloud Cloud Database RDS is automatically backed up on Mondays, Wednesdays, Fridays, and Sundays. Snail has also said before that cloud databases are safer than those configured on our own servers. Otherwise it wouldn't be so expensive.

Here we can also modify the backup cycle.

In this article, Snail simply experienced the activation of the RDS MYSQL version of Alibaba Cloud Database and the subsequent logical relationship. The database has been created. Someday I will have time to try out the remote database connection or use it on the intranet to see how it works. Because recently we are also studying to unify the website databases of some of the company's customers so that the local server can reduce resource usage.

Recommended site search: domain name registration price, US host network, foreign vps server rental, free asp space application, US virtual host purchase, mainland China space, in domain name registration, Dongwang host, free overseas server, permanent free in mainland China Recommended cloud server registration,