[development] Re: enterprise needs
Brian Puccio
brian at brianpuccio.net
Mon Feb 27 09:22:55 UTC 2006
On Sun, 2006-02-26 at 20:34 -0500, pat at linuxcolumbus.com wrote:
> > 6. Do MySQL replication
> >
>
> By this do you mean geographically seperate web servers?
http://dev.mysql.com/doc/refman/5.0/en/replication-intro.html
Better response time for clients can be achieved by splitting the load
for processing client queries between the master and slave servers.
SELECT queries may be sent to the slave to reduce the query processing
load of the master. Statements that modify data should still be sent to
the master so that the master and slave do not get out of synchrony.
This load-balancing strategy is effective if non-updating queries
dominate, but that is the normal case.
--
brian at brianpuccio.net
GPG Key ID 0xBBD2401F
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.drupal.org/pipermail/development/attachments/20060227/192b6a89/attachment.pgp
More information about the development
mailing list