首页 > mysql > mysql集群mysql-cluster安装

mysql集群mysql-cluster安装

2010年4月23日 eric 发表评论 阅读评论

这两天看了一下 mysql-cluster 从 5.0.X 的时候做过测试,后来就在也没有看过,后来google时,说有些改善,所以就研究了一下。今天只把配置过程写下来,改天把LVS 和 测试结果发来,不过也拿不出什么测试结果,因为现在手头上没有实体服务器,虚拟机器做并发测试没有什么意义呵呵。

hostname      IP地址       应用服务
DB1         www.nginxs.com     MGM
DB2         192.168.6.160     NDBD,MYSQLD
DB3         192.168.6.188     NDBD2, MYSQLD
DB4         192.168.6.191     MYSQLD

一.DB1 管理节点 MGM

./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=/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugin=innobase --with-plugin-ndbcluster --with-plugin-partition
make
make install
cd /usr/local/mysql
mkdir mysql-cluster
cd mysql-cluster
vim config.ini

[ndbd default]
NoOfReplicas= 2
[MYSQLD DEFAULT]
[ndb_mgmd default]
DataDir= /usr/local/mysql/mysql-cluster
[ndb_mgmd]
HostName= www.nginxs.com
[ndbd]
HostName= 192.168.6.160
DataDir= /usr/local/mysql/mysql-cluster
[ndbd]
HostName= 192.168.6.188
DataDir= /usr/local/mysql/mysql-cluster
[mysqld]
HostName= 192.168.6.160
[mysqld]
HostName= 192.168.6.188
[mysqld]
HostName= 192.168.6.191
/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.6.160)
id=3 (not connected, accepting connect from 192.168.6.188)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @www.nginxs.com (Version: 5.1.45)

[mysqld(API)] 3 node(s)
id=4 (not connected, accepting connect from 192.168.6.160)
id=5 (not connected, accepting connect from 192.168.6.188)
id=6 (not connected, accepting connect from 192.168.6.191)

可以看到ndb_mgmd 是 连上的,nbd 和 mysqld 还没有连上~

二.在两个ndbd 节点 DB1,DB2 安装mysql

./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=/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugin=innobase --with-plugin-ndbcluster --with-plugin-partition

groupadd mysql
useradd -g mysql mysql
cd /usr/local/mysql
chown root.mysql . -R
/usr/local/mysql/bin/mysql_install_db --user=mysql

