RE: [qmailtoaster] MYSQL help

2006-10-10 Thread Craig Smith
. Are there any concerns running a dump on the primary server every few minutes? thanks again. Craig -Original Message- From: Quinn Comendant [mailto:[EMAIL PROTECTED] Sent: 09 October 2006 17:47 To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] MYSQL help Hi Craig I've tried

[qmailtoaster] MYSQL help

2006-10-09 Thread Craig Smith
Hi there, I'm currently working on a setup and scripts that will give our company a failover server that we can immediately switch to in the event of failure without clients ever knowing it was off. I am planning of putting this in the wiki if people are interested. As part of my solution I am

Re: [qmailtoaster] MYSQL help

2006-10-09 Thread Quinn Comendant
Hi Craig I've tried setting up replication before but was frightened by its complexity. I might suggest just using mysqldump. The vpopmail table should not be updated that frequently (only when accounts are added/edited/deleted), is probably not too large (how many users?), and your second

Re: [qmailtoaster] MYSQL help

2006-10-09 Thread Michael Handiboe
Quinn Comendant wrote: I might suggest just using mysqldump. The vpopmail table should not be updated that frequently (only when accounts are added/edited/deleted), is probably not too large (how many users?), and your second server is not live. So copying the vpopmail table every ten

Re: [qmailtoaster] MYSQL help

2006-10-09 Thread Mark Samples
Craig Smith wrote: Hi there, I'm currently working on a setup and scripts that will give our company a failover server that we can immediately switch to in the event of failure without clients ever knowing it was off. I am planning of putting this in the wiki if people are interested. As