建站
咨詢
售后
建站咨詢
新聞中心
本文我們主要介紹了MySQL數(shù)據(jù)庫集群實(shí)現(xiàn)負(fù)載均衡的安裝配置工作，接下來我們就讓我們一起來了解一下這部分內(nèi)容。
創(chuàng)新互聯(lián)是一家集網(wǎng)站建設(shè),臨夏企業(yè)網(wǎng)站建設(shè),臨夏品牌網(wǎng)站建設(shè),網(wǎng)站定制,臨夏網(wǎng)站建設(shè)報價,網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,臨夏網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強(qiáng)企業(yè)競爭力?？沙浞譂M足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時我們時刻保持專業(yè)、時尚、前沿，時刻以成就客戶成長自我，堅(jiān)持不斷學(xué)習(xí)、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實(shí)用型網(wǎng)站。
MySQL數(shù)據(jù)庫集群關(guān)系如下圖：
ndbd：數(shù)據(jù)庫節(jié)點(diǎn)，物理數(shù)據(jù)實(shí)際存放位置。
mysqld：MySQL服務(wù)器節(jié)點(diǎn)。
ndbd_mgmd：管理節(jié)點(diǎn)。管理／查看各庫節(jié)點(diǎn)和服務(wù)器節(jié)點(diǎn)的狀態(tài)。程序直接訪問的是這臺機(jī)器的IP。默認(rèn)端口仍是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)
- [mysqld]
- ndbcluster
- ndb-connectstring=192.168.56.30 # provide connectstring for management Server host (default port: 1186)
- [ndbd]
- connect-string=192.168.56.30 # provide connectstring for management Server host (default port: 1186)
- [ndb_mgm]
- connect-string=192.168.56.30 # provide location of cluster configuration file
- [ndb_mgmd]
- config-file=/var/lib/mysql-cluster
在Node A、Node B上創(chuàng)建日志文件夾
- # mkdir /var/lib/mysql-cluster
3.配置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 [NDBD DEFAULT]
- NoOfReplicas= 2
- DataDir= /var/lib/mysql-cluster [NDB_MGMD]
- Hostname= 192.168.56.30
- DataDir= /var/lib/mysql-cluster [NDBD]
- HostName= 192.168.56.11 [NDBD]
- HostName= 192.168.56.12[MYSQLD]
- [MYSQLD]
- [MYSQLD]
4. 啟動服務(wù)
- 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參數(shù)
- Node B /usr/local/mysql/bin/ndbd --initial
- mysqld /usr/local/mysql/support-files/mysql.server start檢查工作狀態(tài)
回到管理節(jié)點(diǎn)服務(wù)器Ndb_mgmd上，并啟動管理終端：# /usr/bin/ndb_mgm
- ndb_mgm> show
- Cluster Configuration [ndbd(NDB)] 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) [ndb_mgmd(MGM)] 1 node(s)
- id=1 @192.168.56.30 (Version: 5.0.22) [mysqld(API)] 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服務(wù)器節(jié)點(diǎn)，應(yīng)該程序訪問的IP。創(chuàng)建數(shù)據(jù)庫（mysqld）：
- # /usr/local/mysql/bin/mysql
- > use test;
- > CREATE TABLE ctest (i INT) ENGINE=NDBCLUSTER;
- > INSERT INTO ctest () VALUES (1);
關(guān)于MySQL數(shù)據(jù)庫集群負(fù)載均衡的配置就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！
本文題目：MySQL數(shù)據(jù)庫集群實(shí)現(xiàn)負(fù)載均衡的安裝配置詳解
文章地址：http://fisionsoft.com.cn/article/coedgej.html
