我按照网上的方法做了mysql的数据库集群,c:\mysql\bin\ndbd.exe --ndb-connectstring=192.168.0.35
在启动节点的时候老是报错,找不到什么原因。
没法解决,求大神指点一下
在config.ini 的脚本是
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files
# Forward slashes used in directory path,
# rather than backslashes. This is correct;
# see Important note in text
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to 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.
[ndb_mgmd]
# Management process options:
HostName=192.168.0.34 # Hostname or IP address of management node
DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files
[ndbd]
# Options for data node "A":
HostName=192.168.0.34 # Hostname or IP address
[ndbd]
# Options for data node "B":
HostName=192.168.0.35 # Hostname or IP address
[mysqld]
# SQL node A options:
HostName=192.168.0.34 # Hostname or IP address
[mysqld]
# SQL node B options:
HostName=192.168.0.35 # Hostname or IP address
在my.ini是这样写的[mysql_cluster]
# Options for management node process
config-file=C:/mysql/bin/config/config.ini
[client]
default_character_set=utf8[mysqld]
tmp_table_size=200M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
basedir=C:\\mysql
datadir=c:\\mysql\\data
character-set-server=utf8
max_connections=1000
explicit_defaults_for_timestamp=true
default-storage-engine=MyISAM
在启动节点的时候老是报错,找不到什么原因。
没法解决,求大神指点一下
在config.ini 的脚本是
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files
# Forward slashes used in directory path,
# rather than backslashes. This is correct;
# see Important note in text
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to 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.
[ndb_mgmd]
# Management process options:
HostName=192.168.0.34 # Hostname or IP address of management node
DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files
[ndbd]
# Options for data node "A":
HostName=192.168.0.34 # Hostname or IP address
[ndbd]
# Options for data node "B":
HostName=192.168.0.35 # Hostname or IP address
[mysqld]
# SQL node A options:
HostName=192.168.0.34 # Hostname or IP address
[mysqld]
# SQL node B options:
HostName=192.168.0.35 # Hostname or IP address
在my.ini是这样写的[mysql_cluster]
# Options for management node process
config-file=C:/mysql/bin/config/config.ini
[client]
default_character_set=utf8[mysqld]
tmp_table_size=200M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
basedir=C:\\mysql
datadir=c:\\mysql\\data
character-set-server=utf8
max_connections=1000
explicit_defaults_for_timestamp=true
default-storage-engine=MyISAM
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货