免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
123下一页
最近访问板块 发新帖
查看: 9760 | 回复: 28
打印 上一主题 下一主题

mysql cluster 7.0.9到底有人在solaris上安装成功过没? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2010-02-25 09:19 |只看该作者 |倒序浏览
Linux版本我测试过了,cluster能够起来。

但是solaris版本的全部起来了,SQL节点就是无法加入到cluster中。
我怀疑MYSQL的人是否真的认证的测试过这个软件,一份reference manual讲的只是mysql server的安装,根本没有cluster。
还有,官网上的cluster安装都是 老版本,还是源代码安装。

我搞了2个星期了,网上各种文章都看过了,就是搞不成!!!


mysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz
mysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.pkg.gz


这两款软件我都测试过了,就是不行!!!日志显示SQL节点也起来了,就是无法加入cluster。
下面我将描述我的安装过程,非常的详细!!!
我知道chinaunix里面的solaris高手很多,平时不发帖,今日请大家帮助一下!!!万分感激。


我给大家磕头了!!!请大家帮助!!!

论坛徽章:
0
2 [报告]
发表于 2010-02-25 09:32 |只看该作者
我的问题发在这里
http://forums.mysql.com/read.php?25,354909,354909#msg-354909

下面我用中文发到这里。



我参考white paper [
Installation of MySQLTM 5.1 Cluster Software on the SolarisTM 10 OS for x64 Platforms
]安装mysql cluster 于 solaris10.

Management node, DATA node, SQL node都能成功起来,但是
"ndb_mgm> show显示,SQL node没有加入到cluster中。


首先,我试图把Management node, DATA node and SQL node安装在同一台机器上,同时启动,
尽管有告警“管理节点和DATA节点最好不要放一起,否则管理节点调度节点down掉的时候,会导致整个clusterdown掉。”但是我目前PC有限,我不让management节点down掉,应该允许我运行的。
结果:"ndb_mgm> show显示,SQL node没有加入到cluster中。
具体描述参见PART.I


后来,又找来一台电脑,上面只跑DATA节点。MANAGEMENT node, SQL node 跑在另外一台机器上。
结果
"ndb_mgm> show显示,SQL node没有加入到cluster中。
具体描述参见PART.II。


------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
Part I: Single server【单个server情况】

Management node, data node and SQL node都安装在同样的HOST上,共享同一个my.cnf.
-------------------------------------

My environment:
1)server: sunws05, Solaris 10 SPARC
2)software: mysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.pkg [unzipped]

------------------------------------------------------------------------


steps:
1.登录到server,切换到root context:
login as: yxiang
...
sunws05:/home/yxiang$
sunws05:/home/yxiang$ su
Password:***
# su - root
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
sunws05:/#
sunws05:/# bash

-------------------------------------


2. 清除mysql

2.1 杀死所有的mysql-related processes,结果:
sunws05:/# ps -ef |grep mysql
root 23297 22979 0 09:08:39 pts/3 0:00 grep mysql
sunws05:/#


2.2 卸载mysql
sunws05:/# pkginfo | grep mysql
application mysql MySQL Cluster Server (GPL)
sunws05:/# pkgrm mysql
.........................
Removal of <mysql> was successful.


2.3 清除数据和目录:
sunws05:/# cd /opt/mysql/mysql
sunws05:/opt/mysql/mysql# ls
data mysql-cluster
sunws05:/opt/mysql/mysql# rm -r data
sunws05:/opt/mysql/mysql# rm -r mysql-cluster
sunws05:/opt/mysql/mysql#

sunws05:/# cd /var/lib
sunws05:/var/lib# ls
gdm log mysql mysql-cluster pgsql sgml
sunws05:/var/lib# rm -r mysql
sunws05:/var/lib#

sunws05:/var/lib# cd /etc/mysql
sunws05:/etc/mysql# ls
config.ini my.cnf temp
sunws05:/etc/mysql#
sunws05:/etc/mysql# rm config.ini
sunws05:/etc/mysql# rm my.cnf

论坛徽章:
0
3 [报告]
发表于 2010-02-25 09:33 |只看该作者
3. 安装:
3.1 增加mysql user and group
sunws05:/var/lib# groupadd mysql
UX: groupadd: ERROR: mysql is already in use. Choose another.
sunws05:/var/lib# useradd -g mysql mysql
sunws05:/var/lib#

