Where can If I find a read\write splitting lua script?

Hi,

There is a proof of concept, that works for some people, but does not
work for many, many others.

You can find information about it here

http://forge.mysql.com/wiki/MySQL_Proxy_RW_Splitting

and the latest version of it is here

http://bazaar.launchpad.net/~mysql-proxy-developers/mysql-proxy/trunk/annotate/head%3A/lib/rw-splitting.lua

Just keep in mind that besides the bugs reported on the forge page,
there are more limitations to the file.

Thanks

  -Diego

On Thu, Dec 10, 2009 at 8:19 AM, Kais
<email address hidden> wrote:
> New question #93579 on MySQL Proxy:
> https://answers.launchpad.net/mysql-proxy/+question/93579
>
> Please, I want to try the read\write splitting technique, but still didn find the appropriate .lua script. Is there any known somehow stable script that I can test or at least try to run?
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
http://www.fmpwizard.com

Hi,

Well, I was glad enough that I rapiddaly tried the script on a stable application I have. Well, Im sorry to be from the unhappy group of people which this script doesn't work for. But, anyway here's some of the exceptions I had on jboss AS when I ran the script (It might be useful for someone, don know):

- java.sql.SQLException: XAER_NOTA: Unknown XID
- enlistResource failed
- Unknown prepared statement handler (4) given to mysql_stmt_close
- tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server-pc/32, BranchQual=, localId=32] errorCode=XA_UNKNOWN(0)
- tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server-pc/32, BranchQual=, localId=32] errorCode=XAER_NOTA
- java.sql.SQLException: ResultSet is from UPDATE. No Data.
- java.sql.SQLException: Column Index out of range, 3 > 2.
- com.mysql.jdbc.jdbc2.optional.MysqlXAConnection$MysqlXAException: XAER_DUPID: The XID already exists
- 16:37:15,718 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server-pc/60, BranchQual=, localId=60] errorCode=XAER_RMFAIL
com.mysql.jdbc.jdbc2.optional.MysqlXAConnection$MysqlXAException: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state

regards,
Kais.