mysql配置完半同步复制之后报错[ERROR] The server quit without updating PID file

  1. 云栖社区>
  2. 博客>
  3. 正文

mysql配置完半同步复制之后报错[ERROR] The server quit without updating PID file

augusite 2018-11-23 11:19:00 浏览445
展开阅读全文

修改配置,MySQL启动报:[ERROR] The server quit without updating PID file

 

 

[root@localhost mysql]# /etc/init.d/mysqld start

Starting MySQL...

[ERROR] The server quit without updating PID file (/usr/local/mysql/data/mysqld.pid).
---------------------

查看错误日志发现:

   140306 14:13:40 [ERROR] /usr/sbin/mysqld: unknown variable 'rpl_semi_sync_master_enabled=1'
   140306 14:13:40 [ERROR] Aborting

 

 /etc/init.d/mysqld restart --plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so";

Shutting down MySQL.. SUCCESS! 
Starting MySQL.... SUCCESS!

另外,如果嫌这种写法比较麻烦还可以放在my.cnf里[mysqld]下,多个.so 可使用;隔开

plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"

 

 

http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-grant-tables
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_plugin-load
---------------------
作者:freedom3959
来源:CSDN
原文:https://blog.csdn.net/lidan3959/article/details/20636237

网友评论

登录后评论
0/500
评论
augusite
+ 关注