Ubuntu virtual machine deployment of multi-point mysql-cluster7.3.2 server Ubuntu
BitsCN.com
Deploy multi-point mysql-cluster7.3.2 server in ubuntu under virtual machine
Deployment environment:
System: ubuntu-12.04.2 LTS-server-i386.iso
Cluster: mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gz
Note:
1. it is best not to install Mysql-server (the cluster here is a binary version)
2. chkconfig needs to be installed separately and libaio1 must be installed separately to solve the problem that libaio. so.1 cannot be found. this component must be installed when mysql is installed.
Today, we finally solved the problem of multiple points. this is a verified version.
Mgm node: 192.168.131.11
SQL Data node: 192.168.131.12
SQL Data node: 192.168.131.13
(1) install management nodes
1. decompress the file
Sudo tar-zvxf mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gz
Sudo music mysql-cluster-gpl-7.3.2-linux-glibc23-i686 mysqlc
2. create an installation directory
Sudo mkdir-p/home/lwprain/ndbdata
Sudo cd mysqlc
Sudo cp bin/ndb_mgmd/usr/local/bin
Sudo cp bin/ndb_mgm/usr/local/bin
3. configure the log file storage directory
Sudo mkdir/var/lib/mysql-cluster
4. create a configuration file directory and file
Sudo touch config. ini
Sudo nano config. ini
========================= Configuration file content ==========================
[Ndbd default]
NoOfReplicas = 2 # Number of duplicate members
DataMemory = 80 M # memory available for data storage
IndexMemory = 18 M # memory available for index storage
[Ndb_mgmd] # define the IP address or host name of the management node
Nodeid = 1
HostName = 192.168.131.11
DataDir =/var/lib/mysql-cluster
[Ndbd] # define data nodes
Nodeid = 11
HostName = 192.168.131.12
DataDir =/home/lwprain/ndbdata
[Ndbd] # define data nodes
Nodeid = 12
HostName = 192.168.131.13
DataDir =/home/lwprain/ndbdata
[Ndbd]
[Mysqld] # define an SQL node
Nodeid = 21
HostName = 192.168.131.12
[Ndbd]
[Mysqld] # define an SQL node
Nodeid = 22
HostName = 192.168.131.13
[Mysqld]
[Mysqld]
========================================================== ================
(2) install the SQL Data node
Decompress the file
Sudo tar-zvxf mysql-cluster-gpl-7.3.2-linux-glibc23-i686.tar.gz
Sudo music mysql-cluster-gpl-7.3.2-linux-glibc23-i686 mysqlc
Create installation directory
Mkdir-p/home/lwprain/ndbdata
Copy the execution file
Cp mysqlc/bin/ndbd/usr/local/bin
Add a mysql User
Groupadd mysql
Useradd-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
Initialize database
Cd/home/lwprain/mysqlc
Scripts/mysql_install_db -- user = mysql
Copy the files required by the Daemon
Cp/home/lwprain/mysqlc/support-files/mysql. server/etc/init. d/mysqld
Change configuration file
Sudo nano/etc/my. cnf # Copy from mysqlc to/etc
Edit the following information:
[Mysqld] # configure the connection between an SQL node and a management node
Port = 3306
Socket =/tmp/mysql. sock
Ndbcluster
Ndb-connectstring = 192.168.131.11
[Mysql_cluster] # configure a data node connection management node
Ndb-connectstring = 192.168.131.11
(3) starting and disabling a Cluster
Start in sequence: manage nodes ---> data nodes ---> SQL nodes note: show in ndb_mgm is displayed correctly only after all the nodes are started (this is a key factor that is considered unsuccessful, I 've been on a detour)
1. start the management node
Cd/usr/local/bin/
Ndb_mgmd-f/home/lwprain/config. ini
Ndb_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 &
After setting the path, you can flexibly execute mysql commands.
Log on to your user (non-root) and enter:
$ Sudo nano ~ /. Profile
You can add the PATH at the end of this file as follows:
Export PATH = "PATH:/home/lwprain/mysqlc/bin /"
Save the file, log out, and log on again. The variable takes effect.
The variables added in this method are only valid for the current user.
Then log on to mysql on a server
Mysql-uroot
Show engines;
Check whether ndbcluster is successfully installed.
Create databases and tables
Create database test;
Create table tt (id int (10) engine = ndbcluster;
Insert into tt (1 );
Then go to another server to view
Check whether the database is synchronized
BitsCN.com