mysql负载均衡集群架设
来源:互联网 发布:工字钢简支梁计算软件 编辑:程序博客网 时间:2024/05/20 21:18
1 环境描述Mysql manager 节点:192.168.0.1
MysqlServer节点:192.168.0.100
Mysql 节点:192.168.0.160
Mysql 节点:192.168.0.161
说明:至少需要四台服务器才可以做mysql的集群。建议5台,再增加一台MysqlServer。
2 安装mysql二进制包2.1 安装之前的准备工作下载mysql-max-4.1.13-pc-linux-gnu-i686.tar.gz包
(注意:可以做集群的mysql都是mysql-max的,下载地点www.mysql.org)
#groupadd mysql
#useradd -g mysql mysql
#cd /usr/local
#tar xfz mysql-max-4.1.13-pc-linux-gnu-i686.tar.gz
#ln -s /usr/local/mysql-max-4.1.13-pc-linux-gnu-i686 /opt/mysql4.1.13
2.2 分别在manager,server,node节点上安装二进制的mysql包#cd mysql4.1.13
#scripts/mysql_install_db --user=mysql (必须带目录执行,否则出错)
#chown -R root /opt/mysql4.1.13
#chgrp -R mysql /opt/mysql4.1.13
#chown -R mysql.mysql /opt/mysql4.1.13/data
#cp support-files/mysql.server /etc/rc.d/init.d/ 配置mysql启动设置
#chmod +x /etc/rc.d/init.d/mysql.server
#chkconfig --add mysql.server
3 配置server,note节点在192.168.0.160和192.168.0.161机器上
# cp support-files/my-medium.cnf data/my.cnf 将mysql的配置文件考到data下
Vi /usr/local/mysql-max-4.1.13-pc-linux-gnu-i686/data/my.cnf
ndbcluster
ndb-connectstring=192.168.0.1
ndb-connectstring=192.168.0.1
4 配置Management管理节点在192.168.0.1机器上
#mkdir /var/lib/mysql-cluster
#cd /var/lib/mysql-cluster
#vi config.ini
[NDBD DEFAULT] # Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=52M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[TCP DEFAULT] # TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
# Management process options(定义管理节点.)
[NDB_MGMD]
hostname=192.168.0.1 # 管理节点Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
# Options for data node "A"(定义群集数据节点.)
# (one [NDBD] section per data node)
[NDBD]
hostname=192.168.0.160 # 节点Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# Options for data node "B"(定义群集数据节点.)
[NDBD]
hostname=192.168.0.161 # 节点Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# SQL node options(定义Sql server节点.)
hostname=192.168.0.100 # SQL节点Hostname or IP address
#datadir=/usr/local/mysql/data # Directory for SQL node's datafiles
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[NDB_MGMD]:后面不能有任何注释信息,否则提示:
Error line 17: [TCP] Unknown parameter: [NDB_MGMD] # Management process options
Error line 17: Could not parse name-value pair in config file.
[SHM]:Defines shared-memory connections between nodes. 在MySQL4.1.9之前,这个功能必须使用--with-ndb-shm option编译进去, 从MySQL 4.1.9-max版本开始, it isenabled by default
5 启动mysql集群5.1 初始化启动mysql集群服务1)启动MysqlManagement管理节点(192.168.0.1)
#ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2)启动Data Node节点(192.168.0.160,192.168.0.161)
#ndbd --initial
(注意:这个参数只能在第一次启动DataNode节点时使用,因为―initial参数会删除一些ndbd 实例先前创建的所有文件)
3)启动MysqlServer节点(192.168.0.100)
# ./mysql.server start
5.2 重启mysql集群服务1)启动MysqlManagement管理节点(192.168.0.1)
#ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2)启动Data Node节点(192.168.0.160,192.168.0.161)
#ndbd
3)启动MysqlServer节点(192.168.0.100)
# ./mysql.server start
(注意:Management管理节点和DataNote节点都不开启mysql服务,只有MysqlServer节点开启。The defaultport for Cluster management nodes is 1186; the default port for datanodes is 2202.)
6 测试集群的效果6.1 在管理机上查看各节点运行状况[root@Proxy 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.0.160 (Version: 4.1.13, Nodegroup: 0, Master)
id=3 @192.168.0.161 (Version: 4.1.12, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.1 (Version: 4.1.13)
[mysqld(API)] 1 node(s)
id=4 @192.168.0.100 (Version: 4.1.12)
6.2 模拟写入一个数据库表,各MysqlServer节点是否能够同步1) 在一个MysqlServer节点上创建数据库world和表,然后看看另一个MysqlServer节点是否也同样可以看到。
答:数据都相同
2) 拔掉一个DataNote节点网线,看看两台MysqlServer节点是否还能正常工作。
答:可以
3) 拔掉两台DataNote节点网线,查看一下MysqlServer节点是否还能正常工作。
答:所有MysqlServer都不能正常工作
原文:http://hi.baidu.com/qk31/blog/item/350159af6c0232fafbed5076.html
MysqlServer节点:192.168.0.100
Mysql 节点:192.168.0.160
Mysql 节点:192.168.0.161
说明:至少需要四台服务器才可以做mysql的集群。建议5台,再增加一台MysqlServer。
2
(注意:可以做集群的mysql都是mysql-max的,下载地点www.mysql.org)
#groupadd mysql
#useradd -g mysql mysql
#cd /usr/local
#tar xfz mysql-max-4.1.13-pc-linux-gnu-i686.tar.gz
#ln -s /usr/local/mysql-max-4.1.13-pc-linux-gnu-i686 /opt/mysql4.1.13
2.2
#scripts/mysql_install_db --user=mysql (必须带目录执行,否则出错)
#chown -R root /opt/mysql4.1.13
#chgrp -R mysql /opt/mysql4.1.13
#chown -R mysql.mysql /opt/mysql4.1.13/data
#cp support-files/mysql.server /etc/rc.d/init.d/ 配置
#chmod +x /etc/rc.d/init.d/mysql.server
#chkconfig --add mysql.server
3
# cp support-files/my-medium.cnf data/my.cnf 将mysql的配置文件考到data下
Vi /usr/local/mysql-max-4.1.13-pc-linux-gnu-i686/data/my.cnf
ndbcluster
ndb-connectstring=192.168.0.1
ndb-connectstring=192.168.0.1
4
#mkdir /var/lib/mysql-cluster
#cd /var/lib/mysql-cluster
#vi config.ini
[NDBD DEFAULT] # Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=52M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[TCP DEFAULT] # TCP/IP options:
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead
# Management process options(定义管理节点.)
[NDB_MGMD]
hostname=192.168.0.1 # 管理节点Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles
# Options for data node "A"(
# (one [NDBD] section per data node)
[NDBD]
hostname=192.168.0.160 # 节点Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# Options for data node "B"(
[NDBD]
hostname=192.168.0.161 # 节点Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's datafiles
# SQL node options(
hostname=192.168.0.100 # SQL节点Hostname or IP address
#datadir=/usr/local/mysql/data # Directory for SQL node's datafiles
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[NDB_MGMD]:后面不能有任何注释信息,否则提示:
Error line 17: [TCP] Unknown parameter: [NDB_MGMD] # Management process options
Error line 17: Could not parse name-value pair in config file.
[SHM]:Defines shared-memory connections between nodes. 在MySQL4.1.9之前,这个功能必须使用--with-ndb-shm option编译进去, 从MySQL 4.1.9-max版本开始, it isenabled by default
5
#ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2)启动Data Node节点(192.168.0.160,192.168.0.161)
#ndbd --initial
(注意:这个参数只能在第一次启动DataNode节点时使用,因为―initial参数会删除一些
3)启动MysqlServer节点(192.168.0.100)
# ./mysql.server start
5.2
#ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2)启动Data Node节点(192.168.0.160,192.168.0.161)
#ndbd
3)启动MysqlServer节点(192.168.0.100)
# ./mysql.server start
(注意:Management管理节点和DataNote节点都不开启mysql服务,只有MysqlServer节点开启。The defaultport for Cluster management nodes is 1186; the default port for datanodes is 2202.)
6
-- 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.0.160 (Version: 4.1.13, Nodegroup: 0, Master)
id=3 @192.168.0.161 (Version: 4.1.12, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.1 (Version: 4.1.13)
[mysqld(API)] 1 node(s)
id=4 @192.168.0.100 (Version: 4.1.12)
6.2
答:数据都相同
2)
答:可以
3)
答:所有MysqlServer都不能正常工作
原文:http://hi.baidu.com/qk31/blog/item/350159af6c0232fafbed5076.html
0
上一篇:[转载]大型网站架构演变和知识体系 附带图片
下一篇:[转载]mysql 5.0 集群负载均衡 附带图片
相关热门文章
- IP Sec VPN与NAT破镜重圆
- 网站导航
- UT2.0正式版下载
- tomcat6.0配置(含配置视频下载...
- Gomez中国网站用户体验排行榜(...
- LNMP 老是会出现502?
- suse 运用一个shell获取本机和...
- 虚拟机 unix 配置ip
- hp-un 主机新系统读不到磁盘阵...
- mysql出现问题:Starting MySQ...
给主人留下些什么吧!~~
评论热议
0 0
- mysql负载均衡集群架设
- mysql负载均衡集群架设
- mysql负载均衡集群架设
- Lvs+Keepalived+MySQL Cluster架设高可用负载均衡Mysql集群
- Lvs+Keepalived+MySQL Cluster架设高可用负载均衡Mysql集群
- apache+tomcat+mysql负载均衡和集群
- apache+tomcat+mysql负载均衡和集群
- mysql 5.0 集群负载均衡配置
- mysql 5.0 集群负载均衡 附带图片
- hadoop,apache负载均衡,mysql集群
- Linux MYSQL负载均衡集群的搭建
- 搭建MySQL高可用负载均衡集群
- 搭建MySQL高可用负载均衡集群
- MySQL数据切分、负载均衡和集群
- 搭建MySQL高可用负载均衡集群
- 负载均衡集群软件
- 集群的负载均衡
- 集群+负载均衡
- 通用CRUD开发框架 附带图片
- PHPCMS
- 实现多服务器PHP 共享 SESSION 技巧 附带图片
- Facebook的成功秘诀是什么 - SNS之我见
- 大型网站架构演变和知识体系 附带图片
- mysql负载均衡集群架设
- mysql 5.0 集群负载均衡 附带图片
- QTP常用函数
- apache自带负载均衡的集群功能
- [摘录]跨域访问方法
- [介绍]Linux服务器集群系统 附带图片
- 谢文关于社会化网络和web2.0的3个PPT(2005-2007)
- 转载:php session共享
- 转载:php session 共享
原创粉丝点击
热门IT博客
热门问题
老师的惩罚
人脸识别
我在镇武司摸鱼那些年
重生之率土为王
我在大康的咸鱼生活
盘龙之生命进化
天生仙种
凡人之先天五行
春回大明朝
姑娘不必设防,我是瞎子
单县婚宴
单县游乐场
单县 郑州
单县早教
单县三中
单县买房
单县创业
单县玩具厂
单县卫校
单县 济南
单县ktv
单县净水机
单县名吃
单县火车站
北京去单县
单县男科
单县团购
单县王卫东
单县人流
单县房子
单县拆迁
单县小姐
单县妇科
单县旅店
单县是哪里
单县人口
单县证券
单县茂昌
单县电视台
单县哪好玩
单县打井
单县龙王庙
单县网
单县小生意
单县山药
单县游泳池
单县铁矿
单县到青岛
单县影音
单县家教
单县投标