Install the mysql-cluster7.3.2 (Single Point server) under ubuntu in a virtual machine environment)

Virtual Machine environment install ubuntu under the mysql-cluster7.3.2 (Single Point server) Deployment environment: System: ubuntu-12.04.2 LTS-server-i386.iso Cluster: mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gz Description: 1, it is best not to install Mysql (here cluster is a binary Version) 2. chkconfig needs to be installed separately and libaio1 must be installed separately to solve libaio. so.1 the problem cannot be found. When installing mysql, you need to install this component. This time, you are only preparing for single point connection. Because the problem of multiple points has not been solved in the previous two days, you are constantly discovering the problem. However, this article does not solve all problems, so this is the version of all solutions. Mgm node: 192.168.131.11 Data node: 192.168.131.12 SQL node: 192.168.131.13 (1) install the management Node

1. decompress the file sudo tar-zvxf mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gzsudo mv mysql-cluster-gpl-7.3.2-linux-glibc23-i686 mysqlc2, create the installation directory sudo mkdir-p/home/lwprain/ndbdatasudo cd mysqlcsudo cp bin/ndb_mgmd/usr/local/binsudo cp bin /ndb_mgm/usr/local/bin3, configure the log file storage directory sudo mkdir/var/lib/mysql-cluster4, create the configuration file directory and file sudo touch config. inisudo nano config. ini

 

 

========================= Configuration file content ========================== [ndbd default] NoOfReplicas = 1 # Number of copied members DataMemory = 80 M # Memory allocated for data storage IndexMemory = 18 M # Memory allocated for index storage [ndb_mgmd] # define Management Nodes IP address or host name nodeid = 1 HostName = 192.168.131.11DataDir =/var/lib/mysql-cluster [ndbd] # define data node nodeid = 11 HostName = 192.168.131.12DataDir =/home/lwprain/ndbdata [ndbd] [mysqld] # define the SQL node nodeid = 21 HostName = 192.168.131.13 ==================== ======================================

 

(2) install data nodes

Unzip file sudo tar-zvxf mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gzsudo mv mysql-cluster-gpl-7.3.2-linux-glibc23-i686 mysqlc create installation directory mkdir-p/home/lwprain/ndbdata copy execution file cp mysqlc/bin/ndbd/usr/local/bin create configuration file: sudo nano/etc/my. cnf: [mysql_cluster] # configure the data node connection management node ndb-connectstring = 192.168.131.11

 

(3) Install SQL nodes

Unzip the file tar-zvxf mysql-cluster-gpl-7.0.37-linux-glibc23-i686.tar.gzsudo mv mysql-cluster-gpl-7.0.37-linux-glibc23-i686 mysqlc add mysql user groupadd mysqluseradd-g mysql add permission chown-R mysql: mysql/home/lwprain/mysqlc copy configuration file cp/home/lwprain/mysqlc/support-files/my-default.cnf/etc/my. cnf initializes the database cd/home/lwprain/mysqlcscripts/mysql_install_db -- user = cp/home/lwprain/mysqlc/support-files/mysql to copy the files required by the daemon. server/etc/init. d/mysqld to configure the daemon. First install chkconfigsudo apt-get install chkconfigchkconfig-add mysqldchkconfig-level 35 mysqld on to change the configuration file vi/etc/my. cnf

 

Edit the following information:

[Mysqld] # configure the connection port between the SQL node and the management node = 3306 socket =/tmp/mysql. sockndbclusterndb-connectstring = 192.168.131.11

 

(4) start and stop a Cluster in sequence: manage nodes ---> data nodes ---> SQL nodes

1. Start the management node cd/usr/local/bin/ndb_mgmd-f/home/lwprain/config. inindb_mgm (view node connection information) 2. Start the data node/usr/local/bin/ndbd -- initial (this command is used for the first startup) /usr/local/bin/ndbd (Use this command later) 3. Start the SQL node/home/lwprain/mysqlc/bin/mysqld_safe -- user = mysql &