51CTO下载-mysql+5+集群负载均衡.doc

mysql 5.0 集群负载均衡—经过测试转载请注明作者和出处一、介绍========测试环境：Server1:ndbd 1Server2:ndbd 2Server3:mysqld --ndb-cluster 3 (ndbd_mgm ndbd_mgmd也在本机)操作系统均为RH ES3kernel-2.4.21-9.ELglibc-2.3.2-95.6所需软件包：mysql-max-5.0.22-linux-i686-icc-glibc23.tar.gz下载地址：/downloads/mysql/5.0.html下载时注意系统环境和软件包版本，MySQL是max版的。首先，明确几个概念（参照下图）：ndbd： 数据库节点。mysqld --ndb-cluster： MySQL服务器节点，程序直接访问的是这台机器的IP。默认端口仍是3306。ndbd_mgm ndbd_mgmd： 管理节点。管理／查看各库节点和服务器节点的状态。二、在Server1、Server2、Server3上安装MySQL=================================1.安装：# mv mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz /usr/local/# cd /usr/local/# tar -zxvf mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz# ln -s mysql-max-4.1.9-pc-linux-gnu-i686 mysql# groupadd mysql# useradd -g mysql mysql# cd mysql# scripts/mysql_install_db --user=mysql# chown -R mysql:mysql .2.编辑配置文件：# cp /usr/local/mysql/support-files/f /etc/f# vi /etc/f 在文件尾加入# f# example additions to f for MySQL Cluster# (valid in MySQL 5.0)# enable ndbcluster storage engine, and provide connectstring for# management Server host (default port is 1186)[mysqld]ndbclusterndb-connectstring=3# provide connectstring for management Server host (default port: 1186)[ndbd]connect-string=3# provide connectstring for management Server host (default port: 1186)[ndb_mgm]connect-string=3# provide location of cluster configuration file[ndb_mgmd]config-file=/var/lib/mysql-cluster保存＆退出3.在Server1、Server2上创建日志文件夹，默认# mkdir /var/lib/mysql-cluster4.在Server3上创建ndb_mgmd启动配置文件：# mkdir /var/lib/mysql-cluster# cd /var/lib/mysql-cluster# vi config.ini内容如下：# file config.ini - 2 data nodes and 2 SQL nodes# This file is placed in the startup directory of ndb_mgmd (the# management server)# The first MySQL Server can be started from any host. The second# can be started only on the host mysqld_5.[NDBD DEFAULT]NoOfReplicas= 2DataDir= /var/lib/mysql-cluster[NDB_MGMD]Hostname= 3DataDir= /var/lib/mysql-cluster[NDBD]HostName= 1[NDBD]HostName= 2