3.2 install software
sunws05:/opt/yxiang_soft# pkgadd -d mysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.pkg
...
MySQL Cluster Server (GPL)(sun4u) 7.0.9
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.
Using </opt/mysql> as the package base directory.
...
Do you want to continue with the installation of <mysql> [y,n,?]
...
## Installing part 1 of 1.
...
/opt/mysql/mysql/bin/mysql
...
/opt/mysql/mysql/bin/mysql_upgrade
...
/opt/mysql/mysql/bin/mysqladmin
/opt/mysql/mysql/bin/mysqlbinlog
...
Installation of <mysql> was successful.


-------------------------------------


4.查看mysql cluster信息:
4.1 mysql cluster
sunws05:/# cd /opt/mysql/mysql
sunws05:/opt/mysql/mysql# ls
COPYING README docs man share
EXCEPTIONS-CLIENT bin include mysql-test sql-bench
INSTALL-BINARY data lib scripts support-files
sunws05:/opt/mysql/mysql# cd data
sunws05:/opt/mysql/mysql/data# ls
mysql test
~~~~~~~~~~~Here we can see that two default sub-databases are installed.

4.2 priority of mysql
sunws05:/opt/mysql# ls -l mysql
total 218
-rw-r--r-- 1 root bin 19071 Nov 18 06:01 COPYING
-rw-r--r-- 1 root bin 5139 Nov 18 06:01 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root bin 9439 Nov 18 06:01 INSTALL-BINARY
-rw-r--r-- 1 root bin 62989 Nov 18 06:01 README
drwxr-xr-x 2 root bin 2048 Feb 12 09:42 bin
drwxr-xr-x 4 mysql mysql 512 Feb 12 09:42 data
drwxr-xr-x 2 root bin 512 Feb 12 09:42 docs
drwxr-xr-x 3 root bin 1024 Feb 12 09:42 include
drwxr-xr-x 3 root bin 1024 Feb 12 09:42 lib
drwxr-xr-x 4 root bin 512 Feb 12 09:42 man
drwxr-xr-x 10 mysql mysql 512 Feb 12 09:43 mysql-test
drwxr-xr-x 2 root bin 512 Feb 12 09:43 scripts
drwxr-xr-x 28 root bin 1024 Feb 12 09:43 share
drwxr-xr-x 5 root bin 1024 Feb 12 09:43 sql-bench
drwxr-xr-x 2 root bin 512 Feb 12 09:43 support-files
sunws05:/opt/mysql#


-------------------------------------


5. 配置mysql cluster
Management node, data node and SQL node all run on the same server.
They share the same my.cnf

5.1 /etc/mysql/my.cnf
###################[my.cnf for Management/SQL/storage node]####################
[mysqld]
user=mysql
ndbcluster
ndb-connectstring=10.80.1.15
datadir=/var/lib/mysql
[ndb_mgm]
connect-string=10.80.1.15
[ndb_mgmd]
config-file=/etc/mysql/config.ini
#below section is for storage node.
[mysql_cluster]
ndb-connectstring=10.80.1.15

5.2 /etc/mysql/config.ini
###################[config.ini for management node]####################
[ndbd default]
NoOfReplicas=2
DataMemory=200M
IndexMemory=200M
DataDir=/export/mysql/mysql-cluster
[ndb_mgmd default]
DataDir=/export/mysql/mysql-cluster
[ndb_mgmd]
Id=1
HostName=10.80.1.15
[ndbd]
Id=2
HostName=10.80.1.15
[ndbd]
Id=3
HostName=10.80.1.16
[mysqld]
HostName=10.80.1.15
[mysqld]

