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
2836
July 06, 2005 08:25AM
1926
July 06, 2005 10:33AM
Re: Cannot restart node after server crash (possible bug)
2047
July 06, 2005 10:49AM
1955
July 06, 2005 10:52AM
2010
July 06, 2005 11:00AM
1916
July 06, 2005 10:59AM
1917
July 06, 2005 11:05AM
1729
July 06, 2005 11:09AM
1865
July 06, 2005 11:12AM
1940
July 06, 2005 11:32AM
1968
July 06, 2005 11:39AM
1986
July 06, 2005 11:41AM
2204
July 06, 2005 12:46PM
1962
July 06, 2005 12:47PM
2015
July 06, 2005 01:10PM
1993
July 06, 2005 01:18PM
1957
July 06, 2005 01:21PM
2177
July 06, 2005 01:27PM
1604
July 06, 2005 01:26PM
2099
July 06, 2005 01:33PM
1932
July 06, 2005 01:36PM
2052
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.