1. Installation Instructions
(1), all the installation files, configuration files, data directories are stored in the/data/mysql directory, for the future to achieve rapid migration, overall backup and rapid replication;
(2), running four MySQL instances on a single server, bound on 3306, 3307, 3308, 3309 ports respectively
(3), Four instances are open Binlog log, Data directory storage in/data/mysql/data1,/data/mysql/data2,/data/mysql/data3,/data/mysql/data4
(4), Four instances are used InnoDB as the default storage engine, character encoding using UTF-8
(5), four instances all use the same performance optimization configuration parameters
(6), when compiling the installation, the database configuration file my.cnf and the data directory, etc. are pointed to the/data/mysql directory
(7), through the Mysqld_multi way to manage four different instances, with the same profile sharing performance optimization configuration parameters
(8), in the same configuration file, using [Mysqld1], [mysqld2], [mysqld3], [MYSQLD4] tags to achieve different instances of the differential configuration
MySQL standalone multi-instance configuration