Skip to content

Instantly share code, notes, and snippets.

@sakama

sakama/install_mysql_cluster.sh

Last active December 15, 2015 21:19
Show Gist options
  • Save sakama/5325238 to your computer and use it in GitHub Desktop.
Save sakama/5325238 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Clusterインストール手順(管理ノード)
Raw
install_mysql_cluster.sh
cd /usr/local/src
rpm -ivh rpm -ivh MySQL-Cluster-server-gpl-7.2.12-1.el6.x86_64.rpm
mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
mkdir mgm data1 data2 sql1 sql2
vi /var/lib/mysql-cluster/config.ini
[NDBD DEFAULT]
NoOfReplicas=2
NoOfFragmentLogFiles=16
###Disk data related
DiskPageBufferMemory=4M
SharedGlobalMemory=0
IndexMemory=100M
DataMemory=1024M
Datadir=/var/lib/mysql-cluster
MaxNoOfAttributes=4000
MaxNoOfConcurrentOperations=1M
[NDB_MGMD]
NodeId=1
Hostname=192.168.1.1
[NDBD]
NodeId=2
Hostname=192.168.1.1
Datadir=/var/lib/mysql-cluster/data1
[NDBD]
NodeId=3
Hostname=192.168.1.2
Datadir=/var/lib/mysql-cluster/data2
[MYSQLD]
NodeId=50
Hostname=192.168.1.1
[MYSQLD]
NodeId=51
Hostname=192.168.1.2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment