On Wed, Jun 16, 2004 at 09:16:52AM +0400, Vinay wrote: > Thanks Brian > but i'm on Red Hat enterprise server so i wouldn't be able to use the > Features of FreeBSD and restarting the server is not a solution for me > as i need to be able to perform hot backup. > One of my solutions was to bump the database in a text file. this wroks > fine for small tables but with lager one this takes too > much time and somtimes freezers the server.
Next trick: Replication. You _can_ afford to temporarily turn off the slave server for backups, replication will pick back up when you restart. This could possibly avoid using snapshots, if you could have so few transactions that you could afford to keep the slave server offline long enough to dump. And since this would require a second server, if you _do_ need snapshots, you'll have the opportunity to research and implement options, Linus-based or otherwise. > V!nay -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
