Hi, We're using dbmail together with MySQL. Since our database is quite large and we have a lot of users we want to spread our load a little bit. We have setup our database in replication (master/slave) mode. Then what we want to do is force all read (select) activities to our slave (slaves) and all write (delete, update and insert) to our master database. I've created a patch which does this (only MySQL). What you need to do is #define the READ_DATABASE parameter in "db.h". Then there are some addition parameters to be set in "dbmail.conf" (read_db, read_user etc.). If READ_DATABASE isn't defined dbmail should work as normal, i.e use only one database.
I did create a patch earlier and sent it to the list, but it's not in the new release so it's probably nothing that people are interested in? Still we are using it so I send it again... (The patch version is the cvs from 2002-12-05) Have a nice day! /Klas [EMAIL PROTECTED]
db_replicate.patch
Description: Binary data
