系统提示:这是一个从旧版社区导入的帖子。
如果显示不正常,或需要查找旧帖中上传的附件,请参照原帖。
原帖地址:http://my.iecn.net/bbs/view/104644.html
如非必要,请不要修改此帖!如果修改,请保留以上信息。
你好,请教一下MYSQL 5怎么用RPM包在LINUX 9下安装群集?
应该使用那些包呢?我用的是在这里
http://dev.mysql.com/downloads/mysql/5.0.html的
Linux x86 generic RPM (dynamically linked) downloads
我下载了MySQL-server,MySQL-Max,MySQL-ndb-stroage,MySQL-tools,MySQL-extra,MySQL-manager,这几个包
然后还从其它地方下载了一个per-DBI的包,,,好像被依赖
我现在环境是这样的
pc01: ndb+mysql_api 192.168.2.41
pc02: ndb+mysql_api 192.168.2.42
pc03: mgm 192.168.2.43
配置文件如下
++++++++++++++++my.cnf++++++++++++++++++
# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring=192.168.2.43 # location of MGM node
# Options for ndbd process:
[MYSQL_CLUSTER]
ndb-connectstring=192.168.2.43 # location of MGM node
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*******************config.ini******************
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # 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=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
# Management process options:
[NDB_MGMD]
hostname=192.168.2.43 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=192.168.2.41 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# Options for data node "B":
[NDBD]
hostname=192.168.2.42 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# SQL node options:
[MYSQLD]
hostname=192.168.2.41 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[MYSQLD]
hostname=192.168.2.42
***********************************************
然后我在pc03运行如下命令
mkdir -p /var/lib/mysql-cluster/
cp config.ini /var/lib/mysql-cluster/
rpm -Uvh MySQL-ndb-manager-versions.rpm
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
然后在pc01和pc02运行如下命令
mkdir -p /usr/local/mysql/data
cp my.cnf /etc/my.cnf
rpm -Uvh MySQL-ndb-storage-version.rpm
rpm -Uvh MySQL-ndb-tools-version.rpm
rpm -Uvh MySQL-ndb-extra-version.rpm
ndbd --initial (首次运行的时候才使用initial参数)
然后我在pc01或pc02任意一台机运行如下命令都出错
rpm -Uvh per-DBI-*.rpm
rpm -Uvh MySQL-Client-version.rpm
rpm -Uvh MySQL-server-version.rpm
//这时候就出错了,提示"unknow variable 'ndb-connectstring=192.168.2.43'"
//然后我以为是server不支持ndb engine,我再装上MySQL-Max包
rpm -Uvh MySQL-Max-version.rpm
还是同样的错误"unknow variable 'ndb-connectstring=192.168.2.43'"
但是我man mysqld,确实是有这个参数的,
而且我确定没有拼写错误,网络是一定是通的,防火墙一定是关的。
请问知道这个问题怎么样解决呢?