In order to relieve the load from our main mailserver we offloaded chkuser and virus scanning to a frontend mailserver. However, the front-end server is not getting a fast enough response on the chkuser query from the mysql server on the main mailserver and, at peaks loads, has started bouncing mails.
We would like to have a slave copy of the mysql vpopmail DB on the front-end mailserver to service chkuser queries directly. We need to keep the slave database in sync with the master DB and would like to use mysql replication. Can we get some opinions on how best to keep the DB's in sync? Does replication work OK? Do we need to upgrade to MySQL version 4? Or can we get away with rsync?
Thanks in advance for the advice and counsel.
- Re: [vchkpw] mysql-auth replicated databases Jeff Koch
- Re: [vchkpw] mysql-auth replicated databases Rick Romero
- [vchkpw] Convert mySQL passwords to vpasswd.cd... Thiago Anderson Santos