mysql-5.1.73在centos6.4上配置主从

最新推荐文章于 2022-11-11 15:52:02 发布

liangxin1572

最新推荐文章于 2022-11-11 15:52:02 发布

阅读量327

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/liangxin1572/article/details/38265065

mysql 专栏收录该内容

3 篇文章

订阅专栏

http://www.cnblogs.com/jankie/archive/2011/08/17/2143658.html

两台机器： node-21 node-22

node-21上的配置文件

[mysqld]
server-id=1
log-bin=mysql-bin
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

node-22上的配置文件

[mysqld]
server-id=2
log-bin=mysql-bin
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

grant replication slave on *.* to 'slave_server'@'10.10.10.22' identified by 'qwer1234';

change master to MASTER_HOST='10.10.10.21', MASTER_PORT=3306, MASTER_USER='slave_server', MASTER_PASSWORD='qwer1234';