mysql hotcopy scripst

[bhanuprasad1981]

any one know any good mysql hotcopy scripts which can run by cron , i have large databses around 20 gb dumping them takes really long time killing all sites on server

bhanuprasad1981 Reviewed by bhanuprasad1981 on 9th Oct 2011. mysql hotcopy scripst any one know any good mysql hotcopy scripts which can run by cron , i have large databses around 20 gb dumping them takes really long time killing all sites on server :( Rating: 5

[onel0ve]

20gb mysql dump by cron your server will get down when cron will run

[supportex]

Base 20 GB requires a special approach to support and storaging. Maybe you can reduce size your database. But in any case it is better to use storage engine with fewer locks, such as InnoDB.

[bhanuprasad1981]

its not single db of 20gb i said "databases" , sites i host are mostly vb ,using innodb in vbulletin "shared hosting" is welcoming headache.

[Lock Down]

Here is a link http://www.innodb.com/doc/hot_backup...p.uncompressed

I personally backup first then compress. Saves on overhead. And the risk of no backup at all is lowered.

[Lifetalk]

Have you considered using an SSD drive to host your databases? That way you'll have better disk IO throughput and it should have a relatively low impact on the server overall.

[bhanuprasad1981]

my dc doesn't offer ssd drive more my server can hold 2 disk only , i already use both slots

[supportex]

As a variant you need change server with RAID 10 or SSD. It is much improve disk I/O. With bases of this size is a significant improvement.

[bhanuprasad1981]

as i mentioned above too my dc offer only sata disk no other fast disk available

[Loonycgb2]

best way to approach this is to use a script like bigdump that wont upload but download and make it do like each database will dump at a certain amount of mb or gb then do a continue on script...

Basicly something that can dump partial dumps of each database to do multiple dumps then join the dumps