Setting Up MySQL Cluster in Windows

The MySQL Cluster Quick Start for Windows Guide was used to demo the setup of a cluster on one machine. The only difference here is that I chose to place the extracted directory (i.e mysql-cluster-gpl-noinstall-7.1.19-win32 which I renamed to ‘mysql’) at the root of C:\

Therefore my addition to the PATH environment variable was:

C:\mysql\bin

Summary (refer to screenshot above):

1. Start the MySQL cluster management node.

2 & 3. Start the two data nodes

4. Start the MySQL server. I had an existing installation of MySQL Server so I typed the full path to the executable as well as the configuration file to use.

5. Check the status of the cluster.

Issues:

-When trying to connect remotely, you may receive an error that states, “Can’t get hostname for your address.” Try adding ‘skip-name-resolve’ in the my.ini file.

Important:

A single backslash character (\) cannot be used when specifying directory paths in program options or configuration files used by MySQL Cluster on Windows. Instead, you must either escape each backslash character with a second backslash (\\), or replace the backslash with a forward slash character (/). For example, the following line from the [ndb_mgmd] section of a MySQL Cluster config.ini file does not work:

DataDir=C:\mysql\bin\cluster-logs

Instead, you may use either of the following:

DataDir=C:\\mysql\\bin\\cluster-logs  # Escaped backslashes
DataDir=C:/mysql/bin/cluster-logs     # Forward slashes

For reasons of brevity and legibility, we recommend that you use forward slashes in directory paths used in MySQL Cluster program options and configuration files on Windows.

Advertisements