Closter

MySQL Cluster Quick Start Guide –– Windows
This guide is intended to help the reader get a simple MySQL Cluster database up and running on a single Windows server. Note that for a live deploymentmultiple hosts should be used to provide redundancy but a single host can be used to gain familiarity with MySQL Cluster; please refer to the final section for links to material that will help turn thisinto a production system. Note that there is an alternate approach to creating your first MySQL Cluster – MySQL Cluster Manager is a commercial tool that is available for a 30 day free trial and itallows you to deploy MySQL Cluster with a single command: http://www.clusterdb.com/mysqlcluster/mysql-cluster-manager-1-1-2-creating-a-cluster-is-now-trivial/

1 Get the software
For GenerallyAvailable (GA), supported versions of the software, download from http://www.mysql.com/downloads/cluster/ Make sure that you select the correct platform – in this case, “Microsoft Windows” and then thecorrect architecture (for Windows this means x86 32 or 64 bit). If you want to try out a pre-GA version then check http://dev.mysql.com/downloads/cluster/ For commercial versions of the MySQL Clusterdownload from https://edelivery.oracle.com/ Note: Only use MySQL Server executables (mysqlds) that come with the MySQL Cluster installation.

2 Install
Locate the zip file ball that you’ve downloaded,and extract the contents (in this case to c:\Users\user1\mysqlc) Optionally, you could add c:\Users\user1\mysqlc\bin to your path to avoid needing the full path when running the processes.

3Configure
For a first Cluster, start with a single MySQL Server (mysqld), a pair of Data Nodes (ndbd) and a single management node (ndb_mgmd) – all running on the same server. Create folders to store theconfiguration files and the data files:
C:\Users\user1> mkdir my_cluster my_cluster\ndb_data my_cluster\mysqld_data my_cluster\conf my_cluster\mysqld_data\mysql my_cluster\mysqld_data\ndbinfo...