Mysql集群配置简要说明 V2.0(8)

mysql 集群搭建的步骤

DataMemory=4G

IndexMemory=1G

LockPagesInMainMemory=1

ODirect=1

[ndbd]

HostName=192.168.1.100

DataDir=/usr/local/mysql/data

NodeId=1

[ndbd]

HostName=192.168.1.101

DataDir=/usr/local/mysql/data

NodeId=2

[mysqld]

HostName=192.168.1.100

NodeId=61

[mysqld]

HostName=192.168.1.101

NodeId=62

1.2.2.3 配置数据节点

创建 Data node 和 SQL node 节点的配置文件，vi /etc/f

# Options for mysqld process:

ndbcluster # run NDB storage engine

[mysql_cluster]

# Options for MySQL Cluster processes:

ndb-connectstring=192.168.1.100 # location of management server

1.2.2.4 配置SQL节点

创建 Data node 和 SQL node 节点的配置文件，vi /etc/f

# Options for mysqld process:

ndbcluster # run NDB storage engine

[mysql_cluster]

# Options for MySQL Cluster processes:

ndb-connectstring=192.168.1.100 # location of management server