MySQL Forums
Forum List  »  NDB clusters

Re: Cannot restart node after server crash (possible bug)
Posted by: Darren Landrum
Date: July 06, 2005 10:49AM

Thank you for the reply.

I have been doing regular database backups, both with the cluster tools and using mysqldump, so I'm comfortbale as far as that goes.

Here is the config file:

-----

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=768MB
IndexMemory=512MB
MaxNoOfAttributes = 10000
MaxNoOfOrderedIndexes = 15000
MaxNoOfUniqueHashIndexes = 15000
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
Id=1
HostName=xxx.xxx.xxx.57 # the IP of THIS SERVER
# Storage Engines
[NDBD]
Id=3
HostName=xxx.xxx.xxx.58 # the IP of the FIRST SERVER
DataDir=/usr/local/mysql/var
[NDBD]
Id=4
HostName=xxx.xxx.xxx.59 # the IP of the SECOND SERVER
DataDir=/usr/local/mysql/var
[NDBD]
Id=5
HostName=xxx.xxx.xxx.60 # the IP of the SECOND SERVER
DataDir=/usr/local/mysql/var
[NDBD]
Id=6
HostName=xxx.xxx.xxx.61 # the IP of the SECOND SERVER
DataDir=/usr/local/mysql/var
#[NDBD]
#Id=7
#HostName=xxx.xxx.xxx.53 # the IP of the SECOND SERVER
#DataDir=/usr/local/mysql/var
#[NDBD]
#Id=8
#HostName=xxx.xxx.xxx.54 # the IP of the SECOND SERVER
#DataDir=/usr/local/mysql/var
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
Id=9
HostName=xxx.xxx.xxx.58 # the IP of the FIRST SERVER
#DataDir=/usr/local/mysql/var
[MYSQLD]
Id=10
HostName=xxx.xxx.xxx.59 # the IP of the SECOND SERVER
#DataDir=/usr/local/mysql/var
[MYSQLD]
Id=11
HostName=xxx.xxx.xxx.60 # the IP of the SECOND SERVER
#DataDir=/usr/local/mysql/var
[MYSQLD]
Id=12
HostName=xxx.xxx.xxx.61 # the IP of the SECOND SERVER
#DataDir=/usr/local/mysql/var
#[MYSQLD]
#Id=13
#HostName=xxx.xxx.xxx.53 # the IP of the SECOND SERVER
##DataDir=/usr/local/mysql/var
#[MYSQLD]
#Id=14
#HostName=xxx.xxx.xxx.54 # the IP of the SECOND SERVER
##DataDir=/usr/local/mysql/var

-----

Thank you all again for the help. I have plenty of MySQL experience, but I've never touched MySQL clustering before. It's leaving me quite befuddled.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot restart node after server crash (possible bug)
2047
July 06, 2005 10:49AM


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.