FYI, I changed two parameters on Planet MySQL to accomodate the current flood of postings coming from the MySQL Conference attendees: we now display the last 25 posts (instead of 10) on the front page, the RSS feed now includes the latest 100 posts (instead of 50). This should make sure that posts actually make it to the front page for at least some time, before they fall off again.
Please keep up the good blogging!
I am happy to announce the release of mylvmbackup version 0.8. mylvmbackup is a tool for quickly creating backups of a 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.
Below is the list of changes since version 0.6. You may wonder what happened to version 0.7 - it had a rather short life cycle as I was informed about a bug that I fixed quickly before I made a wider release announcement of 0.7.
Yesterday, Drupal 6.0 was officially released - check out this screencast to get a 29-minute tour on the new features in this release.
We'd like to congratulate the Drupal Developer Team and Community for reaching this milestone and are happy that the MySQL Server continues to serve well as the database backend for this awesome content management platform!
I had the pleasure of evaluating and reviewing a previous release of Drupal for the Open Source Content Management System Award from Packt Publishing and it has been one of my favourites.
Keep up the good work!
Version 0.6 of mylvmbackup, a script to perform backups of a MySQL server using Linux LVM snapshots, has now been released.
In addition to various code cleanups and documentation improvements, many new features have been added to this version. I'd like to specially thank Robin H. Johnson from the Gentoo project for contributing many of the improvements to this release!
This certainly took longer than expected, but here are some pictures that I took during our MySQL Developer Meeting in Heidelberg, Germany last month. Enjoy!
Just a quick heads-up - I just commited a change to the Planet MySQL code that slightly modifies how the RSS feed is being created: now the author name is put in front of each posting's title, similar to how many other feed aggregators mark the different articles. I hope you find this change useful, let me know if you experience any problems or have any other suggestions for improvements. Thanks!
Today, I again spent about an hour to revert changes made by
spambots on various MySQL Forge Wiki pages. As I was really sick of
this, I now installed a new plugin: reCAPTCHA - this will hopefully raise the bar for
spambots to create new user accounts automatically for spamming
the Wiki. If you are a registered user already, you will probably
not notice the change - by default, CAPTCHAs are only displayed
on the following events:
Let's hope it helps! Please let me know if you still experience spam problems on the Wiki.
Eric
Bergen from Proven Scaling (which I had the pleasure to meet
in person during the MySQL Conference & Expo in Santa Clara last
month) was kind enough to send me a patch for the mylmbackup
tool, which justifies a new release:
Attached is a patch file for mylvmbackup that adds the ability to use
lvm version 2 and perform innodb recovery on the snapshot prior to
creating a tar ball. The option is named --innodb-recover.
I've also fixed a bug with default value handling for command line
options. In version 0.4 if a config file was specified default values
in the script were all changed to blank. This means that the config
file had to supply values for every variable instead of just the
values that need to be changed from default.
…
[Read more]
Congratulations to Warren Young and the other developers that
maintain the MySQL++ C++ wrapper around the MySQL Client
libraries: version 2.2.0 has just been announced and boasts a wide range of changes.
Here's a description of MySQL++ from the project web site:
MySQL++ is a C++ wrapper for MySQL's C API. It is built around STL principles,
to make dealing with the database as easy as dealing with an STL
container. MySQL++ relieves the programmer of dealing with
cumbersome C data structures, generation of repetitive SQL
statements, and manual creation of C++ data structures to mirror
the database schema
With great pleasure I today noticed that we finally have daily
snapshot builds of all current versions of the MySQL server
source trees (4.0-5.1) available on http://snaps.mysql.com/ again. Unfortunately this
has not been the case for quite some time - a few issues that
caused the 5.0 and 5.1 snapshot builds/tests to fail have now
finally been resolved. I also made some changes to the build
script that performs the snapshot builds, e.g. to use the
Perl-based test suite where available instead of the Shell-based
one, which is going to phased out in 5.1 anyway. Let's hope that
from now on the snapshot builds will now be available more
frequently again, I'll keep a close eye on that.
Sorry for the long delay, I know that some of you depend on
receiving updated source tarball snapshots on a regular basis
instead of having to use the free BK client...