Posted by Peter-SexyWing, 07-06-2008, 08:28 PM | Hi all
we have a dual xeon 2.8G +2G ram CPANEL server
normally load is well under2 and stable
we also use Incremental Backup and choose Per Account Only for MySQL backup
This server mainly hosts a big site, whose SQL is 1.2G big
Everytime server is running backup, load burst to 7 and accessing to website hanged. We are thinking to change SQL backup method to Entire MySQL Directory , but was told while it is processing SQL server will be stopped ?? wil Entire MySQL Directory reduce server load while processing SQL backup?
thanks
Peter
|
Posted by activelobby4u, 07-06-2008, 10:25 PM | you could probably try backing up table by table at different intervals of time
|
Posted by Srv24x7, 07-07-2008, 02:04 AM | It won't be a much difference in load even if you choose to backup entire mysql directory. I will suggest you take a look at your cronjob to see if there are any other jobs running at the same interval ?
|
Posted by The Universes, 07-07-2008, 02:44 AM | Is iowait causing the high load or CPU usage?
|
Posted by zuborg, 07-07-2008, 06:36 AM | I would recommend you to use backuping of mysql directory by filesystem snapshots (with appropriate flushing and locking).
Not sure CPANEL supports this method.
|
Posted by Peter-SexyWing, 07-07-2008, 07:46 AM | This is good point, I will check it out, but we use 36G SCSI 10K RPM main drive +160G sata drive for backup, should be no problem on IO though
|
Posted by Peter-SexyWing, 07-07-2008, 08:18 PM | alright, I chcked, it is indeed I/O wait, burtsted to 80% while doing SQL dump
I have SCSI main drive already, what shall I do to improve it then?
RAID?
|
|
Add to Favourites
Print this Article |