Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've been doing a bit of research, and I would love to use mysql-proxy in production, because

  1. It supports sockets
  2. It supports read-write splitting

My other option is to use HAProxy and change all the configuration files to use TCP/IP rather than sockets.

I see that mysql-proxy is STILL in alpha, however there seems to be lots of development on it and it has been around for quite a while.

Can anyone recommend mysql-proxy in production in a high volume environment? Or should I just give up on this idea?

share|improve this question

1 Answer 1

At present, MySQL Proxy is nothing more that just good IP redirection.

@DTest in the DBA StackExchange has addressed MySQL Proxy only twice

Everything that can be customized about MySQL Proxy is only proof-of-concept at the moment. IMHO, the major challenge is the fact that such customization is implemented in the LUA language. The greatest customization most are looking for is the read/write splitting among designated IP Addresses.

If anyone has successfully implemented Read/Write Splitting using MySQL Proxy, I am sure it is being kept as a well-guarded secret by some SuperSmart LUA Programmer/Business Person waiting to sell their consulting services to the highest bidder.

share|improve this answer
    
hmmm im unsure because some docs say –  Christian Tortorich Jan 2 '13 at 19:49
    
I know this question is old but just wanted to point out that mysql-proxy IS NOT written in lua, lua is just used for the user scripts, the application itself is in C. –  Schmurfy Jul 5 '13 at 12:21
    
@Schmurfy I was only referring to the holy grail of MySQL Proxy everyone is looking for : The read-write split. I'll update the language of my answer to reflect that. Thank you. –  RolandoMySQLDBA Jul 5 '13 at 14:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.