mysql集群

①版本:mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64

②概述:

                三台服务器:
                    xxx.xx.xxx.1:    管理节点,    sql节点
                    xxx.xx.xxx.2:    数据节点(1)    sql节点
                    xxx.xx.xxx.3:    数据节点 (2)   sql节点

③配置文件:

config.ini

    [ndbd default]

NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[mysqld default]

[ndb_mgmd default]

[tcp default]

Cluster Control / Management node

[ndb_mgmd]
hostname=xxx.xx.xx.1
datadir=/var/lib/mysql-cluster/cluster-data
NodeId=1
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000

Data Node 1

[ndbd]
hostname=xxx.xx.xxx.2
datadir=/usr/local/mysql/data
NodeId=2
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000

Data Node 2

[ndbd]
hostname=xxx.xx.xxx.3
datadir=/usr/local/mysql/data
NodeId=3
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000

SQL Node

[mysqld]
hostname=xxx.xx.xxx.1
NodeId=4

[mysqld]
hostname=xxx.xx.xxx.2
NodeId=5

[mysqld]
hostname=xxx.xx.xxx.3
NodeId=6

If you to add new SQL Node

[mysqld]

[mysqld]

[mysqld]

my.cnf(xxx.xx.xxx.2)

jinsan@shopping2:~$ cat /etc/my.cnf
[mysqld]
ndbcluster # run NDB storage engine
datadir=/data/mysql
basedir=/opt/mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64
ndb-connectstring=172.17.154.237
user=mysql

sql_mode=NO_ENGINE_SUBSTITUTION #,STRICT_TRANS_TABLES
max_connections=500
interactive_timeout=28800
wait_timeout=28800

explicit_defaults_for_timestamp=true

[mysql_cluster]
ndb-connectstring=172.17.154.237

my.cnf(xxx.xx.xxx.3)

root@shopping3:/home/jinsan# cat /etc/my.cnf
[mysqld]
ndbcluster # run NDB storage engine
datadir=/data/mysql
basedir=/opt/mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64
ndb-connectstring=xxx.xx.xxx.1

sql_mode=NO_ENGINE_SUBSTITUTION #,STRICT_TRANS_TABLES
max_connections=500
interactive_timeout=28800
wait_timeout=28800

explicit_defaults_for_timestamp=true

[mysql_cluster]
ndb-connectstring=xxx.xx.xxx.1

④问题:

    管理节点,sql节点均正常,
数据节点1正常,
    数据节点2启动时:
    ndb_mgm> Node 3: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9.




    请问大神原因是什么 ?  该怎么处理?    不是新搭建的集群,是运行一段时间后

https://blog.csdn.net/mchdba/article/details/10506305

每个节点都是用root 用户启动

我碰到这个报错是管理节点的

DataMemory=80M
IndexMemory=18M

配太大了  数据节点内存不足报的错 我将这个改小就顺利启动了