Re: [vchkpw] mysql-auth replicated databases

2004-04-24 Thread Jeff Koch
Hi Rick: Thanks for the help. We managed to get replication running and it seems to working. We stayed with MySQL 3.23.58 because we were unable to get the upgrade to MySQL version 4 to work. So now we have chkuser-mysql and virus scanning off-loaded to the front-end server. Next step is to off

Re: [vchkpw] mysql-auth replicated databases

2004-04-21 Thread Nick Harring
On Wed, 2004-04-21 at 12:21, Rick Romero wrote: > On Wed, 2004-04-21 at 12:08, Jeff Koch wrote: The replication works like a charm. I have found the occasional problem if the vlog table is replicated, for some reason its very prone to duplicate records. I myself just stopped using this table and m

Re: [vchkpw] mysql-auth replicated databases

2004-04-21 Thread Rick Romero
On Wed, 2004-04-21 at 12:08, Jeff Koch wrote: > 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

[vchkpw] mysql-auth replicated databases

2004-04-21 Thread Jeff Koch
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