mysql5.5远程主从设置
主机:10.0.0.1
从机:10.0.0.2
1 主机设置
1.1 配置文件/etc/mysql/my.cnf
server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 2 max_binlog_size = 100M binlog_ignore_db = mysql binlog_ignore_db = information_schema binlog_ignore_db = performance_schema binlog_do_db = testcase binlog_do_db = db100 binlog_do_db = db200
1.2 mysql控制台命令启动master模式
mysql>GRANT replication slave on *.* to 'slave2'@'10.0.0.2' IDENTIFIED BY 'password'; mysql>SHOW master status;
2 从机设置
2.1 从机配置
server-id = 2 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 2 max_binlog_size = 100M
2.2 从机控制台命令
mysql>slave stop; mysql>change master to master_host='10.0.0.1', master_port=3306, master_user='slave2', master_password='password', master_log_file='mysql-bin.000011', master_log_pos=189; mysql>slave start; mysql>show slave status \G;
3mysql远程账号设置
mysql>grant all privileges on *.* to njava@10.0.0.1 identified by "password" with grant option;
Leave a Reply
标签云
.htaccess 301 2010 Android apache cache cacti CSS date ddos discuz django fastcgi freebsd git google http iftop linux macos mysql nginx njava php pr python sed seo snmp ssh ubuntu ubuntu10.04 wordpress xdebug 优化 密码 文件 时区 用户 登录 监控 缓存 网站 脚本 颜色
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
近期文章
近期评论
文章归档
链接表
QR Code
