请教一个问题。正在做一个测试MGM节点已经connect 了, 但是SQLD 节点还没有连接上不知道为什么?
只有2台server 192.168.1.1 MGM NDBD SQLD
192.168.1.2 NDBD SQLD
sofeware: MGM node:MySQL-Cluster-gpl-management-7.0.9-0.rhel5.x86_64.rpm
MySQL-Cluster-gpl-tools-7.0.9-0.rhe15.x86_64.rpm
SQL node: MySQL-server-community-5.1.48-1.rhel5.x86_64.rpm
MGM config.ini:
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=1 # Number of replicas
#DataMemory=500M # How much memory to allocate for data storage
#IndexMemory=100M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
# TCP/IP options:
#[TCP DEFAULT]
#portnumber=2222# Management process options:
[NDB_MGMD]
hostname=192.168.1.1 # MGM node
datadir=/var/lib/mysql-cluster/mgmdata # MGM node
#PortNumber=2001 #MGM node# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.1.1 # Data node 1
datadir=/var/lib/mysql-cluster/ndbdata #Data node 1# Options for data node "B":
[NDBD]
hostname=192.168.1.2 # Data node 2
datadir=/var/lib/mysql-cluster/ndbdata # Data node 2[MYSQLD]
id=4
hostname=192.168.1.1 # SQL node 1
[MYSQLD]
id=5
hostname=192.168.1.2 # SQL node 2
现在MGM 可以起来。但是MYSQLD节点起不来:配置如下:my.cnf(修改后的) 红色部分为修改后的,不修改MYSQL 就能启起来
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=192.168.1.1skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin# binary logging format - mixed recommended
binlog_format=mixed# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
请大虾指导下 谢谢~~~
只有2台server 192.168.1.1 MGM NDBD SQLD
192.168.1.2 NDBD SQLD
sofeware: MGM node:MySQL-Cluster-gpl-management-7.0.9-0.rhel5.x86_64.rpm
MySQL-Cluster-gpl-tools-7.0.9-0.rhe15.x86_64.rpm
SQL node: MySQL-server-community-5.1.48-1.rhel5.x86_64.rpm
MGM config.ini:
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=1 # Number of replicas
#DataMemory=500M # How much memory to allocate for data storage
#IndexMemory=100M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
# TCP/IP options:
#[TCP DEFAULT]
#portnumber=2222# Management process options:
[NDB_MGMD]
hostname=192.168.1.1 # MGM node
datadir=/var/lib/mysql-cluster/mgmdata # MGM node
#PortNumber=2001 #MGM node# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.1.1 # Data node 1
datadir=/var/lib/mysql-cluster/ndbdata #Data node 1# Options for data node "B":
[NDBD]
hostname=192.168.1.2 # Data node 2
datadir=/var/lib/mysql-cluster/ndbdata # Data node 2[MYSQLD]
id=4
hostname=192.168.1.1 # SQL node 1
[MYSQLD]
id=5
hostname=192.168.1.2 # SQL node 2
现在MGM 可以起来。但是MYSQLD节点起不来:配置如下:my.cnf(修改后的) 红色部分为修改后的,不修改MYSQL 就能启起来
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=192.168.1.1skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin# binary logging format - mixed recommended
binlog_format=mixed# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
请大虾指导下 谢谢~~~
100803 11:20:17 [Note] Plugin 'FEDERATED' is disabled.
100803 11:20:17 InnoDB: Started; log sequence number 0 44233
100803 11:20:17 [ERROR] /usr/sbin/mysqld: unknown option '--ndbcluster'
100803 11:20:17 [ERROR] Aborting
这个不是要等于2吗
我装上了的,数据节点都可以连上去,但是SQL节点就是连不上去啊。想问个问题 5.1.48 (MySQL-server-community-5.1.48-1.rhel5.x86_64.rpm) 支持MySQL的cluster 吗?
SQL-Cluster-gpl-server-7.1.5-1.rhel5.x86_64.rpm