iRule for splitting SQL Write and Read

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.