Install and configure mysql cluster 7.3.2 in windows xp Virtual Machine

Install and configure mysql cluster 7.3.2 in windows xp Virtual Machine 1. 1 192.168.131.21 (Management node, storage node, SQL node) 2 192.168.131.22 (storage node, SQL node) installed in virtual machine environment) 2. Install the program on both machines at the same time. Step 1: download and install the software: http://dev.mysql.com/downloads/cluster/ My version is MySQL Cluster 5.6.11 (mysql cluster 7.3.2 after MSI is installed, mysql cluster 5.6.11) Step 2: Install the MSI software. mysql instance will not be created during installation. I installed it in c: \ mysql cluster 7.3 Step 3: CD to the binfolder of your installation directory, execute mysqld.exe -- install mysql/* after setting the environment variables still need to execute this command, otherwise it will be installed in c:/program files/mysql/mysql-5.6.10, this operation fails.) Step 4: Set the environment variable. 3. Create a configuration file. Step 1: Create a config. the INI file is in c: \ cluster \ config. INI File Content: [ndbd default] NoOfReplicas = 2 # Managment Server [NDB_MGMD] hostname = 192.168.131.21Nodeid = 1 datadir = C: \ MySQL Cluster 7.3 \ data # data node [NDBD] NodeId = 5 hostname = 192.168.131.21datadir = d:/data [NDBD] NodeId = 6 hostname = 192.168.131.22datadir = d: /data # SQL node [MYSQLD] ArbitrationRank = 2 hostname = 192.168.131.21NodeId = 7 [MYSQLD] ArbitrationRank = 2 hostname = 192.168.131.22NodeId = 8 [MYSQLD] [MYSQLD] Step 2: create the mysql configuration file my. find my-** in the installation path of ini -**. copy the INI file to the current directory and rename it to my. ini is added to the start of [mysqld] in the file # Path to installation directory. all paths are usually resolved relative to this. basedir = "C: \ MySQL Cluster 7.3" datadir = "C: \ MySQL Cluster 7.3 \ data" add ndbcluster ndb-connectstring = 192.168.131.21 in my. add [mysql_cluster] ndb-connectstring = 192.168.131.21 # The two VMS have the same settings to save the file. 4. Start mysql cluster (the following operations are performed in CMD). 1: on the Management node server (192.168.131.211_ndb_mgmd.exe -- config-file = c: \ cluster \ config-ini -- configdir = c: \ clusternew startup window ndbd.exe -- initial/* Add the -- initial parameter to the first startup node */new startup window mysqld.exe -- default-file = "C: \ MySQL Cluster 7.3 \ my. ini "start mysqlnet start mysql after execution Second: Execute ndbd.exein 192.168.131.22in the new window mysqld.exe -- default-file =" C: \ MySQL Cluster 7.3 \ my. ini "start mysqlnet start running ndb_mgm> showConnected to Management Server at: 192.168.2.57: 1186 Cluster Configuration ------- [ndbd (NDB)] 2 node (s) after execution) id = 5 @ 192.168.131.21 (mysql-5.6.10 ndb-7.3.2, Nodegroup: 0, Master) id = 6 @ 192.168.2.56 (mysql-5.6.10 ndb-7.3.2, Nodegroup: 0) [ndb_mgmd (MGM)] 1 node (s) id = 1 @ 192.168.131.21 (mysql-5.6.10 ndb-7.3.2) [mysqld (API)] 2 node (s) id = 7 @ 192.168.131.21 (mysql-5.6.10 ndb-7.3.2) id = 8 @ 192.168.131.22 (mysql-5.6.10ndb-7.3.2) if the preceding information is displayed, the installation is successful, and then you can log on to mysql-uroot show engines on a server. You can check whether ndbcluster has been installed successfully to create a database and create database test; create table tt (id int (10) engine = ndbcluster; insert into tt (1); then go to another server to check whether the database is synchronized