以下master-master
configuration在MySQL Server 5.1.x(Ubuntu 10.04)上工作。
################################## #MySQL Replication ################################## skip-host-cache skip-name-resolve event_scheduler = ON max_connections = 500 max_connect_errors = 1000 server-id = 10 replicate-same-server-id = 0 auto-increment-increment = 10 auto-increment-offset = 1 master-host = 192.168.2.81 master-user = repli master-password = secret master-connect-retry = 60 binlog-format = MIXED #binlog-ignore-db = information_schema #binlog-ignore-db = lb1 #max_binlog_size = 500M log-bin = /var/log/mysql/mysql-bin log-bin-index = /var/log/mysql/bin-log.index log-slave-updates report-host = 192.168.2.80 replicate-ignore-db = information_schema replicate-ignore-db = lb2 replicate-ignore-db = performance_schema relay_log_space_limit = 3G relay-log = /var/log/mysql/relay.log relay-log-index = /var/log/mysql/relay-log.index ##################################
################################## #MySQL Replication ################################## skip-host-cache skip-name-resolve event_scheduler = ON max_connections = 500 max_connect_errors = 1000 server-id = 20 replicate-same-server-id = 0 auto-increment-increment = 10 auto-increment-offset = 2 master-host = 192.168.2.80 master-user = repli master-password = secret master-connect-retry = 60 binlog-format = MIXED #binlog-ignore-db = information_schema #binlog-ignore-db = lb2 #max_binlog_size = 500M log-bin = /var/log/mysql/mysql-bin log-bin-index = /var/log/mysql/bin-log.index log-slave-updates report-host = 192.168.2.81 replicate-ignore-db = information_schema replicate-ignore-db = lb1 replicate-ignore-db = performance_schema relay_log_space_limit = 3G relay-log = /var/log/mysql/relay.log relay-log-index = /var/log/mysql/relay-log.index ##################################
现在它不适用于MySQL Server 5.5(Ubuntu 12.04)。 我的意思是说,当我重新启动与上述configuration的MySQL服务,MySQL服务需要很长的时间来启动,而不是“开始。 没有在MySQL日志中,是空的。 我试图杀死MySQL,并再次启动,但仍然没有启动,如果我删除上述复制configuration,然后通常开始。
我在用MySQL 5.5做什么错? 我打算在Ubuntu服务器上设置一个四节点群集,并使用mysql复制进行HA和故障切换。 Ubuntu 12.04
和MySQL 5.5
推荐用于生产吗?
需要你的投入。 谢谢!
在master上注释以下master-*
行之后,MySQL会正常启动并且复制工作。
#master-host = 192.168.2.xx #master-user = repli #master-password = secret #master-connect-retry = 60
那么如何在从服务器上指定主服务器? CHANGE MASTER TO MASTER_HOST='192.168.2.xx', MASTER_USER='repli', MASTER_PASSWORD='secret',...
够了吗? MySQL 5.5.24和Ubuntu 12.04的生产准备好了吗?
我的意思是说,当我重新启动与上述configuration的MySQL服务,MySQL服务需要很长的时间来启动,而不是“开始。 没有在MySQL日志中,是空的。
你在/etc/my.cnf
指定了log-error
选项吗?
在master上注释以下
master-*
行之后,MySQL会正常启动并且复制工作。#master-host = 192.168.2.xx #master-user = repli #master-password = secret #master-connect-retry = 60
那么如何在从服务器上指定主服务器?
CHANGE MASTER TO MASTER_HOST='192.168.2.xx', MASTER_USER='repli', MASTER_PASSWORD='secret',...
够了吗?
master-*
选项在MySQL 5.5中删除。 当然, CHANGE MASTER TO
就足够了,因为这个值被保存到master.info
文件中。
MySQL 5.5.24和Ubuntu 12.04的生产准备好了吗?
是。 但是请看看这个更多的信息。