论坛徽章:
0
4 [报告]
发表于 2010-02-25 09:35 |只看该作者
6. 启动cluster:
6.1 启动管理节点:
sunws05:/etc/mysql# ndb_mgmd -f /etc/mysql/config.ini
2010-02-12 13:15:42 [MgmtSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.39 ndb-7.0.9b
2010-02-12 13:15:43 [MgmtSrvr] INFO -- Reading cluster configuration from '/etc/mysql/config.ini'
2010-02-12 13:15:43 [MgmtSrvr] WARNING -- at line 20: Cluster configuration warning:
arbitrator with id 1 and db node with id 2 on same host 10.80.1.15
Running arbitrator on the same host as a database node may cause complete cluster shutdown in case of host failure.
2010-02-12 13:15:44 [MgmtSrvr] INFO -- Reading cluster configuration from '/etc/mysql/config.ini'
2010-02-12 13:15:44 [MgmtSrvr] WARNING -- at line 20: Cluster configuration warning:
arbitrator with id 1 and db node with id 2 on same host 10.80.1.15
Running arbitrator on the same host as a database node may cause complete cluster shutdown in case of host failure.
sunws05:/etc/mysql#

6.1.1 查看cluster file/dir info:
a)
sunws05:/etc/mysql# cd /export/mysql/mysql-cluster
sunws05:/export/mysql/mysql-cluster# ls
ndb_1.pid ndb_1_cluster.log ndb_1_out.log
b)
sunws05:/export/mysql/mysql-cluster# cd /opt/mysql/mysql/mysql-cluster
sunws05:/opt/mysql/mysql/mysql-cluster# ls
ndb_1_config.bin.1

6.1.2 查看cluster process info:
a)
sunws05:/opt/mysql/mysql/mysql-cluster# ps -ef | grep mysql
root 12694 22979 0 13:23:18 pts/3 0:00 grep mysql
root 12163 1 0 13:15:44 ? 0:04 ndb_mgmd -f /etc/mysql/config.ini

b)
sunws05:/opt/mysql/mysql/mysql-cluster# ps -ef | grep ndb
root 9622 1 0 17:47:15 ? 0:00 ndbd
root 12696 22979 0 13:23:24 pts/3 0:00 grep ndb
root 9623 9622 1 17:47:15 ? 20:33 ndbd
root 12163 1 0 13:15:44 ? 0:04 ndb_mgmd -f /etc/mysql/config.ini

6.1.3 cluster info:

sunws05:/opt/mysql/mysql/mysql-cluster# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.80.1.15:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 10.80.1.16)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.80.1.15)
id=5 (not connected, accepting connect from any host)

ndb_mgm>



6.2 启动data node:
sunws05:/# ndbd
2010-02-12 13:51:52 [ndbd] INFO -- Configuration fetched from '10.80.1.15:1186', generation: 1

6.2.1 show data node info:
sunws05:/# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.80.1.15:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 10.80.1.16)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.80.1.15)
id=5 (not connected, accepting connect from any host)

ndb_mgm>




6.3 启动SQL node:
sunws05:/# mysqld_safe &

6.3.1 show error file:
sunws05:/var/lib/mysql/mysql# vi /var/lib/mysql/sunws05.err
"/var/lib/mysql/sunws05.err" 25 lines, 1682 characters
100212 13:53:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100212 13:53:43 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100212 13:53:43 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100212 13:53:44 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100212 13:53:44 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100212 13:53:45 InnoDB: Started; log sequence number 0 0
100212 13:53:45 [Note] NDB: NodeID is 4, management server '10.80.1.15:1186'
100212 13:53:46 [Note] NDB[0]: NodeID: 4, no storage nodes connected (timed out)
100212 13:53:46 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
100212 13:53:46 [Note] Starting Cluster Binlog Thread
100212 13:53:46 [Note] Event Scheduler: Loaded 0 events
100212 13:54:01 [Warning] NDB : Tables not available after 15 seconds. Consider increasing --ndb-wait-setup value
100212 13:54:01 [Note] /opt/mysql/mysql/bin/mysqld: ready for connections.
Version: '5.1.39-ndb-7.0.9-cluster-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Cluster Server (GPL)

~~~~~~~~we can see that mysqld is stared!!! but it does NOT work, i'll show you later.
我们可以看到,mysqld启动了,但是没有加入cluster中。


6.3.2 show cluster info:
sunws05:/# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.80.1.15:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 10.80.1.16)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.80.1.15)
id=5 (not connected, accepting connect from any host)

ndb_mgm>



我们可以看到,mysqld启动了,但是没有加入cluster中。

论坛徽章:
0
5 [报告]
发表于 2010-02-25 09:37 |只看该作者
本帖最后由 lovechina 于 2010-02-25 09:38 编辑

过来会儿,我再看日志:


6.3.3 Now, let's see the error file[/var/lib/mysql/sunws05.err] again, i find that below contents are added:
100212 14:00:12 [Warning] NDB: Could not acquire global schema lock (4009)Cluster Failure
100212 14:03:15 [Warning] NDB: Could not acquire global schema lock (4009)Cluster Failure
100212 14:03:53 [Warning] NDB: Could not acquire global schema lock (4009)Cluster Failure

