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

[Viper007Bond]

Oh, right, connections not queries.

I really gotta stop writing e-mails at literally 4 in the morning...

On Tue, Jun 3, 2008 at 6:53 AM, Otto <otto at ottodestruct.com> wrote:

> 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/7081which
> >> 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
> >
> _______________________________________________
> 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/