Experience with MySQL (vi) cluster

Official website

http://dev.mysql.com/downloads/cluster/

Mysql-cluster is actually the alias of the mysql7.0 version. But according to personal experience, in actual production, few people use. So write an article here as an introduction to understanding and learning.

cluster installation, first install Java and cmake

Datadir=/data0/search/mysql-cluster

"Install Management node"

cmake-dcmake_install_prefix=/application/search/mysql-cluster/mysql-cluster-gpl-7.2.8

Make-j16

Make Install-j16

Copy the configuration file and modify the appropriate configuration

mkdir etc

CP Support-files/config.huge.ini etc/

Start

./NDB_MGMD--config-file=/application/search/mysql-cluster/mysql-cluster-gpl-7.2.8/etc/config.ini

Modify Configuration Restart--reload

./NDB_MGMD--config-file=/application/search/mysql-cluster/mysql-cluster-gpl-7.2.8/etc/config.ini--reload

Login Admin Client

./NDB_MGM

Stop it

./ndb_mgm-e shutdown

Reboot other nodes <id> Restart-f;

View Table Partitioning