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.
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:
useradd – g mysql
tar – zxvf 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.