MySQL高可用架構之MySQL5.6 MHA

標籤：rip   local   否則   soc   plugin   lin   linu   x86   使用   

[[email protected] ~]#cd /opt/source/

[[email protected] ~]#tar -zxf mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz 

[[email protected] ~]#ln -s /opt/source/mysql-5.6.37-linux-glibc2.12-x86_64 /usr/local/mha

[[email protected] ~]#mkdir -p /data/mysql_33051/{data,logs,run,tmp}

[[email protected] ~]#vi  /data/mysql_33051/my.cnf

[[email protected] ~]#chown -R mysql.mysql /data/mysql_33051/

[[email protected] ~]#/usr/local/mha/scripts/mysql_install_db --defaults-file=/data/mysql_33051/my.cnf --basedir=/usr/local/mha  --datadir=/data/mysql_33051/data  --user=mysql #初始化執行個體，未使用預設位置好的my.cnf，則在初始化的時候需要第一位置指定，否則不能識別

[[email protected] ~]#/usr/local/mha/bin/mysqld_safe --defaults-file=/data/mysql_33051/my.cnf --user=mysql &   #啟動執行個體

[[email protected] ~]#ps -ef |grep mysql
root 8964 6737 1 15:57 pts/0 00:00:00 /bin/sh /usr/local/mha/bin/mysqld_safe --defaults-file=/data/mysql_33051/my.cnf --user=mysql
mysql 10435 8964 61 15:57 pts/0 00:00:04 /usr/local/mha/bin/mysqld --defaults-file=/data/mysql_33051/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql_33051/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql_33051/logs/mysqlerror.log --open-files-limit=65535 --pid-file=/data/mysql_33051/run/mysqld.pid --socket=/data/mysql_33051/run/mysql.sock --port=33051

MySQL高可用架構之MySQL5.6 MHA