当前位置：首页 → 问答吧 → mysql 配置proxy数据分离

mysql 配置proxy数据分离

时间：2011-06-29

来源：互联网

大家好:

我在配置Mysql 数据分离的时候，修改my.cnf后启动数据库报错：Starting MySQL...The server quit without updating PID file (/var/lib/mysql/CM-DB1.pid).[失败]  那位可以帮助解决一下啊？

日志内容如下：

110629 12:20:28 InnoDB: Initializing buffer pool, size = 128.0M
110629 12:20:28 InnoDB: Completed initialization of buffer pool
110629 12:20:28 InnoDB: highest supported file format is Barracuda.
110629 12:20:28  InnoDB: Waiting for the background threads to start
110629 12:20:29 InnoDB: 1.1.7 started; log sequence number 1599427
110629 12:20:29 [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=192.168.2.3'
110629 12:20:29 [ERROR] Aborting

110629 12:20:29  InnoDB: Starting shutdown...
110629 12:20:30  InnoDB: Shutdown completed; log sequence number 1599427
110629 12:20:30 [Note] /usr/sbin/mysqld: Shutdown complete

清大家多多指教啊

作者: 一路随行发布时间: 2011-06-29

QUOTE:原帖由一路随行于 2011-6-29 12:32 发表
大家好:

我在配置Mysql 数据分离的时候，修改my.cnf后启动数据库报错：Starting MySQL...The server quit without updating PID file (/var/lib/mysql/CM-DB1.pid).[失败]  那位可以帮助解决一下啊？

日志内容如下：

110629 12:20:28 InnoDB: Initializing buffer pool, size = 128.0M
110629 12:20:28 InnoDB: Completed initialization of buffer pool
110629 12:20:28 InnoDB: highest supported file format is Barracuda.
110629 12:20:28  InnoDB: Waiting for the background threads to start
110629 12:20:29 InnoDB: 1.1.7 started; log sequence number 1599427
110629 12:20:29 [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=192.168.2.3'
110629 12:20:29 [ERROR] Aborting

110629 12:20:29  InnoDB: Starting shutdown...
110629 12:20:30  InnoDB: Shutdown completed; log sequence number 1599427
110629 12:20:30 [Note] /usr/sbin/mysqld: Shutdown complete

清大家多多指教啊

错误很明显，不支持参数：
/usr/sbin/mysqld: unknown variable 'master-host=192.168.2.3'

my.cnf文件中注销此东西即可....

作者: jinguanding 发布时间: 2011-06-29

master-host=192.168.2.3 此参数应该是在mysql-proxy的配置文件中出现的,...

作者: jinguanding 发布时间: 2011-06-29