mysql-Learning-3-20170503

mysql-Learning-3-20170503

1. Why use multi-instance

--------------------------------------

Boot order:

/ETC/MY.CNF--"/etc/mysql/my.cnf--"/usr/local/mysql/etc/my.cnf--"~/.my.cnf

Start:

/usr/local/mysql/bin/mysqld_safe &

Strace can analyze the MySQL process

Strip mysqld after the 241MB into 25MB to save mysqld space

------------------------------

-------------------------------------------------

-------------------------------------------------------------------

Serverid-recommended IP Address last add port number

----------------------------------------------------------------

Mkdir-p/data/mysql/mysql3307/{data,logs,tmp}

Cp/data/mysql/mysql3306/my3306.cnf/data/mysql/mysql3307/my3307.cnf

Sed-i ' s/3306/3307/g '/data/mysql/mysql3307/my3307.cnf

---------------------------------------------------------------

---------------------------------------------------------------

---------------------------------------------------------------

---------------------------------------------------------------

------------------------------------------------------------------

---------------------------------------------------------------

Close the 3306 and 3307 databases

V-G Down block Copy

Cha Duankou:

Ss-nlp|grep MySQL

---------------------------------------------------------------

mysql-Learning-3-20170503