Welcome to WebmasterWorld Guest from 54.196.232.162

Forum Moderators: open

Message Too Old, No Replies

Backup of Massive MySQL InnoDB Databse

     
12:37 pm on Sep 11, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 30, 2003
posts:81
votes: 0


I'm currently running a site with a huge 20GB InnoDB MySQL database on Windows 2003/IIS. My method of backup is to simply stop the MySQL service and make a copy of the "data" directory. However, this results in downtime and isn't easily automated.

Does anyone have a better solution so that I could make a constant backup whilst live? I can't afford the InnoDB live backup tool, but there must be other ways around it?

2:33 pm on Sept 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


I use something called PeerSync which can read open files for backup. It's about 98% accurate as far as I can tell. The best result is to shut down and copy, but the PeerSync has worked for me.

Then, once the copy is made, I don't have to shut down to take it off site.

3:03 pm on Sept 11, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 30, 2003
posts:81
votes: 0


Have you tried this for really large DB's before?
3:51 pm on Sept 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


not that big