---恢复内容开始---
1,卸载ubuntu下安装的mysql server 和 mysql client
sudo apt-get autoremove mysql-server mysql client
2 ,下载mysql-cluster文件
http://www.mysql.com/downloads/cluster/
3,将下载的文件移动到主目录
解压: tar xvf mysql-cluster-gpl-7.2.12-linux2.6-i686.tar.gz
解压后文件改名: mv mysql-cluster-gpl-7.2.12-linux2.6-i686 mysql-cluster
4,创建配置文件和数据文件目录
mkdir my-cluster my-cluster/conf my-cluster/ndb-data my-cluster/mysqld-data my-cluster/mgmd-data
5,创建配置文件config.ini和my.cnf(在mysql-cluster/support-files有这两个文件的模版)
cd $HOME/my-cluster/conf
gedit config.ini --创建文件config.ini及编辑
内容:
[NDBD DEFAULT]
NoOfReplicas = 1
DataDir = /home/lunatic/my-cluster/ndbd-data
DataMemory = 600M
IndexMemory = 100M
BackupMemory = 64M
[MGM DEFAULT]
PortNumber = 1186
datadir = /home/lunatic/my-cluster/mgmd-data
[NDB_MGMD]
nodeid = 1
hostname = 192.168.0.230
[NDBD]
nodeid = 11
hostname = 192.168.0.230
[MYSQLD]
nodeid = 21
hostname = 192.168.0.230
[MYSQLD]
nodeid = 22
gedit my.cnf --创建文件my.cnf及编辑
[client]
password = root
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 5000
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
log-bin=mysql-bin
server-id = 1
ndbcluster
datadir = /home/lunatic/my-cluster/mysqld-data
basedir = /home/lunatic/mysql-cluster
ndb-connectstring = 192.168.0.230
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysql_cluster]
ndb-connectstring=192.168.0.230
6,安装mysql (可能会失败,原因少个包 执行命令 sudo apt-get install libaio-dev,安装完毕后,再次操作,OK)
cd $HOME/mysql-cluster
scripts/mysql_install_db --no-defaults --datadir=$HOME/my-cluster/mysqld-data/
7,按顺序启动各个节点
a. 进入配置目录 cd ../my-cluster/
b. 启动管理节点(在管理节点的主机上)
$HOME/mysql-cluster/bin/ndb_mgmd -f conf/config.ini --initial --configdir=$HOME/my-cluster/conf/ (--reload:若修改了config.ini)
c. 启动数据节点(在数据节点的主机上)
$HOME/mysql-cluster/bin/ndbd -c 192.168.0.230:1186
d. 启动数据库节点(在数据库节点的主机上)
$HOME/mysql-cluster/bin/mysqld --defaults-file=conf/my.cnf --console
e. 显示状态(在管理节点的主机上) $HOME/mysql-cluster/bin/ndb_mgm -e show
8,测试
a. 连接数据库 $HOME/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root
b. 创建lunatic
mysql> create database clusterdb;
mysql> use clusterdb;
c. 创建表,插入数据,查询
mysql> create table cluster(id int not null primary key,num int) engine=ndb;
mysql> insert into simples values (1),(2),(3),(4);
mysql> select * from simples;
(修改数据库表引擎:mysql> ALTER TABLE cluster ENGINE = ndb)
9,外部连接SQL服务器:
只需进入数据库,执行授权命令 GRANT all privileges ON *.* to root@'%' IDENTIFIED BY '访问密码'; OK!
这样我在我的PC主机的windows环境下,访问sql节点,操作数据库了。哈哈!