安哥网络 发表于 2013-6-26 01:12:41

MySQL数据库集群实现负载均衡的安装配置详解

本文我们主要介绍了MySQL数据库集群实现负载均衡的安装配置工作，接下来我们就让我们一起来了解一下这部分内容。
MySQL数据库集群关系如下图：
http://images.51cto.com/files/uploadimg/20110805/1550080.jpg
ndbd：数据库节点，物理数据实际存放位置。
mysqld：MySQL服务器节点。
ndbd_mgmd：管理节点。管理／查看各库节点和服务器节点的状态。程序直接访问的是这台机器的IP。默认端口仍是3306。
1.在ndb_mgmd、mysqld、Node A、Node B上安装MySQL5.0
安装目录：/usr/local/mysql
2.配置 Node A、Node B、mysqld：    # cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
   
    # vi /etc/my.cnf 在文件尾加入 # my.cnf
   
    # example additions to my.cnf for MySQL Cluster
   
    # (valid in MySQL 5.0) # enable ndbcluster storage engine, and provide connectstring for
   
    # management Server host (default port is 1186)
   
   
   
    ndbcluster
   
    ndb-connectstring=192.168.56.30 # provide connectstring for management Server host (default port: 1186)
   
   
   
    connect-string=192.168.56.30 # provide connectstring for management Server host (default port: 1186)
   
   
   
    connect-string=192.168.56.30 # provide location of cluster configuration file
   
   
   
    config-file=/var/lib/mysql-cluster 在Node A、Node B上创建日志文件夹# mkdir /var/lib/mysql-cluster3.配置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.mysql.com
   
    NoOfReplicas= 2
   
    DataDir= /var/lib/mysql-cluster
   
    Hostname= 192.168.56.30
   
    DataDir= /var/lib/mysql-cluster
   
    HostName= 192.168.56.11
   
    HostName= 192.168.56.12
   
   
   
    4. 启动服务    ndb_mgmd /usr/local/mysql/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini
   
    Node A      /usr/local/mysql/bin/ndbd --initial #只在第一次启动ndbd时使用--initial参数
   
    Node B      /usr/local/mysql/bin/ndbd --initial
   
    mysqld      /usr/local/mysql/support-files/mysql.server start检查工作状态 回到管理节点服务器Ndb_mgmd上，并启动管理终端：# /usr/bin/ndb_mgm    ndb_mgm> show
   
    Cluster Configuration    2 node(s)
   
    id=2 (not connected, accepting connect from 192.168.56.11)
   
    id=3 @192.168.56.12   (Version: 5.0.22, Nodegroup: 0, Master) 1 node(s)
   
    id=1 @192.168.56.30   (Version: 5.0.22) 3 node(s)
   
    id=4 @192.168.56.20   (Version: 5.0.22)
   
    id=5 (not connected, accepting connect from any host)
   
    id=6 (not connected, accepting connect from any host) mysqld(API)即mysqld --ndb-cluster，MySQL服务器节点，应该程序访问的IP。创建数据库（mysqld）：
   
    # /usr/local/mysql/bin/mysql
   
    > use test;
   
    > CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
   
    > INSERT INTO ctest () VALUES (1); 关于MySQL数据库集群负载均衡的配置就介绍到这里了，希望本次的介绍能够对您有所收获！
本文摘自：http://database.51cto.com/art/201108/281454.htm


春常5 发表于 2013-11-11 09:14:55

好帖要顶,楼主的头像还是不错滴http://forumimage.org/images/icon01.jpghttp://forumimage.org/images/icon02.jpghttp://forumimage.org/images/icon03.jpghttp://forumimage.org/images/icon04.jpghttp://forumimage.org/images/icon05.jpghttp://forumimage.org/images/icon06.jpghttp://forumimage.org/images/icon07.jpghttp://forumimage.org/images/icon08.jpghttp://forumimage.org/images/icon09.jpghttp://forumimage.org/images/icon10.jpghttp://forumimage.org/images/icon11.jpghttp://forumimage.org/images/icon12.jpghttp://forumimage.org/images/icon13.jpghttp://forumimage.org/images/icon14.jpghttp://forumimage.org/images/icon15.jpg

布防6 发表于 2014-2-9 19:34:23

页: [1]
查看完整版本: MySQL数据库集群实现负载均衡的安装配置详解