R/W splitting and MySQL proxy with two MASTER

[Anthony XXX]

Hi all,

I have 2 MySQL server (2 masters) and 1 MySQL Proxy.
I use the rw-splitting.lua script to write on SERVER1 and read on SERVER2.

All works correctly.

Now, my problem is that if the SERVER1 is down I would like that we can write automaticaly on SERVER2.

There is a solution for that point ?

Here is my launching script :

#!/bin/bash

HOST=0.0.0.0
MASTERDB=10.10.10.1
SLAVEDB01=10.10.10.2
ROOT_DIR=/root

LUA_PATH="$ROOT_DIR/mysql-proxy/share/mysql-proxy/?.lua" $ROOT_DIR/mysql-proxy/bin/mysql-proxy \
--daemon \
--proxy-backend-addresses=$MASTERDB:3306 \
--proxy-read-only-backend-addresses=$SLAVEDB01:3306 \
--proxy-lua-script=$ROOT_DIR/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua \
--log-level=debug \
--log-file=/var/log/mysqld.log

Thanks.