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

 

[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/manual.html#backup.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

 

[Lock Down]

What errors do you get using cron and mysqldump? That works on my 2 gig database in a shared host.