On Thursday 17 October 2002 03:32 pm, Mark Mackay wrote: > We're just working with a CVS version from 2-3 days ago to apply two major > changes (which may possibly need to be re-done if Eelco/Roel have made some > major layout changes within) > > 1) Separate read and write databases > > - Send updates/inserts to a master MySQL host > - All selects from a slave MySQL host > (or the master if you're not running replication) > > 2) Config file and command line options > > - focussing primarily on db host assignment via a config file (so if > the slave/master servers go down you don't have to recompile the source to > change the hosts); and probably also the bind IP configs. > > I hired someone to take care of this (I'm too busy) so I'm not sure what > shape it will take. The contract ends today, so hopefully will have > something that we can post to the list Mon/Tue.
Ahh, this will be nice indeedy. I'd so much much more prefer the dbmail.conf actually being used. Querying the confis from the server everytime is yet a performance hit on thr server as it is. > The first point I think would be a really good thing to get into the 1.0 > release (and primarily it's just a few find and replaces to call the > relevant db read/write function); as this means that using MySQL > replication you have a hot backup of your entire database server (I'm > getting a bit nervous now that we have 15G in InnoDB tables). And also > means you can load balance busy sites with multiple slave servers. Now that's a lot of mail. hehe Eric Renfro
