Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Benjamin
Site Administrator
Posts: 6935 Joined: Sun May 19, 2002 10:24 pm
Post
by Benjamin » Thu Aug 02, 2007 5:18 pm
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?
nathanr
Forum Contributor
Posts: 200 Joined: Wed Jun 07, 2006 5:46 pm
Post
by nathanr » Thu Aug 02, 2007 6:32 pm
how many servers?
if its master slave.. do all selects on slave, all inserts/updates/deletes on master.
Benjamin
Site Administrator
Posts: 6935 Joined: Sun May 19, 2002 10:24 pm
Post
by Benjamin » Thu Aug 02, 2007 6:41 pm
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.
nathanr
Forum Contributor
Posts: 200 Joined: Wed Jun 07, 2006 5:46 pm
Post
by nathanr » Thu Aug 02, 2007 6:46 pm
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
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Thu Aug 02, 2007 6:59 pm
Just use master-master replication if you can. It saves so many headaches like this.