mysql 设置主从同步

1. 主从服务器安装相同服务....略
2. 配置主服务器

vim /etc/my.conf

[mysqld]
log-bin=mysql-bin
server-id=1

3. 启动主服务, 并配置同步账号

systemctl start mysqld  
//登录mysql
GRANT REPLICATION SLAVE ON *.* TO  'userName'@'%'  IDENTIFIED BY 'yourPassword';
FLUSH PRIVILEGES;
show master status; //记住File 和Position
mysqldump dbname -uroot -p > dbname.sql  //将对应库导出来.

4. 修改从服务配置

vim /etc/my.conf
[mysqld]
server-id=2

5. 启动从服务, 并配置同步配置

systemctl start mysqld  //启动服务
mysql -uroot -p  //登录
source /path/to/dbname.sql //导入数据

CHANGE MASTER TO MASTER_HOST='masterServerIp', MASTER_PORT=masterPort, MASTER_USER='masterUser', MASTER_PASSWORD='masterPassword', MASTER_LOG_FILE='masterLogFile', MASTER_LOG_POS=masterPosition;

start slave;