配置Mysql数据库的主从同步教程教程.docVIP

配置Mysql数据库的主从同步教程 主从同步是实现网站分布式数据处理一个非常常用的方案了,今天我来为各位介绍配置Mysql数据库的主从同步(双主)教程,希望下文能帮助到各位哦. 配置Mysql数据库的主从同步(一主一从). 一、主库开启BINLOG、server-id [root@Master-Mysql ~]# grep -E server-id|log-bin /etc/f log-bin = /usr/local/mysql/data/mysql-bin server-id = 1 mysql show variables like %log_bin%; +---------------------------------+---------------------------------------+ | Variable_name | Value | +---------------------------------+---------------------------------------+ | log_bin | ON | | log_bin_basename | /usr/local/mysql/data/mysql-bin | | log_bin_index | /usr/local/mysql/data/mysql-bin.index | | log_bin_trust_function_creators | OFF | | log_bin_use_v1_row_events | OFF | | sql_log_bin | ON | +---------------------------------+---------------------------------------+ 6 rows in set (0.01 sec) -- mysql show variables like %server_id%; +----------------+-------+ | Variable_name | Value | +----------------+-------+ | server_id | 1 | | server_id_bits | 32 | +----------------+-------+ 2 rows in set (0.00 sec) 备注:以上两个信息必须在[mysqld]模块下！！！ 二、给从库授权 mysql grant replication slave on *.* to byrd@192.168.199.% identified by admin; mysql flush privileges; mysql select user,host from mysql.user; +------+---------------+ | user | host | +------+---------------+ | root | | | byrd | 192.168.199.% | | root | ::1 | | root | lamp | | root | localhost | +------+---------------+ 5 rows in set (0.00 sec) 锁表前建立点数据: mysql create database hitest; mysql show databases; +--------------------+ | Database | +--------------------+ | hitest | +--------------------+ 6 rows in set (0.00 sec) mysql use hitest; mysq