6.3.4 create DB:
mysql> CREATE TABLE Persons(
-> Id_P int,
-> LastName varchar(255),
-> FirstName varchar(255),
-> Address varchar(255),
-> City varchar(255)
-> )ENGINE=NDBCLUSTER;
ERROR 1005 (HY000): Can't create table 'genview.Persons' (errno: 157)







请大家帮帮忙,我随时在线。
www.mysql.com里面,根本没有人理会我的问题。也不给出为什么不理会。
只有请教国内高手了!

难道非要3台PC吗?





*****************************************************************
*****************************************************************
*****************************************************************




下面描述,两台PC,一台只做DATA node;
另外一台作为management node和SQL node

论坛徽章:
0
6 [报告]
发表于 2010-02-25 09:46 |只看该作者
下面描述,两台PC,一台只做DATA node;
另外一台作为management node和SQL node


前提:所有mysql进程杀死,所有mysql相关信息清理掉,然后按照PART.I重新安装该软件。


Part II-->1: 配置

为了清除上面的锁的告警 [Could not acquire global schema lock (4009)Cluster Failure], 我用了两台server:

10.80.1.15 ; DATA node,
10.80.1.117; MANAGEMENT node and SQL node.


------------------------------------
#/etc/mysql/config.ini @ 10.80.1.117
[ndbd default]
NoOfReplicas=2
DataMemory=400M
IndexMemory=400M
DataDir=/export/mysql/mysql-cluster
[ndb_mgmd default]
DataDir=/export/mysql/mysql-cluster
[ndb_mgmd]
Id=1
HostName=10.80.1.117
[ndbd]
Id=2
HostName=10.80.1.15
[ndbd]
Id=3
HostName=10.80.1.16 #reserved
[mysqld]
Id=4
HostName=10.80.1.117
[mysqld]
Id=5
HostName=10.80.1.15


------------------------------------
#/etc/mysql/my.cnf @ 10.80.1.117
[mysqld]
#ndb-nodeid=4
#server-id=4
user=mysql
ndbcluster
ndb-connectstring=10.80.1.117
datadir=/var/lib/mysql
[mysql_cluster]
ndb-connectstring=10.80.1.117



------------------------------------
#/etc/mysql/my.cnf @ 10.80.1.15
[mysqld]
user=mysql
ndbcluster
ndb-connectstring=10.80.1.117
datadir=/var/lib/mysql
[mysql_cluster]
ndb-connectstring=10.80.1.117




Part II-->2: 启动所有nodes

a)启动 ndb_mgmd@10.80.1.117:

bash-3.00# ndb_mgmd -f /etc/mysql/config.ini
2010-02-20 16:13:53 [MgmtSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.39 ndb-7.0.9b
2010-02-20 16:13:55 [MgmtSrvr] INFO -- Reading cluster configuration from '/etc/mysql/config.ini'
bash-3.00#


b)启动 ndbd@10.80.1.15:
sunws05:/export/mysql# ndbd
2010-02-20 15:54:47 [ndbd] INFO -- Configuration fetched from '10.80.1.117:1186', generation: 1


c)start mysqld@10.80.1.117:



Part II-->3:查看节点信息@10.80.1.117:


bash-3.00# ndb_mgm
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 10.80.1.16)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.80.1.117 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.80.1.117)
id=5 (not connected, accepting connect from 10.80.1.15)

ndb_mgm>






Part II-->4: show log info@10.80.1.117:


bash-3.00# vi /var/lib/mysql/sunsvr12.err

下面的日志是server-id被注解掉时的日志:

"/var/lib/mysql/sunsvr12.err" 43 lines, 2936 characters
100220 16:18:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100220 16:18:20 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100220 16:18:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100220 16:18:21 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100220 16:18:24 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100220 16:18:30 InnoDB: Started; log sequence number 0 0
100220 16:18:30 [Note] NDB: NodeID is 4, management server '10.80.1.117:1186'
100220 16:18:31 [Note] NDB[0]: NodeID: 4, no storage nodes connected (timed out)
100220 16:18:31 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
100220 16:18:31 [Note] Starting Cluster Binlog Thread
100220 16:18:31 [Note] Event Scheduler: Loaded 0 events
100220 16:18:49 [Warning] NDB : Tables not available after 15 seconds. Consider increasing --ndb-wait-setup value
100220 16:18:49 [Note] /opt/mysql/mysql/bin/mysqld: ready for connections.
Version: '5.1.39-ndb-7.0.9-cluster-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Cluster Server (GPL)


