Mysql-clustering

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

my.ini

[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"
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
[...]