On Tuesday, November 12, 2002, at 09:02 AM, Sebastian Mendel wrote:
Hi,First, you should probably read this: http://cr.yp.to/qmail/sendmail.html
im running an sendmail-server with about 100 domains and 5000 users with pop3 and smtp only (growing)
now i have set up a machine as qmail-toaster (bills qmail-toaster)
is there an easy way, or any known document how to migrate the mailboxes from one machine to other?
the users and domains are already migrated!
It's not vpopmail specific, but addresses many issues. I don't know of any vpopmail specific migration document.
If you have to migrate the mailboxes, you should probably get a mbox to Maildir conversion tool. I think there's one on qmail.org.
Other than that, I'd probably move slowly, like a few domains at a time. As you get used to any unexpected issues, you could do more at once.
The main performance benefit is for large installations, say over 10K mailboxes in a single domain. This is because at this scale, cdb updates get very slow. MySQL updates do not. But cdb lookups are still slightly faster than MySQL lookups I'm told (I've never run my own benchmarks).and one more:what are the advantages of using mysql instead of cdb, are there any?
MySQL also has replication. Meaning you can have a "read only" server that mirrors the main mysql "update" server, offering some load balancing. Right now, it only supports one "slave" mysql server. But I setup a small cluster a while ago that had about 45K users, and needed Free Radius to authenticate off of the MySQL server too. So we setup a second MySQL slave that was only accessed by Free Radius, while vpopmail accessed the other slave and the master "update" server. This worked really well.
Lastly, my storing information in MySQL, it's easy for other applications to access the same information, i.e. a provisioning system.
But unless you need any of these things, I recommend using cdb. It's one less "point of failure", and is plenty fast.
(and thx for the help with the max. user name)
No problem. Regards, Bill Shupp
