主从复制 Replication
login.sh
#!/bin/bash
Mysql -h227.0.0.1 -uroot -P3306 -p'Yxc@3306'
start.sh
#!/bin/bash
mysqld_safe --defaults-file=/data/mysql/3306/my3306.cnf --user=mysql &
shutdown.sh
#!/bin/bash
/usr/local/mysql/bin/mysqladmin -uroot -P3306 -p'Yxc@3306' -S /data/mysql/3306/mysql3306.sock shutdown
[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql/3306/data
port=3306
Socket=/data/mysql/3306/mysql3306.sock
character-set-server=utf8
log-error=/data/mysql/3306/log/error3306.log
pid-file=/data/mysql/3306/mysqld3306.pid
log_bin=mysql_bin
binlog-fORMat=Row
server-id=51
[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql/3306/data
port=3306
socket=/data/mysql/3306/mysql3306.sock
character-set-server=utf8
log-error=/data/mysql/3306/log/error3306.log
pid-file=/data/mysql/3306/mysqld3306.pid
log-bin=mysql_bin
server-id=52
relay-log-index=slave-relay-bin.index
relay-log=slave-relay-bin
create user 'repl'@'%' identified by 'repl'; grant replication slave on *.* to 'repl'@'%';
主库上执行命令,获取当前binlog日志及位置
show master status;
获取file,position信息,在两个从库上分别执行如下脚本
CHANGE MASTER TO
MASTER_HOST='192.168.56.5',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWord='repl',
MASTER_LOG_FILE='mysql_bin.000002',
MASTER_LOG_POS=154;
从库上,启动复制,并查看复制状态
start slave;
show slave status;
^说明: 如出现如图字样,表示成功。关于slave的命令,可以通过help slave;
--结束END--
本文标题: mysql 学习笔记之主从复制 Replication
本文链接: https://www.lsjlt.com/news/46609.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-13
2024-05-13
2024-05-13
2024-05-13
2024-05-12
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0