环境:
PC:ubuntu 10.10 192.168.1.112(master) 192.168.10.245(slave)
MySQL : 5.1.49-1ubuntu8.1-log
在master中已经存在数据库test
首先修改mysql配置文件:/etc/mysql/my.cnf
[master]
#author:zhxia
1 #master 同步设置
2 server-id = 1
3 log_bin = /var/log/mysql/mysql-test-bin.log
4 expire_logs_days = 10
5 max_binlog_size = 100M
6 binlog_format =mixed
[slave]
#author:zhxia
PC:ubuntu 10.10 192.168.1.112(master) 192.168.10.245(slave)
MySQL : 5.1.49-1ubuntu8.1-log
在master中已经存在数据库test
首先修改mysql配置文件:/etc/mysql/my.cnf
[master]
#author:zhxia
1 #master 同步设置
2 server-id = 1
3 log_bin = /var/log/mysql/mysql-test-bin.log
4 expire_logs_days = 10
5 max_binlog_size = 100M
6 binlog_format =mixed
[slave]
#author:zhxia