MySQL

• mysql 主從配置
• 實戰: mysql 主從配置
• 實戰: mysql 主主配置

1.2 複製技術有以下特點； 2.數據平衡

vim /etc/my.cnf symbolic-link=0 log-bin=mysqllog server-id=1 binlog-do1-db=tree

service mysql restart

iptables -F 給 grant grant replication slave on . to slave2ip identified by "123456" vim /etc/my.cnf server-id=2 master-host=192.168.1.63 master-user=slave master-password=123456

service mysql restart

show slave status \G