Mysql双主模式教案.doc

Mysql双主模式 安装mysql yum list mysql-server yum install mysql-server service mysqld start 修改mysql密码： mysql set password for root@localhost = password(123); Centos6.5搭建Mysql双主模式 设置同步账号密码及权限 Db1： mysql grant all privileges on *.* to root@192.168.60.239 identified by root with grant option; mysql flush privileges; Db2： grant all privileges on *.* to root@192.168.60.239 identified by root with grant option; mysql flush privileges; 测试： mysql -h 192.168.60.233 -usroot -proot mysql -h 192.168.60.234 -usroot -proot 修改MySQL配置文件 修改 vim /etc/my.cnf 以root登陆DBS1，vim /etc/my.cnf 文件： Vim /etc/my.cnf 在[mysqld]的配置项中增加如下配置: [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 port=3306 skip-external-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M thread_concurrency = 2 log-bin=mysql-bin relay-log=mysql-relay-log binlog_format=mixed server-id = 1 auto-increment-increment=10 auto-increment-offset=1 以root用户登录ServDB2，修改ServDB2的my.cnf文件: [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port=3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 skip-external-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M thread_concurrency = 2 log-bin=mysql-bin binlog_format=mixed server-id = 2 auto-increment-increment=10 auto-increment-offset=2 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_siz