Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
Subject: short e-mail survey on load-balance technology used

Subject: short e-mail survey on load-balance technology used

2007-11-01       - By Russell E Glaue

 Back

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/mysql?unsub=mysql@(protected)