Hi Adam, Had a friend send me this general info about MySQL and back-ups... hope it's helpful... ----
Here's a good overview of the options: http://tinyurl.com/dazpev Mifos is using the InnoDB storage engine, so you can ignore the parts of the article relating to MyISAM storage engine. AFAIK, the main thing people use for enterprise-ready (aka fast, reliable) backups is this product: http://www.innodb.com/wp/products/hot-backup/ (pricing is here) MySQL 6.0 is supposed to (finally) have support for real backups like the product above. Given the acquisition by Oracle, not sure when 6.0 is gonna come out. Not soon. If the DB is running on Linux (and you're willing to do more work), there are other solutions like using a linux filesystem which supports taking "snapshots" of the disk and storing them for later use. http://tinyurl.com/dmzggq This obviously doesn't work if your DB is running on Windows. > -----Original Message----- > From: Adam Monsen [mailto:[email protected]] > Sent: Monday, May 04, 2009 6:20 AM > To: Mifos Developer Discussions > Cc: Mifos User Discussions > Subject: [Mifos-developer] MySQL backups > > Would anyone using Mifos care to share how they backup their MySQL > database? > > Or, does anyone have any general recommendations for MySQL backups? ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
