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:
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.
-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.
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.inifile 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.