homepage Welcome to WebmasterWorld Guest from 54.237.184.242
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Backup of Massive MySQL InnoDB Databse
Ian Cunningham




msg:1579997
 12:37 pm on Sep 11, 2005 (gmt 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?

 

txbakers




msg:1579998
 2:33 pm on Sep 11, 2005 (gmt 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.

Ian Cunningham




msg:1579999
 3:03 pm on Sep 11, 2005 (gmt 0)

Have you tried this for really large DB's before?

txbakers




msg:1580000
 3:51 pm on Sep 11, 2005 (gmt 0)

not that big

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved