本页主题: 你好,请教一下MYSQL 5怎么用RPM包在LINUX 9下安装群集? 打印 | 加为IE收藏 | 复制链接 | 收藏主题 | 上一主题 | 下一主题

gdy1039
级别: 入门弟子


精华: 0
发帖: 2
威望: 2 点
财富: 816 K币
贡献值: 0 点
注册时间:2006-08-08
最后登录:1970-01-01

 你好,请教一下MYSQL 5怎么用RPM包在LINUX 9下安装群集?

系统提示:这是一个从旧版社区导入的帖子。
如果显示不正常,或需要查找旧帖中上传的附件,请参照原帖。
原帖地址: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,确实是有这个参数的,
而且我确定没有拼写错误,网络是一定是通的,防火墙一定是关的。

请问知道这个问题怎么样解决呢?
顶端 Posted: 2006-08-08 17:52 | [楼 主]
gdy1039
级别: 入门弟子


精华: 0
发帖: 2
威望: 2 点
财富: 816 K币
贡献值: 0 点
注册时间:2006-08-08
最后登录:1970-01-01

 这应该是MYSQL的BUG

如果在MYSQL-SERVER安装之前就已经写了/etc/my.cnf,并在里面有群集的连接参数就会有这个问题。并且一旦出错,就必需要把所有MYSQL包删除掉重装正确安装才可以。
正确的安装方法应该是安装好MYSQL-SERVER,再安装MYSQL-MAX,然后再写/etc/my.cnf,然后再启动群集。

但是其实我还有其它问题,但那些会的“高手”好像没时间理我们这些低手

系统提示:这是一个从旧版导入的帖子,如有问题请参照原帖(原帖地址见顶楼)。

顶端 Posted: 2006-10-20 10:18 | 1 楼
帖子浏览记录 版块浏览记录
IECN社区 » PHP/MySQL

Time now is:11-21 02:19, Gzip disabled 京ICP备06069722号
Powered by PHPWind v6.3.2 Certificate Code © 2003-08 PHPWind.com Corporation