Mysql-cluster7.5
Data nodes:
shell> rpm -Uhv mysql-cluster-community-data-node-7.5.5-1.1.el7.x86_64.rpm
SQL nodes:
shell> rpm -Uhv mysql-cluster-community-server-7.5.5-1.1.el7.x86_64.rpm
shell> rpm -Uhv mysql-cluster-community-client-7.5.5-1.1.el7.x86_64.rpm
Management nodes:
shell> rpm -Uhv mysql-cluster-commercial-management-server-7.5.5-1.1.el7.x86_64.rpm
Configuring the data nodes and SQL nodes:
shell> vi /etc/my.cnf
[mysqld]
ndbcluster # run NDB storage engine
[mysql_cluster]
ndb-connectstring=192.168.0.10 # location of management server
Configuring the management node:
shell> mkdir /var/lib/mysql-cluster
shell> cd /var/lib/mysql-cluster
shell> vi config.ini
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
[tcp default]
# TCP/IP options:
portnumber=2202 # This the default; however, you can use any
[ndb_mgmd]
hostname=192.168.0.10 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files
[ndbd]
hostname=192.168.0.30 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
[ndbd]
hostname=192.168.0.40 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
[mysqld]
hostname=192.168.0.20 # Hostname or IP address
Cluster management nodes is 1186; the default port for data nodes is 2202.
On the management host:
shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
On each of the data node hosts:
shell> ndbd
On each of the SQL node hosts:
shell> mysqld_safe &
shell> mysqld_safe --user=mysql &
Safe Shutdown and Restart of MySQL Cluster
shell> ndb_mgm -e shutdown
最新文章
- hql中in关键字的用法
- 大熊君大话NodeJS之------Connect中间件模块(第一季)
- sqoop job命令自动生成
- 8659 Mine Sweeping
- {Reship}{Matting}Image Matting
- Start:at cnblogs firstDay
- <;<;SAP内存计算——HANA>;>; 书评
- JAVA语言学校的危险性
- C#项目开发实践前言
- Linux 系统假死的解决方案
- Confluence 6 计划任务
- docker+gitlab的安装和迁移
- Android NDK编译之undefined reference to &#39;JNI_CreateJavaVM&#39;
- 《DSP using MATLAB》Problem 5.21
- python+redis简单实现发红包程序
- Eclipse启动项目正常,放到tomcat下单独启动就报错的 一例
- 使用 IntraWeb (3) - 页面切换
- 什么是REST,RESTful?
- Java读取properties配置文件时,中文乱码解决方法
- CentOS使用EPEL YUM源