Mysql-clustering

mysql-clustering

this all was not tested and finally not working directly

while compiling mysqld you have to enable the ndb functionality: --enable-db-clustering

my.ini on the cluster-node

[mysqld]
nbdcluster
#cluster-management-server
ndb-connectstring=kurs001 
[mysql-cluster]
ndb-connectstring=kurs001

on the management-server, we create a folder called mysql-cluster inside that we create a file, called config.ini:

[ndb default]
#number of data-copies
noofreplicas=5
[mysqld default]
[ndb_mdmd default]
[tcp default]
#management-server
[ndb_mgmd]
hostname=192.168.42.101

#list of all storage nodes including their data-directory
[ndbd]
hostname=192.168.42.102
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"
[NDBD]
hostname=192.168.42.103
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"hostname=192.168.42.103
[...]

#mysql-nodes
[mysqld]
hostname=192.168.42.102
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"
hostname=192.168.42.103
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"hostname=192.168.42.103
[...]

later we try to start the management-daemon

ndb_mgmd