Steps to Set Up MySQL Cluster For Multiple Dedicated Servers

Primary expect to arrangement bunching MySQL is to have excess – you server and applications will run easily regardless of whether one server goes down. 투데이서버

Note: For better execution you ought to have a third server as an administration hub yet this can be closed down after the bunch begins. Likewise note that closing down the administration server isn’t suggested (see the additional notes at the base of this report for more data). You can not run a MySQL Cluster with only two Dedicated servers And have genuine excess.

Image result for 투데이서버 images

It is conceivable to set up the group on two Dedicated Servers you won’t get the capacity to “murder” one server and for the bunch to proceed as ordinary. For this you need a third server running the administration hub.

Presently beneath I had given the model for three servers:

mysql1.domain.com – 192.168.0.1

mysql2.domain.com – 192.168.0.2

mysql3.domain.com – 192.168.0.3

Servers 1 and 2 will be the two that end up “bunched”. This would be ideal for two servers behind a heap balancer or utilizing cooperative effort DNS and is a decent swap for replication. Server 3 needs to have just minor changes made to it and doesn’t require a MySQL introduce. It tends to be a low-end machine and can be doing different assignments.

STAGE 1: Install MySQL on the initial two servers:

Complete the accompanying strides on both mysql1 and mysql2:

compact disc/usr/neighborhood/

dev.mysql.com/get/Downloads/MySQL-4.1/mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz/

from/signal42.com/mirrors/mysql/

groupadd mysql

useradd – g mysql

tar – zxvf mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz

rm mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz

ln – s mysql-max-4.1.9-pc-linux-gnu-i686 mysql

compact disc mysql

contents/mysql_install_db – user=mysql

chown – R root .

chown – R mysql information

chgrp – R mysql .

cp support-records/mysql.server/and so forth/rc.d/init.d/

chmod +x/and so forth/rc.d/init.d/mysql.server

chkconfig – include mysql.server

Try not to begin MySQL yet.

STAGE 2: Install and arrange the administration server

You need the accompanying records from the receptacle/of the mysql catalog: ndb_mgm and ndb_mgmd. Download the entire mysql-max tarball and separate them from the canister/catalog.

Leave a comment

Your email address will not be published. Required fields are marked *