MySQL5.6主从同步操作记录

MySQL5.6主从同步操作记录
•发布于 •作者 liuzy •1283 次浏览 •来自资讯

```
## 主服务器 10.10.0.18
rpm -ivh MySQL-client-5.6.36-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-server-5.6.36-1.linux_glibc2.5.x86_64.rpm
/usr/bin/mysql_install_db
chown -R mysql:mysql /var/lib/mysql
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
	[client]
	default-character-set=utf8
	socket=/service01/mysql_data/mysql.scok
	[mysql]
	default-character-set=utf8
	socket=/service01/mysql_data/mysql.scok
	[mysqld]
	server_id=1
	port=3306
	character-set-server=utf8
	datadir=/service01/mysql_data
	socket=/service01/mysql_data/mysql.sock
	log_bin=mysql-bin
	log-bin-index=mysql-bin.index
	sync_binlog=1
	binlog_format=mixed
	binlog-ignore-db=mysql
	binlog-ignore-db=performance_schema
	binlog-ignore-db=information_schema
	binlog_checksum=NONE
	sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
service mysql start
cat .mysql_secret
mysql -uroot -p
SET password=PASSWORD("111111");
flush privileges;

mysql -uroot -p
grant replication slave on *.* to slave@10.10.0.19 identified by '111111';
flush privileges;
show master status;

## 从服务器 10.10.0.19
rpm -ivh MySQL-client-5.6.36-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-server-5.6.36-1.linux_glibc2.5.x86_64.rpm
/usr/bin/mysql_install_db
chown -R mysql:mysql /var/lib/mysql
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
	[client]
	default-character-set=utf8
	socket=/service01/mysql_data/mysql.scok
	[mysql]
	default-character-set=utf8
	socket=/service01/mysql_data/mysql.scok
	[mysqld]
	server_id=2
	port=3306
	character-set-server=utf8
	datadir=/service01/mysql_data
	socket=/service01/mysql_data/mysql.sock
	log_bin=mysql-bin
	relay-log-index=slave-relay-bin.index
	relay-log=slave-relay-bin
	sync_master_info=1
	sync_relay_log=1
	sync_relay_log_info=1
	sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
service mysql start
cat .mysql_secret
mysql -uroot -p
SET password=PASSWORD("111111");
flush privileges;

mysql -uroot -p
change master to master_host='10.10.0.18',master_user='slave',master_password='111111', master_log_file='mysql-bin.000004',master_log_pos=120;
start slave;
show slave status\G;

## 测试
登陆主服务器，输入：
create database liuzy;
登陆从服务器，输入：
show databases;
```

0 回复

作者

liuzy

积分: 833

“ 黑眼圈圈男 ”

无人回复话题

SonarQube 9.4 + PostgreSQL

shell倒计时

日常网络巧技

使用ssh创建socks5代理服务

NodeJS集群demo

作者其他话题

SonarQube 9.4 + PostgreSQL

shell倒计时

日常网络巧技

使用ssh创建socks5代理服务

NodeJS集群demo