首页 > 代码库 > mysql-学习-3-20170503
mysql-学习-3-20170503
mysql-学习-3-20170503
1.为什么要使用多实例
--------------------------------------
启动顺序:
启动:
/usr/local/mysql/bin/mysqld_safe &
strace 可以分析mysql的进程
strip mysqld后由241MB变成了25MB 为了节省mysqld的空间
------------------------------
-------------------------------------------------
-------------------------------------------------------------------
serverid-建议ip地址最后一位加端口号
----------------------------------------------------------------
mkdir -p /data/mysql/mysql3307/{data,logs,tmp}
cp /data/mysql/mysql3306/my3306.cnf /data/mysql/mysql3307/my3307.cnf
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
------------------------------------------------------------------
---------------------------------------------------------------
关闭3306和3307数据库
查端口:
ss -nlp|grep mysql
---------------------------------------------------------------
mysql-学习-3-20170503