Trying to setup a cluster with a management node on a Mac OSX box and two
storage/MySQL nodes: 1 on OSX and the other WinServer2003.
Can anyone help? I think I've got the management node setup properly as
it's waiting for the nodes to connect. I can't figure out how to get the
Win node to connect.
Here is my config.ini on the management node (192.168.0.3).
---config.ini---
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=192.168.0.3 # the IP of THIS SERVER
# Storage Engines
[NDBD]
HostName=192.168.0.5 # the IP of the FIRST SERVER
DataDir= "C:/MySQL Datafiles/"
[NDBD]
HostName=192.168.0.4 # the IP of the SECOND SERVER
DataDir=/usr/local/mysql/data
# 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]
[MYSQLD]
---end config.ini---
here's what I added to the end of the default my.ini on the Win box
(192.168.0.5)
---my.ini---
# Added by CTR for Clustering
[mysqld]
ndbcluster
ndb-connectstring=192.168.0.3 # the IP of the MANAGMENT (THIRD) SERVER
[mysql_cluster]
ndb-connectstring=192.168.0.3 # the IP of the MANAGMENT (THIRD) SERVER
---end my.ini---
