centos7 mysql 多实例安装主从复制

最新推荐文章于 2022-09-11 01:16:51 发布

weixin_33910434

最新推荐文章于 2022-09-11 01:16:51 发布

阅读量182

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/langgege/blog/3019230

版权

2019独角兽企业重金招聘Python工程师标准>>>

将/etc/selinux/config里的SELINUX设置成：disabled
解压mysql
创建mysql实例用户及文件
配置Mysql的配置文件/etc/my.cnf

[mysqld_multi]
mysqld = /home/mysql/mysql/bin/mysqld
mysqladmin = /home/mysql/mysql/bin/mysqladmin
log = /tmp/mysql_multi.log

[mysqld1]
datadir = /home/mysql/data3306
socket = /tmp/mysql.sock1
port = 3306
user = mysql
performance_schema = off
innodb_buffer_pool_size = 32M
bind_address = 0.0.0.0
skip-name-resolve = 0
log-bin=mysql-bin
binlog_format=mixed
server-id=1

[mysqld2]
datadir = /home/mysql/data3307
socket = /tmp/mysql.sock2
port = 3307
user = mysql
performance_schema = off
innodb_buffer_pool_size = 32M
bind_address = 0.0.0.0
skip-name-resolve = 0
log-bin=mysql-bin
binlog_format=mixed
server-id=2

[mysqld3]
datadir = /home/mysql/data3308
socket = /tmp/mysql.sock3
port = 3308
user = mysql
performance_schema = off
innodb_buffer_pool_size = 32M
bind_address = 0.0.0.0
skip-name-resolve = 0
log-bin=mysql-bin
binlog_format=mixed
server-id=3

主从复制：

master:
GRANT replication slave ON *.* TO 'bhis'@'%' IDENTIFIED BY 'bhis';
show master status;


salve:
mysql> CHANGE MASTER TO
    -> MASTER_HOST="192.168.135.129",
    -> MASTER_USER="bhis",
    -> MASTER_PASSWORD="bhis",
    -> MASTER_LOG_FILE="mysql-bin.000001",
    -> MASTER_LOG_POS=437;

start slave;
show slave status;

详情请看这位大神的

转载于:https://my.oschina.net/langgege/blog/3019230