Re: Cluster Configuration 2 MGMD nodes
Hi,
Please find the config.ini and my.cnf files used in my configuration below.
Tried with only two machines(1 mgm node+1 data node + 1 SQL node) on each.
This works with problems :-). When one mgmt server goes down(crash, kill processes etc..) the cluster goes for a forced shutdown and the ndbd process on the other machine is killed. Can anyone give a working redundant management server configuration example files with 2 (I guess Smith don't like this :-) or 3 machine configuration.
Any ideas on using the cluster with only 2 machines in the near future cluster versions or can we do something for the existing versions.
config.ini
========
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
Diskless= Y
[COMPUTER]
Id= 1
Hostname= 192.168.57.105
[COMPUTER]
Id= 2
Hostname= 192.168.57.106
# Management process 1
[NDB_MGMD]
Id= 1
ExecuteOnComputer= 1
ArbitrationRank= 1
PortNumber=10001
Datadir=/var/lib/mysql-cluster
# Management process 1
[NDB_MGMD]
Id= 2
ExecuteOnComputer= 2
ArbitrationRank= 2
PortNumber=10002
Datadir=/var/lib/mysql-cluster
# Options for Data node process 1
[NDBD]
Id= 3
ExecuteOnComputer= 1
Datadir=/var/lib/mysql-cluster
# Options for data node process 2
[NDBD]
Id= 4
ExecuteOnComputer= 2
Datadir=/var/lib/mysql-cluster
# SQL node process 1
[MYSQLD]
Id= 5
ExecuteOnComputer= 1
ArbitrationRank= 0
# SQL node process 2
[MYSQLD]
Id= 6
ExecuteOnComputer= 2
ArbitrationRank= 0
Datadir=/var/lib/mysql-cluster
# Options for data node process 2
[NDBD]
Id= 4
ExecuteOnComputer= 2
Datadir=/var/lib/mysql-cluster
# SQL node process 1
[MYSQLD]
Id= 5
ExecuteOnComputer= 1
ArbitrationRank= 0
# SQL node process 2
[MYSQLD]
Id= 6
ExecuteOnComputer= 2
ArbitrationRank= 0
my.cnf
======
# Additions to my.cnf for MySQL Cluster
# Enable ndbcluster storage engine, and provide connectstring for
# management server host
# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring="192.168.57.105:10001,192.168.57.106:10002" # location of MGM nodes
[NDBD]
connect-string="nodeid=3;host=192.168.57.105:10001,host=192.168.57.106:10002"
[NDB_MGM]
connect-string="nodeid=3;host=192.168.57.105:10001,host=192.168.57.106:10002"
# Options for ndbd process:
#[MYSQL_CLUSTER]
#ndb-connectstring="192.168.57.105:10001, 192.168.57.106:10002" # location of MGM nodes
Subject
Views
Written By
Posted
5927
November 30, 2004 11:14PM
2350
December 04, 2004 04:11PM
2234
March 15, 2005 12:05PM
2014
November 11, 2005 06:42AM
2124
November 13, 2005 05:49PM
2207
November 14, 2005 07:23AM
2098
November 14, 2005 05:02PM
2046
November 21, 2005 02:15AM
4515
November 21, 2005 05:29AM
4673
January 13, 2006 06:23PM
2099
January 13, 2006 06:27PM
1971
November 24, 2005 02:35AM
2141
November 24, 2005 03:01AM
2006
November 24, 2005 11:31AM
1958
November 28, 2005 02:37AM
Re: Cluster Configuration 2 MGMD nodes
3646
November 29, 2005 02:39AM
2202
November 29, 2005 02:49AM
2025
November 29, 2005 04:59AM
2562
December 01, 2005 08:30AM
2000
December 01, 2005 06:05PM
2288
February 18, 2006 10:20PM
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.