vim /usr/local/mysql/etc/my.cnf
[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /tmp/mysql.sock
ndbcluster
ndb-connectstring=www.nginxs.com
[mysql_cluster]
ndb-connectstring=www.nginxs.com
/usr/local/mysql/libexec/ndbd --initial ### 第一次启动需要 --initial 以后在启动不需要加

随后启动两台ndbd 节点上的 mysql 服务

/usr/local/mysql/bin/mysqld_safe --user=mysql &

然后在 MGM 服务器上查看

/usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.6.160 (Version: 5.1.45, Nodegroup: 0)
id=3 @192.168.6.188 (Version: 5.1.45, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @www.nginxs.com (Version: 5.1.45)
[mysqld(API)] 3 node(s)
id=4 @192.168.6.160 (Version: 5.1.45)
id=5 @192.168.6.188 (Version: 5.1.45)
id=6 (not connected, accepting connect from 192.168.6.191)

从上面可以看出 两个 ndbd 节点 和 ndbd 上的两个mysql 服务已经连接上了。
三.DB4安装mysql节点

./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=/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugin=innobase --with-plugin-ndbcluster --with-plugin-partition
groupadd mysql
useradd -g mysql mysql
cd /usr/local/mysql
chown root.mysql . -R
/usr/local/mysql/bin/mysql_install_db --user=mysql
vim /usr/local/mysql/etc/my.cnf
[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /tmp/mysql.sock
ndbcluster
ndb-connectstring=www.nginxs.com
[mysql_cluster]
ndb-connectstring=www.nginxs.com

启动 mysql 服务

/usr/local/mysql/bin/mysqld_safe --user=mysql &

回到 MGM 上查看是否正常

DB1 $> /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 @192.168.6.160 (Version: 5.1.45, Nodegroup: 0)
id=3 @192.168.6.188 (Version: 5.1.45, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @www.nginxs.com (Version: 5.1.45)
[mysqld(API)] 3 node(s)
id=4 @192.168.6.160 (Version: 5.1.45)
id=5 @192.168.6.188 (Version: 5.1.45)
id=6 @192.168.6.191 (Version: 5.1.45)

好了,一切正常了,现在回到 mysql 节点上 创建和删除数据看是否同步。
那么就登录 DB2 的 mysql

DB2 $> /usr/local/mysql/bin/mysql -uroot -p
Mysql >show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)
Mysql > create database eric;
Query OK, 1 row affected (0.39 sec)
Mysql >show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| eric |
| mysql |
+--------------------+
3 rows in set (0.01 sec)

好了,在看 DB3 DB4 上是否同步

Db3 $> /usr/local/mysql/bin/mysql -uroot -p
Mysql $> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| eric |
| mysql |
+--------------------+
DB4 $> /usr/local/mysql/bin/mysql -uroot -p
Mysql $> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| eric |
| mysql |
+--------------------+

都看到了 eric 数据库·结束

转载请注明:文章转载自:Eric's linux and nginx! (http://www.nginxs.com)
本文地址:http://www.nginxs.com/linux/137.html

分类: mysql 标签: ,
  1. 2018年9月18日05:46 | #1

    Greetings! Very useful advice in this particular article!
    It’s the little changes which will make the most significant changes.
    Thanks for sharing!

  2. 2018年9月19日23:13 | #2

    I was pretty pleased to uncover this great site.
    I want to to thank you for your time just for this wonderful read!!
    I definitely loved every part of it and I have you bookmarked to see new things in your website.

  3. 2018年9月20日22:49 | #3

    I quite like looking through a post that can make men and women think.
    Also, thanks for permitting me to comment!

  4. 2018年9月21日05:42 | #4

    We’re a group of volunteers and starting a new scheme in our community.
    Your web site provided us with valuable info to work on. You’ve done a formidable job and our entire community will be grateful to you.

  5. 2018年9月21日05:45 | #5

    I constantly spent my half an hour to read this webpage’s posts every day along with a cup of
    coffee.

  6. 2018年9月21日07:31 | #6
  7. 2018年9月21日10:50 | #7

    Correct maintenance is vital to power-effectivity.

  8. 2018年9月21日11:55 | #8

    Give A+ ESC Air Conditioning Providers a name.

  9. 2018年9月21日17:18 | #9

    Proper upkeep is essential to power-efficiency.

  10. 2018年9月21日20:33 | #10

    Heating and cooling techniques additionally use thermostats.

  11. 2018年9月21日20:33 | #11

    Heating and cooling techniques additionally use thermostats.

  12. 2018年9月21日21:43 | #12

    Give A+ ESC Air Conditioning Services a name.

  13. 2018年9月21日21:51 | #13

    Heating and cooling techniques also use thermostats.

  14. 2018年9月21日22:12 | #14

    Heating and cooling programs additionally use thermostats.

  15. 2018年9月22日03:58 | #15

    Proper upkeep is essential to power-effectivity.

  16. 2018年9月22日10:44 | #16

    Give A+ ESC Air Conditioning Providers a call.

  17. 2018年9月22日15:12 | #17

    Give A+ ESC Air Conditioning Providers a call.

  18. 2018年9月22日16:12 | #18

    Give A+ ESC Air Conditioning Companies a call.

  19. 2018年9月22日17:11 | #19

    Proper maintenance is vital to vitality-effectivity.

  20. 2018年9月22日18:09 | #20

    Give A+ ESC Air Conditioning Services a call.

  21. 2018年9月22日19:58 | #21

    Correct maintenance is vital to power-effectivity.

  22. 2018年9月22日21:42 | #22

    Correct maintenance is vital to energy-effectivity.

  23. 2018年9月22日21:53 | #23

    Heating and cooling programs additionally use thermostats.

  24. 2018年9月22日23:19 | #24

    Correct upkeep is vital to vitality-efficiency.

  25. 2018年9月23日08:43 | #25

    Proper maintenance is key to vitality-effectivity.

  26. 2018年9月23日13:04 | #26

    Heating and cooling techniques additionally use thermostats.

  27. 2018年9月23日13:26 | #27

    Proper maintenance is vital to vitality-effectivity.

  28. 2018年9月23日15:30 | #28

    Correct maintenance is vital to power-effectivity.

  29. 2018年9月23日15:35 | #29

    Correct upkeep is essential to vitality-effectivity.

  30. 2018年9月23日15:44 | #30

    Heating and cooling programs additionally
    use thermostats.

  31. 2018年9月23日18:05 | #31

    Correct upkeep is key to vitality-efficiency.

评论分页
1 ... 3 4 5 137
订阅评论
3+9= (必填)