[CentOS] realtime backup

Wed Feb 18 12:55:07 UTC 2009
Fabian Arrotin <fabian.arrotin at arrfab.net>

CentOS List wrote:
> Hi,
> 
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?
> 
> Thanks
> 
> regards
> 

Sorry but i see two conflicting ideas in the same sentence : 'realtime' 
and 'every 5 mins' .. ;-)
Why not using a MySQL replication (Master/Slave) between the two nodes ?
And if you don't feel confident about configuring that, why just not 
using Drbd between those two nodes ? realtime replication , whatever 
runs on top of the filesystem (DB, files, Mailboxes, etc ...)

-- 
--
Fabian Arrotin
  idea=`grep -i clue /dev/brain` ; test -z "$idea" && echo "sorry, init 
6 in progress" || sh ./answer.sh