单机MGR多主模式安装测试
免费下载
一、参考资料
http://www.axiaoxin.com/article/237/
二、安装 MySQL5.7
1、创建目录
mkdir /opt/mysql
cd /opt/mysql/
cp -r /software/mysql-5.7 mysql-5.7-s1
cp -r /software/mysql-5.7 mysql-5.7-s2
ln -s /opt/mysql/mysql-5.7-s1 /usr/local/mysql-s1
ln -s /opt/mysql/mysql-5.7-s2 /usr/local/mysql-s2
ln -s /opt/mysql/mysql-5.7-s3 /usr/local/mysql-s3
mkdir /data/mysql/ -p
mkdir /data/mysql/mysql-s1/{data,logs,tmp} -p
mkdir /data/mysql/mysql-s2/{data,logs,tmp} -p
mkdir /data/mysql/mysql-s3/{data,logs,tmp} -p
mkdir -p /data/mysql/mysql-s1/mysql-bin
mkdir -p /data/mysql/mysql-s2/mysql-bin
mkdir -p /data/mysql/mysql-s3/mysql-bin
groupadd mysql
useradd -g mysql -s /sbin/nologin -d /home/mysql -MN mysql
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /opt/mysql/
chown -R mysql:mysql /usr/local/mysql-s1
chown -R mysql:mysql /usr/local/mysql-s2
chown -R mysql:mysql /usr/local/mysql-s3
2、配置 my.cnf
--server1 操作
[mysqld]
# Server configuration
basedir=/usr/local/mysql-s1
datadir=/data/mysql/mysql-s1/data
port=24801
socket=/data/mysql/mysql-s1/mysql-s1.sock
character-set-server=utf8
log-error=/data/mysql/mysql-s1/logs/s1-error.log
pid-file=/data/mysql/mysql-s1/tmp/mysql-s1.pid
default_time_zone="+8:00"
--server2 操作
[mysqld]
# Server configuration
basedir=/usr/local/mysql-s2
datadir=/data/mysql/mysql-s2/data
port=24802
socket=/data/mysql/mysql-s2/mysql-s2.sock
character-set-server=utf8
log-error=/data/mysql/mysql-s2/logs/s2-error.log
pid-file=/data/mysql/mysql-s2/tmp/mysql-s2.pid
default_time_zone="+8:00"
--server3 操作
[mysqld]
# Server configuration
basedir=/usr/local/mysql-s3
datadir=/data/mysql/mysql-s3/data
port=24803
socket=/data/mysql/mysql-s3/mysql-s3.sock
character-set-server=utf8
log-error=/data/mysql/mysql-s3/logs/s3-error.log
pid-file=/data/mysql/mysql-s3/tmp/mysql-s3.pid
default_time_zone="+8:00"
3、初始化
/usr/local/mysql-s1/bin/mysqld --defaults-file=/data/mysql/mysql-s1/s1.cnf
--initialize
/usr/local/mysql-s2/bin/mysqld --defaults-file=/data/mysql/mysql-s2/s2.cnf
--initialize
/usr/local/mysql-s3/bin/mysqld --defaults-file=/data/mysql/mysql-s3/s3.cnf
--initialize
4、记录密码
grep "password" /data/mysql/mysql-s1/logs/s1-error.log
grep "password" /data/mysql/mysql-s2/logs/s2-error.log
grep "password" /data/mysql/mysql-s3/logs/s3-error.log
5、启动
/usr/local/mysql-s1/bin/mysqld --defaults-file=/data/mysql/mysql-s1/s1.cnf &
/usr/local/mysql-s2/bin/mysqld --defaults-file=/data/mysql/mysql-s2/s2.cnf &
/usr/local/mysql-s3/bin/mysqld --defaults-file=/data/mysql/mysql-s3/s3.cnf &
6、修改 root 密码
/usr/local/mysql-s1/bin/mysql -S /data/mysql/mysql-s1/mysql-s1.sock
-p'U_XSuod(0Pju'
alter user 'root'@'localhost' identified by '123456';
update mysql.user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT
OPTION;
/usr/local/mysql-s2/bin/mysql -S /data/mysql/mysql-s2/mysql-s2.sock
-p'QrJ&yora(4sq'
alter user 'root'@'localhost' identified by '123456';
update mysql.user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT
OPTION;
/usr/local/mysql-s3/bin/mysql -S /data/mysql/mysql-s3/mysql-s3.sock -p'-yI
%lk-)r2M?'
alter user 'root'@'localhost' identified by '123456';
update mysql.user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT
OPTION;
/usr/local/mysql-s1/bin/mysql -S /data/mysql/mysql-s1/mysql-s1.sock -p123456
/usr/local/mysql-s2/bin/mysql -S /data/mysql/mysql-s2/mysql-s2.sock -p123456
/usr/local/mysql-s3/bin/mysql -S /data/mysql/mysql-s3/mysql-s3.sock -p123456
of 6
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论