MySQL Forums
Forum List  »  Replication

Re: Directing particular query on another machine
Posted by: James Day
Date: April 24, 2005 04:35PM

This is normally done by your application code (PHP or whatever else you use). Generally you'd have a function you write which chooses the server to use, then you control the rules it uses to decide which server gets the query.

The PHP code for Mediawiki contains an example of how to do this. Wikipedia uses that to share load between five servers, with variables in a configuration file saying which databases use which servers. Splitting reads by database increases cache hit rates and total performance for the set of servers.

Options: ReplyQuote

Written By
Re: Directing particular query on another machine
April 24, 2005 04:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.