[wp-hackers] Allow Wordpress to use a Slave Database

[Otto]

I'm not sure that reducing the number of queries will help if he's
hitting the MySQL Connection limits (although, of course, super-cache
would certainly help).

I do like the idea of being able to optionally provide a different
connection for cases where you are going to execute select statements
only (reads, basically). But with WordPress, I'm not certain that it
would help a lot with regard to the number of connections. WordPress
does do some updates pretty much all the time, what with the options
table getting updates so often for some plugins and such.

Once again, I wish MySQL was capable of bi-directional replication.


On Tue, Jun 3, 2008 at 6:50 AM, Viper007Bond <viper at viper007bond.com> wrote:
> A handy feature to have, although why not just use an object cache (I use an
> XCache-powered one on my personal blog) or go full static with
> WP-Super-Cache (I use that as well on another site of mine).
>
> Using a persistent object cache will cut your queries in half and using
> WP-Super-Cache will cut them to essentially 0.
>
> On Tue, Jun 3, 2008 at 3:51 AM, Colin Ogilvie <wordpress at colinogilvie.co.uk>
> wrote:
>
>> I filed this as a ticket on trac, but also felt it might be worth emailing
>> it to this mailing list.
>>
>> At work (http://community.plus.net/) we have found that we are sometimes
>> hitting our MySQL connection limits (although we do tweak them). We also
>> have a replication setup where there is a slave database which is idle as
>> Wordpress does not allow you to connect to it.
>>
>> We have been looking at adding the option to use a slave database, and have
>> attached an initial patch to http://trac.wordpress.org/ticket/7081 which
>> we have submitted.
>>
>> We would appreciate any feedback on this from others.
>>
>> Thanks
>>
>> Colin
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
>
>
>
> --
> Viper007Bond | http://www.viper007bond.com/ | http://www.finalgear.com/
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>