I recently got a reminder mail to vote for the Sourceforge.Net 2008 Community Choice awards. Going through the list of finalists, I realized how many of these support MySQL as the database backend. It truly amazes me when I look at the wide range of available OSS applications today as well as how advanced many of these have become! More and more commercial applications can nowadays be replaced with Open Source alternatives/equivalents. And many times, MySQL is used to store the applications' data. This is a great trend!
After looking through the list, I spent a few minutes to add the relevant applications to the Project list on MySQL Forge. This section of the Forge is supposed to become a complete, "one-stop" directory of Open Source projects and applications that support or work with MySQL. You can tag, comment and vote on entries as well as just browse through the list. If you have not looked at it yet, make sure to stop by next time you are searching for a particular solution!
Do you have a favourite Open Source application that supports MySQL and is missing from the list? Consider adding it - it only take a few minutes! Thanks for your support - your contribution is appreciated!
I am happy to announce that a new version (0.9) of mylvmbackup has been released. This is the first release since the source code has been moved from Subversion to Bazaar and is now hosted on Launchpad.net. I would like to thank Robin H. Johnson and Patrick Hahn for providing the patches that contributed to this new release!
mylvmbackup is a tool for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.
From the ChangeLog:
- Applied patch from Patrick Hahn: provide an option to call external scripts/applications (hooks) at various stages of the backup process. See the man page for instructions
- Added options "--skip_hooks" to disable the execution of hooks and "--hooksdir" to define the location for these (default is /usr/share/mylvmbackup)
- Updated documentation: added new options and instructions on how to use hooks
- Applied patch from Robin H. Johnson: Full support for an rsync:// service as the backup destination. If you include any path fragments with the rsync module name, they must already exist!
- Updated documentation to reflect these changes
- Updated TODO
You can download a source tarball or RPM from the project home page. Additional packages for various Linux distributions can be obtained from the openSUSE Build Service. Packages for Gentoo and Debian should appear shortly, too.
Enjoy! Please let me know how mylvmbackup works for you, either by posting to our mailing list or by submitting a bug report. Thanks!
