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
2981
July 06, 2005 08:25AM
1974
July 06, 2005 10:33AM
Re: Cannot restart node after server crash (possible bug)
2108
July 06, 2005 10:49AM
2010
July 06, 2005 10:52AM
2062
July 06, 2005 11:00AM
1960
July 06, 2005 10:59AM
1962
July 06, 2005 11:05AM
1786
July 06, 2005 11:09AM
1930
July 06, 2005 11:12AM
1984
July 06, 2005 11:32AM
2026
July 06, 2005 11:39AM
2035
July 06, 2005 11:41AM
2254
July 06, 2005 12:46PM
2010
July 06, 2005 12:47PM
2064
July 06, 2005 01:10PM
2042
July 06, 2005 01:18PM
2004
July 06, 2005 01:21PM
2258
July 06, 2005 01:27PM
1647
July 06, 2005 01:26PM
2181
July 06, 2005 01:33PM
1983
July 06, 2005 01:36PM
2104
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.