Permit me to query the users on this list to ask a few questions on if and how they scale their MySQL with the use of load-balancers.
I am only expecting very short answers, but you may choose to answer how ever you like. My goal is to try and understand what state the MySQL community is in with the use of load-balancing technology, and what is the next step we think technology should go. If you are willing to reply to these questions, I thank you. -RG 1) Do you use a load-balancer for your MySQL Deployment? ## If yes, please answer the remaining questions. 2) What load-balancer (product name) do you use for your MySQL Deployment? 3) Do you use the default mechanisms of the load-balancer to negotiate traffic to your MySQL deployment, or have you created your own custom mechanism for the load-balancer to use? 4) (a) Other than your current load-balancer, have you tried to use any other load-balancers with success or failure? (b) Or is there another load-balancer you are looking into possibly using? (Some Examples: MySQL Proxy, Continuent, Sequoia (C-JDBC), Linux Virtual Server, F5 Networks BigIP, EddieDNS, or even Heartbeat, Pen, Python Director, Distributor) 5) How do you primarily use the load balancer? 1) load-balance read-only SQL queries 2) load-balance read-write SQL queries 3) other? (like some custom setup) 6) When it comes to scaling MySQL and the use of load-balancing, what do you feel is a technology that is missing that the MySQL community should create? (I.e. perhaps some new technical item in the MySQL database server software, or something on the load-balancing technology side) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]