MySQL Forums
Forum List  »  NDB clusters

fault tolerance of managment server
Posted by: ankush grover
Date: October 14, 2005 03:56AM

hey friends,

I recently configured clustering of mysql 4.1.14. There are 2 Storage Nodes ,2 Mysql nodes and 1 management server.Now I want to add one more management server so that if one management server goes down the other management server can take up the charge.

I don't want a single point of failure.How do I configure fault tolerance/High Availability of management server.

the below is the config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=400M
IndexMemory=160M
MaxNoOfAttributes=20000
MaxNoOfTables=1600
MaxNoOfOrderedIndexes=5000
MaxNoOfUniqueHashIndexes=5000
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Management Server
[NDB_MGMD]
HostName=10.0.0.1
# IP addresses of the management servers
# Storage Nodes
[NDBD]
HostName=10.0.0.2 # IP address of storage-node-1
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=10.0.0.3 # IP address of storage-node-2
DataDir=/var/lib/mysql-cluster
# Setup node IDs for mySQL API-servers (clients of the cluster)
[MYSQLD]
HostName=10.0.0.1
[MYSQLD]
[MYSQLD]
[MYSQLD]
HostName=10.0.0.4

I want to add Host 10.0.0.4 as the second management server.

Thanks & Regards

Ankush Grover

Options: ReplyQuote


Subject
Views
Written By
Posted
fault tolerance of managment server
2068
October 14, 2005 03:56AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.