Shulou(Shulou.com)06/01 Report--

Recently, it is often necessary to export some table data in the database in the production environment, and each export will have some impact on the production environment, so it is decided to solve the problem by planning tasks on the intranet server.

In the production environment, the database uses Aliyun's RDS, the application server uses ECS, and the operating system uses CentOS7.

According to the previous operation habit, use yum list all | grep-I mysql directly to view the available installation packages, and the list is as follows:

The first reaction is to install mysql++.x86_64, but there are no mysql clients and mysqldump available after installation.

After a lot of trouble, it turns out that on CentOS7, the repo source of Aliyun is used by default, and you need to install mariadb. As follows

[root@*] # yum list all | grep mariadb

Mariadb.x86_64 1updates 5.5.50-1.el7_2 @ updates

Mariadb-libs.x86_64 1updates 5.5.50-1.el7_2 @ updates

After installing the above two packages, you can use mysql and mysqldump.

Yum install-y mariadb.x86_64 mariadb-libs.x86_64

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.