Skip navigation links

MySQL Forums :: Proxy :: Implementation questions & current RW splitting status


Advanced Search

Re: Implementation questions & current RW splitting status
Posted by: Mark Leith ()
Date: May 11, 2012 04:17AM

1) Here is good. :)

2) On a separate server to the database server is best, this can be a dedicated server, or it could be installed on app servers as well. It can be installed on the database server (and people do this for things like Query Analysis with MySQL Enterprise Monitor), but if you want to use it in a load balancing or HA set up, it's best to keep it off the database servers (because if the systems fail, proxy will fail).

3) Yes, see above.

4) R/W splitting has not moved forwards much unfortunately, it still has a number of limitations (listed here http://forge.mysql.com/wiki/MySQL_Proxy_RW_Splitting). We're currently working on re-working some of the core architecture to make a more scalable proxy, and this will likely be re-visited once that work is complete.

Regards

Mark

Best regards,

Mark

--
Mark Leith
Senior Software Development Manager
MySQL Enterprise Tools @ Oracle

Options: ReplyQuote


Subject Views Written By Posted
Implementation questions & current RW splitting status 2153 Wes Modes 04/05/2012 01:20PM
Re: Implementation questions & current RW splitting status 1464 Mark Leith 05/11/2012 04:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.