keepalive+lvs+mysql的高可用的雙機(jī)解決方案

1、keepalive+lvs+mysql的高可用的雙機(jī)解決方案對(duì)照這個(gè)計(jì)劃，分享存儲(chǔ)對(duì)于解決mysql的高可用的數(shù)據(jù)同步，無疑要優(yōu)異的多，對(duì)于隨著對(duì)keepaliv了解的慢慢，無意間發(fā)覺了mysql數(shù)據(jù)同步的解決計(jì)劃，非常的感愛好，自然而然本計(jì)劃的技術(shù)重點(diǎn)在于mysql的數(shù)據(jù)同步，廢話不說了，開頭做試驗(yàn)。 試驗(yàn)原理：兩臺(tái)vm 下的linux（centos5.5）服務(wù)器，采納keepalived軟件作為高可用和的處理軟件。 主節(jié)點(diǎn)ip：96 備用節(jié)點(diǎn)ip：95 自行配置好yum源，采納本地鏡像和外部的yum源都可以，以下的這個(gè)步驟是在兩臺(tái)服務(wù)器上安裝相關(guān)

2、的軟件，固然按照系統(tǒng)不同，需要安裝的軟件不盡相同，這里是列出來我需要安裝的軟件，大家可以按照提醒自行安裝。 第一：先說在雙節(jié)點(diǎn)都要做的相同的步驟 rootlocalhost yum -y install ipvsadm kernel-devel openssl openssl-devel rootlocalhost -s /usr/src/kerne/2.6.18-194.el5-i686/ /usr/src/linux rootlocalhost wget /software/keepalived-1.2.1.tar.gz rootlocalh

3、ost ls keepalived-1.2.1.tar.gz keepalived-1.2.1.tar.gz rootlocalhost tar zxvf keepalived-1.2.1.tar.gz rootlocalhost keepalived-1.2.1 rootlocalhost keepalived-1.2.1 ./configure /結(jié)束后浮現(xiàn)以下的內(nèi)容表示可以編譯安裝了 keepalived configuration - keepalived version : 1.2.1 compiler : gcc compiler flags : -g -o2 -dethertyp

4、e_ipv6=0x86 exa lib : -lpopt -lssl -lcrypto use ipvs framework : yes ipvs sy daemon pport : yes use vrrp framework : yes use debug flags : no rootlocalhost keepalived-1.2.1 make make install rootlocalhost yum -y install mysql-server mysql 其次：mysql在主節(jié)點(diǎn)上的設(shè)置（master） 首先是對(duì)mysql的設(shè)置（關(guān)鍵） rootlocalhost /etc/

5、init.d/mysqld start rootlocalhost mysql welcome to the mysql monitor. commands end with ; or g. your mysql connection is 4 server version: 5.0.77-log source distribution type 'help;' or 'h' for help. type 'c' to the buffer. mysql grant repliion slave, on *.* to 'repl1'

6、;'95' identified by '123456' query ok, 0 rows affected (0.02 sec) mysql q bye rootlocalhost /etc/init.d/mysqld stop rootlocalhost vi /etc/f mysqld datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql log-bin=mysql-bin server-id=1 binlog-do-db=test binlog-igno

7、re-db=mysql replicate-do-db=test replicate-ignore-db=mysql log-slave-ups slave-skip-errors=all _binlog=1 auto_increment_increment=2 auto_increment_off=1 rootlocalhost /etc/init.d/mysqld start rootlocalhost mysql welcome to the mysql monitor. commands end with ; or g. your mysql connection id is 4 se

8、rver version: 5.0.77-log source distribution type 'help;' or 'h' for help. type 'c' to clear the buffer. mysql flush tables with read lockg query ok, 0 rows affected (0.00 sec) mysql show master usg * 1. row * file: mysql-bin.000001 position: 98 binlog_do_db: test binlog_igno

9、re_db: mysql 1 row in set (0.00 sec) mysql change master to master_host='95', master_user='repl2', master_password='123456', master_log_file='mysql-bin.000001', master_log_pos=98; mysql slave start; query ok, 0 rows affected, 1 warning (0.00 sec) mysql unlo

10、ck tables; query ok, 0 rows affected (0.15 sec) mysql show slave statusg; /這個(gè)步驟關(guān)鍵是看到以下兩項(xiàng)開啟 slave_io_running: yes slave_sql_running: yes mysql grant all privileges on *.* to 'root''%' identified by '123456' query ok, 0 rows affected (0.00 sec) mysql flush privileges; query ok,

11、 0 rows affected (0.00 sec) 第三：mysql在備用節(jié)點(diǎn)上的設(shè)置 rootlocalhost /etc/init.d/mysqld start rootlocalhost mysql welcome to the mysql monitor. commands end with ; or g. your mysql connection id is 4 server version: 5.0.77-log source distribution type 'help;' or 'h' for help. type 'c'

12、 to clear the buffer. mysql grant replication slave,file on *.* to 'repl2''96' identified by '123456' query ok, 0 rows affected (0.02 sec) mysql q bye rootlocalhost /etc/init.d/mysqld stop rootlocalhost vi /etc/f mysqld datadir=/var/lib/mysql socket=/var/lib/mysql/

13、mysql.sock user=mysql log-bin=mysql-bin server-id=2 binlog-do-db=test binlog-ignore-db=mysql replicate-do-db=test replicate-ignore-db=mysql log-slave-updates slave-skip-errors=all sync_binlog=1 auto_increment_increment=2 auto_increment_offset=2 rootlocalhost /etc/init.d/mysqld start rootlocalhost mysql welcome to the mysql monitor. commands end with ; or g. your mysql connection id is 4 server version: 5.0.77-log source distribution type 'help;' or &#