现在有一个这样的想法,在单机上安装两个MYSQL SERVER,然后把这两个MYSQL SERVER设置成SQL NODE,做成CLUSTER,但是在逻辑上碰到一个这样的问题,我的MANAGE NODE的配置文件上应该怎么去写,下面是我在单机上只安装一个MYSQL SERVER的配置:
[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)
[mysqld]
hostname=10.192.7.14红色的这里应该怎么写,是不是要加上PORT呢?
[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)
[mysqld]
hostname=10.192.7.14红色的这里应该怎么写,是不是要加上PORT呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货