mysql主从复制的步骤
master端192.168.200.771.在/etc/my.cnf里添加
log-bin=mysql-bin
server-id=1
2.查看设置是否生效
一、在data目录是否有mysql-bin.000001文件和mysql-bin.index文件
二、mysql> show variables like '%log_bin%';
+---------------------------------+---------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------+
| log_bin | ON |
| log_bin_basename | /application/mysql/data/mysql_log_bin |
| log_bin_index | /application/mysql/data/mysql_log_bin.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| sql_log_bin | ON |
+---------------------------------+---------------------------------------------+
6 rows in set (0.02 sec)
3.添加mysql用户，给slave连接使用
mysql> grant replication slave on *.* to 'rep'@'%'> mysql> flush privileges;
4.备份主库数据库
1.flush table with read lock;
2.另开一个窗口
mysqldump -uroot -poldboy -A -B --master-data=2 >/tmp/mysql_all_B.sql
可以查看bin-log信息
mysql>show master status;
mysql>show master logs;
3.unlock tables;
#########################################################################
salve端192.168.200.88
1.修改/etc/my.cnf里添加
server-id=2
2.mysql -uroot -poldboy
页:
[1]