MySQL的叢集的安裝與配置(6台機器)

來源:互聯網
上載者:User

具體安裝與配置:
1)
準備工作:
6台機器,IP地址分別為
192.168.0.(231-236)
MGM節點:192.168.0.231(232)

SQL 節點:192.168.0.233-234

NDBD 節點:192.168.0.235-236

系統都是RedHat AS 5.0
裝了基本的組件,具有連網功能,而且關閉了防火牆。
軟體,版本是:

  mysql-5.1.21-beta-linux-i686-glibc23.tar.gz

2)管理節點的安裝:(232和231的機器)
    shell> cd /var/tmp
    shell> tar -zxvf   mysql-5.1.21-beta-linux-i686-glibc23.tar.gz
    shell> cd /var/tmp/mysql-5.1.21-beta-linux-i686-glibc23
    shell> mkdir /usr/local/mysql
    shell> cp bin/ndb_mgm* /usr/local/mysql
    shell> cd /usr/local/mysql
    shell> chmod a+x ndb_mgm*
    shell> mkdir data(用來存放管理節點的資料)
3)SQL節點和NDBD 節點的安裝:(233-236 四台機器)
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /var/tmp
shell> tar -C /usr/local -xzvf mysql-5.1.21-beta-linux-i686-glibc23.tar.gz 
shell> mv /usr/local/mysql-5.1.21-beta-linux-i686-glibc23 /usr/local/mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R mysql:mysql /usr/local/mysql 


SQL節點還要增加下面的步驟才可以:

shell> cp support-files/mysql.server /etc/rc.d/init.d/mysqld
shell> chmod a+x /etc/rc.d/init.d/mysqld
shell> chkconfig --add mysqld
shell> chkconfig mysqld on (註冊MYSQL為系統的服務) 

4)配置NDBD節點:
[root@localhost mysql]# cat /etc/my.cnf 
[mysqld]
ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
這樣寫是可以串連成功。不過我今天來的時候發現全部DOWN掉了。
ndb-connectstring=192.168.0.231,192.168.0.232
[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232
[root@localhost mysql]# 

5)配置SQL 節點:
[root@localhost mysql]# cat /etc/my.cnf 
[mysqld]
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/
port=3306
user=nobody
socket=/tmp/mysql.sock

ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232

[ndbd]
connect-string=192.168.0.235
[ndbd]
connect-string=192.168.0.236

[ndbd_mgm]
connect-string=192.168.0.231
[ndbd_mgm]
connect-string=192.168.0.232
[ndbd_mgmd]
config-file=/etc/config.ini


[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232
[root@localhost mysql]# 
  • 1
  • 2
  • 3
  • 下一頁

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.