下面的日志是server-id被设置为4时的日志:


100220 16:26:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100220 16:26:58 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100220 16:26:58 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100220 16:26:59 InnoDB: Started; log sequence number 0 44233
100220 16:26:59 [Note] NDB: NodeID is 4, management server '10.80.1.117:1186'
100220 16:27:00 [Note] NDB[0]: NodeID: 4, no storage nodes connected (timed out)
100220 16:27:00 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id
100220 16:27:00 [Note] Starting Cluster Binlog Thread
100220 16:27:00 [Note] Event Scheduler: Loaded 0 events
100220 16:27:17 [Warning] NDB : Tables not available after 15 seconds. Consider increasing --ndb-wait-setup value
100220 16:27:17 [Note] /opt/mysql/mysql/bin/mysqld: ready for connections.
Version: '5.1.39-ndb-7.0.9-cluster-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Cluster Server (GPL)





大家可以看到,SQL NODE启动了,但是就是无法加入到cluster中。
这两种做法,我在Redhat enterprise linux 5.3中测试过,没有任何问题。
server-id在RHEL5.3中,根本不用考虑。


sun怎么搞的,mysql现在在solaris10里面安装怎么这么烂!!!而且没有任何相关文档!难道真的破罐子破摔了???

或者说,oralce本来就想把mysql掐死???

论坛徽章:
0
7 [报告]
发表于 2010-02-25 09:47 |只看该作者
求求大家了!!!我搞了2个星期了!!!老板要打屁股了!!!
求求大家了!!!我搞了2个星期了!!!老板要打屁股了!!!
求求大家了!!!我搞了2个星期了!!!老板要打屁股了!!!

论坛徽章:
0
8 [报告]
发表于 2010-02-25 10:52 |只看该作者
本帖最后由 raid_fifa 于 2010-02-25 10:56 编辑

按照你贴出来的信息,另外一个ndbd还没有启动起来,ndb引擎也没enable呢;show engines看一下。

mysql cluster的初始化启动要把所有的ndbd节点都启动才行;所有节点的心跳通讯都是靠ndbd完成的。

BTW,我在solaris10上没装过7.0.9的版本,但是装过6.3.x的

论坛徽章:
0
9 [报告]
发表于 2010-02-25 11:24 |只看该作者
兄弟,你的回复太及时了!我马上去测试!!!


按照你贴出来的信息,另外一个ndbd还没有启动起来,ndb引擎也没enable呢;show engines看一下。
~~~~~~~~~~是的,另外一个故意不起来的,RHEL5.3下面,别的NDB可以不启动的。只要一个启动就可以了。这也许是一个问题,我试试只一个NDB看看。

show engines可以看到NDB CLUSTER的!!!


mysql cluster的初始化启动要把所有的ndbd节点都启动才行;所有节点的心跳通讯都是靠ndbd完成的。
~~~~~~~~~~~~~~~~~~~~~~真的?如果cluster起来以后,一个NDB死了,按照这说法,整个cluster岂不死了?现在的问题是,管理节点,数据节点,SQL节点都能起来,【那个没有起来的IP是备用的IP,目前是没有对应的真实PC的】,但是ndb>show,看到SQL节点没有连接到管理节点。

这种做法在RHEL5.3是没有问题的。


BTW,我在solaris10上没装过7.0.9的版本,但是装过6.3.x的
~~~~~~~~~~~~~~有没有测试两台机器的情况?目前的PC太少。有的话,请把你的config帖出来看看,万分感激!!!


还是这里好呀!

论坛徽章:
0
10 [报告]
发表于 2010-02-25 11:26 |只看该作者
帖子看了,没在solaris下部署过
同楼上的理由


  /usr/local/mysql/bin/perror ndb 157                                            
    OS error code   0:  Success
    MySQL error code 157: Could not connect to storage engine

   你帖子中有

  [ndbd(NDB)] 2 node(s)
id=2 @10.80.1.15 (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 10.80.1.16)

看看NDBD有没有起来
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP