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.
----
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.
I'll keep you posted.
/Mark
On 18/10/02 6:50 AM, "Chris Hilts" <[EMAIL PROTECTED]> wrote:
>> Before I start a duplicate effort, has anyone been planning or
>> implementing an external configuration mechanism for connecting to the
>> database ? Perhaps expanding dbmail.conf to include these parameters
>> would by feasable.
>
> I admit, it's been a LONG time since I had to change the dbmail
> configuration. As my memory serves, the dbmail configuration is stored in
> the database. Support to read a config file at run-time for the database
> parameters will have to be done from scratch, I believe.
>
> Chris Hilts
> [EMAIL PROTECTED]
>
> (Of course, all this will have changed since the last time I grabbed a
> copy of CVS, and I'm probably completely wrong now)
>
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
