操作系统redhat6.5x86-64,mysqlndbcluster7.5,mysql5.7我的mysqlndbcluster无法开启binlog日志,相关配置如下:管理节点配置:[ndbddefault]NoOfReplicas=2DataMemory=512MIndexMemor...
操作系统redhat 6.5 x86-64,mysql ndb cluster 7.5 ,mysql 5.7
我的mysql ndb cluster无法开启binlog日志,相关配置如下:
管理节点配置:
[ndbd default]
NoOfReplicas=2
DataMemory=512M
IndexMemory=20M
MaxNoOfTables=1024
MaxNoOfOrderedIndexes=2000
[ndb_mgmd]
NodeId=29
HostName=192.168.2.224
DataDir=/var/lib/mysql-cluster
[ndbd]
NodeId=1
HostName=192.168.2.222
DataDir=/var/lib/mysql-cluster
[ndbd]
NodeId=2
HostName=192.168.2.223
DataDir=/var/lib/mysql-cluster
[mysqld]
HostName=192.168.2.222
[mysqld]
HostName=192.168.2.223
[mysqld]
两个数据节点/sql节点配置如下:
[mysqld]
ndbcluster
user=mysql
ndb-connectstring=192.168.2.224
default-storage-engine=ndbcluster
skip-name-resolve
innodb_file_per_table=1
character_set_server=utf8
open_files_limit=65535
slow_query_log=1
long_query_time=5
max_connections=2000
log-bin=MySQL-bin
[mysql_cluster]
ndb-connectstring=192.168.2.224
只要sql节点一加 log-bin=MySQL-bin 这个开启binlog的配置启动就报错:
[root@qiucheng data]# service msyql restart
msyql: unrecognized service
[root@qiucheng data]# service mysql restart
Shutting down MySQL.....[ OK ]
Starting MySQL.The server quit without updating PID file (/usr/local/mysql/data/qiucheng.pid).[FAILED]
奇怪的是日志文件不写日志,关闭和正常启动都有日志。
所以想请大家帮忙看看是为什么?先行感谢各位的帮助!
展开