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
3262
July 06, 2005 08:25AM
2100
July 06, 2005 10:33AM
Re: Cannot restart node after server crash (possible bug)
2240
July 06, 2005 10:49AM
2173
July 06, 2005 10:52AM
2184
July 06, 2005 11:00AM
2072
July 06, 2005 10:59AM
2087
July 06, 2005 11:05AM
1900
July 06, 2005 11:09AM
2047
July 06, 2005 11:12AM
2111
July 06, 2005 11:32AM
2147
July 06, 2005 11:39AM
2180
July 06, 2005 11:41AM
2377
July 06, 2005 12:46PM
2117
July 06, 2005 12:47PM
2176
July 06, 2005 01:10PM
2153
July 06, 2005 01:18PM
2113
July 06, 2005 01:21PM
2399
July 06, 2005 01:27PM
1764
July 06, 2005 01:26PM
2330
July 06, 2005 01:33PM
2093
July 06, 2005 01:36PM
2225
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.