how to handle cluster..
hi all,
i am setting up mysqlcluster with 3 node(1 mgm node, 2 ndb & api node)
i have a question during testing cluster.
1.after restart cluster,api node always not connect.
but 1 ~ 2 minutes later, api node connect.
why api node connect 1 ~ 2 monutes later after restart cluster?
2.i see table ### is full message.
cluster FAQ present that message is config error(DataMemory & IndexMemory is not enough).
but my backup data size is 6M.
config.ini set DataMemory=140M,IndexMemory=40M.
why this message come out?
3.after mysqldump, i want to import data.
usually, mysql -u user -p database < backup.sql
my backup.sql size is 6M.
but import time is too long.
how to fast import data in database.
my config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=140M
IndexMemory=40M
MaxNoOfAttributes=2000
TransactionDeadlockDetectionTimeout=12000
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
portnumber=2202
[NDB_MGMD]
HostName=192.168.0.1
[NDBD]
HostName=192.168.0.2
DataDir= /home/mysql
[NDBD]
HostName=192.168.0.3
DataDir=/home/ndb
[MYSQLD]
[MYSQLD]
thanks for your help,
sungtae
Subject
Views
Written By
Posted
how to handle cluster..
2961
May 17, 2005 02:52AM
2041
May 17, 2005 07:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.