Install and configure mysql cluster 7.3.2 in windows xp Virtual Machine

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.