我的配置如下:
# Options affecting ndbd processes on all data nodes:
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=1024M # How much memory to allocate for data storage
IndexMemory=800M # 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.MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=24576
#MaxNoOfConcurrentOperations=100000# TCP/IP options:
[tcp default]
portnumber=2202 # This the default; however, you can use any port that is free
# for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and allow the default value to be used instead
#SendBufferMemory=2M
#ReceiveBufferMemory=2M# Management process options:
[ndb_mgmd]
hostname=10.192.7.16 # Hostname or IP address of management node
datadir=/var/lib/mysql-cluster # Directory for management node log files# Options for data node "A":
[ndbd]
# (one [ndbd] section per data node)
hostname=10.192.7.15 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files# Options for data node "B":
[ndbd]
hostname=10.192.7.16 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files# SQL node options:
[mysqld]
hostname=10.192.7.13 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
id=4[mysqld]
hostname=10.192.7.13
id=6[mysqld]
hostname=10.192.7.14
id=5[mysqld]
hostname=10.192.7.14
id=7
[mysqld]
[mysqld]但是我在10.192.7.13和10.192.7.14机器上各增加了一个MYSQL SERVER后,它们就自动连接进CLUSTER,请教是怎么回事?
还有一个问题,我在CLUSTER中增加用户的时候,为什么在CLUSTER中的其他实例没有增加该用户,是否对于用户是不能同步的?谢谢。
# Options affecting ndbd processes on all data nodes:
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=1024M # How much memory to allocate for data storage
IndexMemory=800M # 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.MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=24576
#MaxNoOfConcurrentOperations=100000# TCP/IP options:
[tcp default]
portnumber=2202 # This the default; however, you can use any port that is free
# for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and allow the default value to be used instead
#SendBufferMemory=2M
#ReceiveBufferMemory=2M# Management process options:
[ndb_mgmd]
hostname=10.192.7.16 # Hostname or IP address of management node
datadir=/var/lib/mysql-cluster # Directory for management node log files# Options for data node "A":
[ndbd]
# (one [ndbd] section per data node)
hostname=10.192.7.15 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files# Options for data node "B":
[ndbd]
hostname=10.192.7.16 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files# SQL node options:
[mysqld]
hostname=10.192.7.13 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
id=4[mysqld]
hostname=10.192.7.13
id=6[mysqld]
hostname=10.192.7.14
id=5[mysqld]
hostname=10.192.7.14
id=7
[mysqld]
[mysqld]但是我在10.192.7.13和10.192.7.14机器上各增加了一个MYSQL SERVER后,它们就自动连接进CLUSTER,请教是怎么回事?
还有一个问题,我在CLUSTER中增加用户的时候,为什么在CLUSTER中的其他实例没有增加该用户,是否对于用户是不能同步的?谢谢。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货