MariaDB Proxy讀寫(xiě)分離的實(shí)現(xiàn)

1.創(chuàng)建用于存儲(chǔ)數(shù)據(jù)目錄lvm設(shè)備

安裝mysql-proxy-0.8.3

MariaDB 的詳細(xì)介紹：請(qǐng)點(diǎn)這里
MariaDB 的下載地址：請(qǐng)點(diǎn)這里

--------------------------------------分割線 --------------------------------------

推薦閱讀：

在CentOS/RHEL/Scientific Linux 6 下安裝 LAMP (Apache with MariaDB and PHP)http://www.linuxidc.com/Linux/2013-07/86755.htm

Haproxy+Keepalived搭建Weblogic高可用負(fù)載均衡集群http://www.linuxidc.com/Linux/2013-09/89732.htm

Keepalived+HAProxy配置高可用負(fù)載均衡http://www.linuxidc.com/Linux/2012-03/56748.htm

CentOS 6.3下Haproxy+Keepalived+Apache配置筆記http://www.linuxidc.com/Linux/2013-06/85598.htm

Haproxy + KeepAlived 實(shí)現(xiàn)WEB群集 on CentOS 6http://www.linuxidc.com/Linux/2012-03/55672.htm

Haproxy+Keepalived構(gòu)建高可用負(fù)載均衡http://www.linuxidc.com/Linux/2012-03/55880.htm

--------------------------------------分割線 --------------------------------------

為mysql-proxy提供SysV服務(wù)腳本，內(nèi)容如下所示
#vim /etc/rc.d/init.d/mysql-proxy

#!/bin/bash

#

# mysql-proxy Thisscript starts and stops the mysql-proxy daemon

#

# chkconfig: - 7830

# processname:mysql-proxy

# description:mysql-proxy is a proxy daemon for mysql

# Source functionlibrary.

./etc/rc.d/init.d/functions

prog="/usr/local/mysql-proxy/bin/mysql-proxy"

# Sourcenetworking configuration.

if [ -f/etc/sysconfig/network ]; then

. /etc/sysconfig/network

fi

# Check thatnetworking is up.

[ ${NETWORKING} = "no"] && exit 0

# Set defaultmysql-proxy configuration.

ADMIN_USER="admin"

ADMIN_PASSWD="admin"

ADMIN_LUA_SCRIPT="/usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua"

PROXY_OPTIONS="--daemon"

PROXY_PID=/var/run/mysql-proxy.pid

PROXY_USER="mysql-proxy"

# Sourcemysql-proxy configuration.

if [ -f/etc/sysconfig/mysql-proxy ]; then

. /etc/sysconfig/mysql-proxy

fi

RETVAL=0

start() {

echo -n $"Starting $prog: "

daemon $prog $PROXY_OPTIONS--pid-file=$PROXY_PID --proxy-address="$PROXY_ADDRESS"--user=$PROXY_USER --admin-username="$ADMIN_USER"--admin-lua-script="$ADMIN_LUA_SCRIPT"--admin-password="$ADMIN_PASSWORD"

RETVAL=$?

echo

if [ $RETVAL -eq 0 ]; then

touch /var/lock/subsys/mysql-proxy

fi

}

stop() {

echo -n $"Stopping $prog: "

killproc -p $PROXY_PID -d 3 $prog

RETVAL=$?

echo

if [ $RETVAL -eq 0 ]; then

rm -f /var/lock/subsys/mysql-proxy

rm -f $PROXY_PID

fi

}

# See how we werecalled.

case"$1" in

start)

start

;;

stop)

stop

;;

restart)

stop

start

;;

condrestart|try-restart)

if status -p $PROXY_PIDFILE $prog>&/dev/null; then

stop

start

fi

;;

status)

status -p $PROXY_PID $prog

;;

*)

echo "Usage: $0{start|stop|restart|reload|status|condrestart|try-restart}"

RETVAL=1

;;

esac

exit$RETVAL

將上述內(nèi)容保存為/etc/rc.d/init.d/mysql-proxy，給予執(zhí)行權(quán)限，而后加入到服務(wù)列表。

#chmod +x /etc/rc.d/init.d/mysql-proxy

#chkconfig --add mysql-proxy

更多詳情見(jiàn)請(qǐng)繼續(xù)閱讀下一頁(yè)的精彩內(nèi)容：http://www.linuxidc.com/Linux/2014-05/101306p2.htm

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com