MySQL Cluster Server Setup

MySQL Cluster Server Setup

转载请标明出处： http://blog.csdn.net/h_leuyhhnnmoplppo   本文来自 CSDN 博客。x

Hardwar

but the process for set up a mySQL cluster server on other UNIX- or Linux-bas platform is veri similar,We us four Sun Ultra Enterpris server in our test environment. and thi setup guid should be applic with littl or no modification.

Our four machin each fall into on of three roles:

1. storag node mysql-ndb-1 and mysql-ndb-2

2. API node mysql-api-1

3. manag server and manag consol mgmt

but the API node is not a storag node. The API node is a full member of the cluster,Note that the storag node ar also API nodes. but it doe not store ani cluster data, and it state whether it is up or down doe not affect the integr or availablil of the data on the storag nodes. It can be thought of as a "client" of the cluster. Applicat such as web server live on the API node and commun with the mySQL server process run locally, on the API node itself, which take care of fetch data from the storag nodes. The storag node ar API node as well, and technic addit applic could be instal there and commun with the cluster via the mySQL server process run on them, but for manag and perform reason thi probabl should be consid a sub-optim configur in a product environment.

Softwar

Sun Solari 8 oper system

mysql-max-4.1.9

for implement on other platforms,W us the precompil binari distribut of mySQL server for Sun SPA RC Solari 8. Obviously. the appropri binari distribut should be used. In all cases, the "max" mySQL distribut is required. The mySQL 4.1 download page can be found here .

Procedure

mysql-ndb-1 192.168.0.33 and mysql-ndb-2 192.168.0.34 ,Step 1 . On both storag nodes. obtain and instal mySQL server:

 

mysql-ndb-1# groupadd mysql

mysql-ndb-1# useradd -g mysql mysql

mysql-ndb-1# cd /usr/loc

mysql-ndb-1# wget http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-max-4.1.9-sun-solaris2.8-sparc.tar.gz/from/http://mysql.he.net/

mysql-ndb-1# gzip -dc mysql-max-4.1.9-sun-solaris2.8-sparc.tar.gz | tar xvf -

mysql-ndb-1# ln -s mysql-max-4.1.9-sun-solaris2.8-sparc mysql

mysql-ndb-1# cd mysql

mysql-ndb-1# scripts/mysql_install_db --user=mysql

mysql-ndb-1# chown -R root  .

mysql-ndb-1# chown -R mysql data

mysql-ndb-1# chgrp -R mysql .

mysql-ndb-1# cp support-files/mysql.serv /etc/init.d/ mysql.serv

mysql-ndb-2# groupadd mysql