MySQL multi-instance configuration (2)

MySQL multi-instance configuration (2)

For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is used to manage multiple mysqld service processes. These mysqld service process programs can use different sockets or listen to different ports, and distribute data files to different disks to distribute IO. Mysqld_multi provides simple commands for starting, disabling, and reporting the status of the managed server. This reduces the maintenance cost of the production environment, facilitates subsequent migration and cleaning, and improves the overall resource utilization of the server by binding multiple instances. you can configure multiple instances in either of the following ways. cnf provides configuration for all instances. One is to use a configuration file for each instance. This document describes the second method.

1. Differences between multiple databases and Instances

2. Existing Environment

3. initialize the instance

4. Configure the my. cnf file for each instance

5. Start and close multiple instances