MySQL Multi-instance deployment

MySQL multi-instance routine, there are mainly two kinds of programs can be achieved, these two kinds of programs have pros and cons, as follows:
1, based on multi-configuration files

Multiple instances are implemented by using multiple configuration files to start different processes.

Advantages: Simple logic, simple configuration

Cons: Not easy to manage.
2, based on Mysqld_multi

Use a separate configuration file to implement multiple instances with the official Mysqld_multi tool

Advantages: Easy to centralize management management

Cons: Inconvenient to customize for each instance configuration

This article is based on the first multi-configuration file, MySQL for the redhat6.3 system comes with

First of all

MySQL Multi-instance deployment