mysql-proxy-discuss team mailing list archive

[Brian Zammit <brianjzammit@xxxxxxxxx>]

---------- Forwarded message ----------
From: Brian Zammit <brianjzammit@xxxxxxxxx>
Date: 2009/6/16
Subject: Re: [Mysql-proxy-discuss] Guide to running multiple proxies on same
machine
To: Kay Röpke <Kay.Roepke@xxxxxxx>




2009/6/16 Kay Röpke <Kay.Roepke@xxxxxxx>

> Hi!
>
>
> On Jun 16, 2009, at 4:01 PM, Brian Zammit wrote:
>
>  Hello group,
>>
>> I need to run two proxies on the same server, one on default port 4040 and
>> the other on port 4050 (arbitrarly chosen). One is used for read and the
>> other for writes, split at the application level.
>>
>> Is there a recommended way to startup, run and control two proxies running
>> on a machine?
>>
>
>
> Not really, as we currently don't supply init.d scripts for example.

I've been using an init.d script that looks like the following:
#!/bin/sh
#
# mysql-proxy This script starts and stops the mysql-proxy daemon
#
# chkconfig: - 78 30
# processname: mysql-proxy
# description: mysql-proxy is a proxy daemon to mysql

# Source function library.
. /etc/rc.d/init.d/functions

PROXY_PATH=/opt/mysql-proxy/sbin

prog="mysql-proxy"

# Source networking configuration.
. /etc/sysconfig/network

# Check that networking is up.
[ ${NETWORKING} = "no" ] && exit 0

# Set default mysql-proxy configuration.
PROXY_OPTIONS="--daemon"
PROXY_PID=/var/run/mysql-proxy.pid

# Source mysql-proxy configuration.
if [ -f /etc/sysconfig/mysql-proxy ] ; then
        . /etc/sysconfig/mysql-proxy
fi

PATH=$PATH:/usr/bin:/usr/local/bin:$PROXY_PATH

# By default it's all good
RETVAL=0

# See how we were called.
case "$1" in
  start)
        # Start daemon.
        echo -n $"Starting $prog: "
        daemon $NICELEVEL $PROXY_PATH/mysql-proxy $PROXY_OPTIONS --pid-file
$PROXY_PID
        RETVAL=$?
        echo
        if [ $RETVAL = 0 ]; then
                touch /var/lock/subsys/mysql-proxy
        fi
        ;;
  stop)
        # Stop daemons.
        echo -n $"Stopping $prog: "
        killproc $prog
        RETVAL=$?
        echo
        if [ $RETVAL = 0 ]; then
                rm -f /var/lock/subsys/mysql-proxy
                rm -f $PROXY_PID
        fi
        ;;
  restart)
        $0 stop
        sleep 3
        $0 start
        ;;
  condrestart)
       [ -e /var/lock/subsys/mysql-proxy ] && $0 restart
       ;;
  status)
        status mysql-proxy
        RETVAL=$?
        ;;
  *)
        echo "Usage: $0 {start|stop|restart|status|condrestart}"
        RETVAL=1
        ;;
esac

exit $RETVAL


And associated /etc/sysconfig/mysql-proxy file that looks like the
following:
# Options to mysql-proxy
# do not remove --daemon
PROXY_OPTIONS="--daemon --proxy-skip-profiling
--proxy-address=localhost:4040 --admin-address=localhost:4041
--proxy-backend-addresses=10.10.10.10:3306"



>
> However, the easiest way to do it is to use the --defaults-file option for
> the two instances.
> Joshua described the format in a blog post:
> http://blog.zhuzhaoyuan.com/2009/02/using-mysql-proxys-configuration-file/
>
> That way you only have to use one parameter when starting the proxies.

Ah, thats a neat idea. I'll try this out.

Thanks,

Brian