首页 / MYSQL / mysqlcluster7.1搭建
mysqlcluster7.1搭建
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysqlcluster7.1搭建，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8988字，纯文字阅读大概需要13分钟。
内容图文
简单步骤，分享下： hostnameIP应用 db1192.168.50.10MGM db2192.168.50.20NDBD db3192.168.50.30NDBD2 db4192.168.50.40MYSQLD db5192.168.50.50MYSQLD ***************************** 1.安装配置管理节点(DB1)MGM ***************************** # groupad
简单步骤，分享下：
hostname IP 应用
db1 192.168.50.10 MGM
db2 192.168.50.20 NDBD
db3 192.168.50.30 NDBD2
db4 192.168.50.40 MYSQLD
db5 192.168.50.50 MYSQLD
*****************************
1.安装配置管理节点(DB1)MGM
*****************************
# groupadd mysql
# useradd -g mysql -d /usr/local/mysql/var -M mysql
# tar zxvf mysql-cluster-gpl-7.1.8.tar.gz
# cd mysql-cluster-gpl-7.1.8
# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max
# make
# make install
# cd /usr/local/mysql
# mkdir mysql-cluster
# cd mysql-cluster
# vi config.ini
[NDBD DEFAULT]
NoOfReplicas= 2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
DataDir= /usr/local/mysql/mysql-cluster
[NDB_MGMD]
HostName= 192.168.50.10
[NDBD]
HostName= 192.168.50.20
DataDir= /usr/local/mysql/mysql-cluster
[NDBD]
HostName= 192.168.50.30
DataDir= /usr/local/mysql/mysql-cluster
[MYSQLD]
HostName= 192.168.50.40
[MYSQLD]
HostName= 192.168.50.50
----------启动cluster管理节点
在管理节点服务器上，执行以下命令启动MGM节点进程：
root# /usr/local/mysql/ndb_mgmd -f /usr/local/mysql/config.ini
必须用参数“-f”或“--config-file”告诉 ndb_mgm 配置文件所在位置，默认是在ndb_mgmd相同目录下。
------------------
# /usr/local/mysql/libexec/ndb_mgmd -f /usr/local/mysql/mysql-cluster/config.ini
# /usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.50.20)
id=3 (not connected, accepting connect from 192.168.50.30)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.50.10 (mysql-5.1.47 ndb-7.1.8)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.50.40)
id=5 (not connected, accepting connect from 192.168.50.50)
可以看到ndb_mgmd 是 连上的，nbd 和 mysqld 还没有连上~
****************************************
2.安装配置在两个数据节点(DB2,DB3)ndbd
****************************************
# groupadd mysql
# useradd -g mysql -d /usr/local/mysql/var -M mysql
# tar xvzf mysql-cluster-gpl-7.1.8.tar.gz
# cd mysql-cluster-gpl-7.1.8
# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max
# make
# make install
# cd /usr/local/mysql
# mkdir mysql-cluster etc
# chown root:mysql . -R
# vi /usr/local/mysql/etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring=192.168.50.10
[mysql_cluster]
ndb-connectstring=192.168.50.10
#./libexec/ndbd --initial ### 第一次启动需要 --initial 以后在启动不需要加
2010-06-21 14:09:38 [ndbd] INFO -- Configuration fetched from '192.168.5.10:1186', generation: 1
--------------------------启动说明
--------------------------启动存储节点
在每台存储节点服务器上，如果是第一次启动ndbd进程的话，必须先执行以下命令：
root# /usr/local/mysql/libexec/ndbd --initial
注意，仅应在首次启动ndbd时，或在备份/恢复数据或配置文件发生变化后重启ndbd时使用“--initial”参数
。因为该参数会使节点删除由早期ndbd实例创建的、用于恢复的任何文件，包括用于恢复的日志文件。
如果不是第一次启动，直接运行如下命令即可：
root# /usr/local/mysql/libexec/ndbd
--------------------------
然后在 MGM 服务器上查看
[root@db1 ~]# /usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.50.20 (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0, Master)
id=3 @192.168.50.30 (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.50.10 (mysql-5.1.47 ndb-7.1.8)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.50.40)
id=5 (not connected, accepting connect from 192.168.50.50)
从上面可以看出 两个 ndbd 节点 和 ndbd 上存储都已经连接上了。
****************************************
3、安装配置SQL节点(DB4、DB5)
****************************************
# groupadd mysql
# useradd -g mysql -d /usr/local/mysql/var -M mysql
# tar xvzf mysql-cluster-gpl-7.1.8.tar.gz
# cd mysql-cluster-gpl-7.1.8
# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max
# make
# make install
# cd /usr/local/mysql
# mkdir mysql-cluster etc
# chown root:mysql . -R
# ./bin/mysql_install_db --user=mysql
# vi ./etc/my.cnf
[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
ndbcluster
ndb-connectstring=192.168.50.10
[mysql_cluster]
ndb-connectstring=192.168.50.10
启动 mysql 服务
# ./bin/mysqld_safe --user=mysql &
--------------启动mysqld服务
最后，运行以下命令启动SQL节点服务器：
root# /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf &
--------------
回到 MGM 上查看是否正常
./bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.50.20 (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0, Master)
id=3 @192.168.50.30 (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.50.10 (mysql-5.1.47 ndb-7.1.8)
[mysqld(API)] 2 node(s)
id=4 @192.168.50.40 (mysql-5.1.47 ndb-7.1.8)
id=5 @192.168.50.50 (mysql-5.1.47 ndb-7.1.8)
好了，一切正常了，现在回到 mysql 节点上 创建和删除数据看是否同步。
****************************************
4.新建数据库测试
****************************************
那么就登录 DB4 的 mysql
DB4 # > /usr/local/mysql/bin/mysql -uroot -p
mysql > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ndbinfo |
| test |
+--------------------+
4 rows in set (0.01 sec)
mysql > create database accp;
Query OK, 1 row affected (0.39 sec)
mysql > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| accp |
| mysql |
| ndbinfo |
| test |
+--------------------+
5 rows in set (0.00 sec)
看 DB5 上是否同步
DB5 # > /usr/local/mysql/bin/mysql -uroot -p
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| accp |
| mysql |
| ndbinfo |
| test |
+--------------------+
5 rows in set (0.00 sec)
DB5 # > /usr/local/mysql/bin/mysql -uroot -p
mysql > show databases;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| accp |
| mysql |
| ndbinfo |
| test |
+--------------------+
5 rows in set (0.00 sec)
都看到了 accp 数据库 安装配置完成。
****************************************
5.新建表测试
****************************************
DB5上新建测试表t1
mysql> use accp;
Database changed
mysql> create table t1
-> (
-> sid int not null primary key,
-> sno int
-> ) engine=ndbcluster;
Query OK, 0 rows affected (0.37 sec)
mysql> insert into t1 values (101,201);
Query OK, 1 row affected (0.01 sec)
mysql> select * from t1;
+-----+------+
| sid | sno |
+-----+------+
| 101 | 201 |
+-----+------+
1 row in set (0.00 sec)
DB4上查看是否同步：
mysql> use accp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_accp |
+----------------+
| t1 |
+----------------+
1 row in set (0.02 sec)
mysql> select * from t1;
+-----+------+
| sid | sno |
+-----+------+
| 101 | 201 |
+-----+------+
1 row in set (0.01 sec)
内容总结
以上是互联网集市为您收集整理的mysqlcluster7.1搭建全部内容，希望文章能够帮你解决mysqlcluster7.1搭建所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。