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 ...)