Re: Cannot restart node after server crash (possible bug)
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.
Subject
Views
Written By
Posted
2990
July 06, 2005 08:25AM
1976
July 06, 2005 10:33AM
Re: Cannot restart node after server crash (possible bug)
2112
July 06, 2005 10:49AM
2013
July 06, 2005 10:52AM
2066
July 06, 2005 11:00AM
1967
July 06, 2005 10:59AM
1964
July 06, 2005 11:05AM
1787
July 06, 2005 11:09AM
1933
July 06, 2005 11:12AM
1987
July 06, 2005 11:32AM
2030
July 06, 2005 11:39AM
2039
July 06, 2005 11:41AM
2259
July 06, 2005 12:46PM
2013
July 06, 2005 12:47PM
2067
July 06, 2005 01:10PM
2044
July 06, 2005 01:18PM
2007
July 06, 2005 01:21PM
2261
July 06, 2005 01:27PM
1650
July 06, 2005 01:26PM
2186
July 06, 2005 01:33PM
1986
July 06, 2005 01:36PM
2106
July 06, 2005 01:41PM
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.