MySQL Server 5.5 Live Backup without "Freezers" on Locktables
Posted on 2014-11-12
i have a Problem: i have installed a Debian wheezy x64 (current Version) with ext4 file System.
here i have running a mysql-server 5.5.
my database size is about 1gigabyte. my mainproblem is the follwing:
under the day we made backups every 30 minutes with the mysql dump command.
so if the Server made a mysql dump, the data freezes for about 20 seconds (i think mysql dump locking the tables).
so now how i can make a backup without this freezers? and without data loss..
thanks, many greets