Forum Discussion
Mario_Apitz___u
Nov 03, 2009Nimbostratus
Hi Aaron, hi Tom,
first of all: thanks for your response. Is there a way to split the MySQL requests based on the SQL statement?
MySql state in their documentation as follows abot scaling: http://dev.mysql.com/doc/refman/5.0/en/images/scaleout.png
They use a loadbalancer to distribute traffic between serveral webserver. Each webserver is bound on one Slave-MySql database.
But I would like to scale at a different place. I'd like to configure only one database ip and one port as a loadbalancer vip and distribute the traffic automatically.
I'd like to do it that way is: it works with absolutely every application and doesn't require any code changes or more complex deloyments.
Any ideas?
Kind regards,
Mario
P.S.: I'm aware of your point, Tom. Nonetheless, I would simply handle this as an UPDATE.