Page 1 of 1
query routing, master & slaves
Posted: Thu Aug 02, 2007 5:18 pm
by Benjamin
Do any of you have any experience with applications such as
MySQL Proxy?
In large applications what is the best way to determine what server to route the queries to?
Posted: Thu Aug 02, 2007 6:32 pm
by nathanr
how many servers?
if its master slave.. do all selects on slave, all inserts/updates/deletes on master.
Posted: Thu Aug 02, 2007 6:41 pm
by Benjamin
Well there are issues in that if you run a select that depends on an insert/update/replace/ or stored procedure that happened right before it, it won't be in the slave servers yet. For the sake of example, let's say there are 4 slaves. I'm really just looking for general answers though.
Posted: Thu Aug 02, 2007 6:46 pm
by nathanr
okay, I'm goign to bail out of this thread now - only recommendation would be to move up to mysql cluster and let it do the working out

Posted: Thu Aug 02, 2007 6:59 pm
by Chris Corbyn
Just use master-master replication if you can. It saves so many headaches like this.