mysql 集群配置

管理节点 新建config.ini 在/var/lib/mysqlmgm/中

[ndbd default]  
NoOfReplicas=2  
DataMemory=80M  
IndexMemory=18M  
[ndb_mgmd]  
NodeId=1  
Hostname=192.168.6.134 
datadir=/usr/local/mysql/logs  
[ndbd]  
NodeId=2  
Hostname=192.168.6.135           
datadir=/usr/local/mysql/data/     
[ndbd]  
NodeId=3  
Hostname=192.168.6.136              
datadir=/usr/local/mysql/data/          
[MYSQLD]  
[MYSQLD]
启动管理./ndb_mgmd -f /var/lib/mysqlmgm/config.ini  --initital  第一次启动,和备份数据,恢复数据要用--initital 参数
./ndb_mgm  然后show 查看数据,SQL节点的状态




#################################################################
数据,SQL节点

编辑/etc/my.cnf