Storage Snapshots are excellent tools in arsenal of a system administrator to create quick and consistent backups of their databases and applications. Snapshot is a “picture” of a filesystem at a point-in-time. In most modern snapshot implementations, this “picture” is not a full copy of the data, but rather a set of pointers to the data.

Here is a list of current industry leading snapshot technologies:

• LVM Snapshots: Snapshot capability built into the Linux Volume Manager (LVM) - the default option on a Linux system.

• ZFS Snapshots: Snapshot capability built into the ZFS filesystem on Solaris and OpenSolaris

• NetApp SnapShots: A feature of the WAFL® (Write Anywhere File Layout) filesystem

• Windows VSS: Volume Shadow Copy Service from Microsoft introduced in …

I am happy to announce that the first Workbench plugin written by the community was published recently.Daniel Haas has written a code generation plugin for Propel, a database abstraction layer for PHP. You can download the plugin from Daniel’s blog that can be found here it is published under the GPL. He also provides the necessary steps to install the script. This is amazing in several ways. First, we have not yet published a comprehensive tutorial how to write plugins and scripts for Workbench because we have been fully loaded with other stuff. Vlad did a tutorial on this at the MySQL Users Conference but the Wiki pages have not been written yet. So Daniel took the hard way, figuring out a lot of things all by himself. Second, we are working on a better …

We introduced a new library to use with our update-feature inside Workbench. With the new lib (yassl) it’s possible to use SSL encryption for the authentication/download of new SE releases. This was not possible with libcurl because we’re not allowed to use/bundle openSSL. As this update is included staring with 5.0.22 all SE users will have to download version 5.0.22 manually from the enterprise pages one more time. Please logon to https://enterprise.mysql.com/software/gui_tools.php with your mysql username and password, download the latest release and launch the installer manually. Sorry for the inconvenience.

The parameter DiskSyncSize is a MySQL Cluster parameter and was added in MySQL 5.1.23.

After the amount of stored bytes of data per file, the data node will fsync (flush) the LCP file to disk, even if a fsync is not needed for consistency.
This is done because the OS will otherwise buffer all the writes, and when a fsync is really needed, it can take a lot of time...

Originally this parameter was hard coded. Now it defaults to 4 Mbyte.

The parameter DiskSyncSize is related to the parameters NoOfDiskPagesToDiskAfterRestartTUP and NoOfDiskPagesToDiskAfterRestartACC which are deprecated right now. It does NOT replace the parameter TimeBetweenLocalCheckpoint.

This parameter should not be changed on any OS (with reasonable settings). With ODIRECT it is not used at all.

Thanks to Jonas for the help.

I'm proud to announce that after significant wrangling (just suggesting did the trick, actually ;-), I've found Sebastian Bergmann willing to visit Australia, and teach a 3-day workshop Quality Assurance in PHP Projects. It's scheduled 4-6 August in Melbourne.

Many applications using MySQL are written in PHP... this three-day workshop will introduce PHP Developers to writing unit tests for the backend and system tests for the frontend of a web application as well as managing the quality from development to deployment and maintainance using tools such as PHPUnit, Selenium RC, phpUnderControl, PHP_CodeSniffer, and …

The parameter DiskSyncSize is a MySQL Cluster parameter and was added in MySQL 5.1.23.

After the amount of stored bytes of data per file, the data node will fsync (flush) the LCP file to disk, even if a fsync is not needed for consistency.
This is done because the OS will otherwise buffer all the writes, and when a fsync is really needed, it can take a lot of time...

Originally this parameter was hard coded. Now it defaults to 4 Mbyte.

The parameter DiskSyncSize is related to the parameters NoOfDiskPagesToDiskAfterRestartTUP and NoOfDiskPagesToDiskAfterRestartACC which are deprecated right now. It does NOT replace the parameter TimeBetweenLocalCheckpoint.

This parameter should not be changed on any OS (with reasonable settings). With ODIRECT it is not used at all.

Thanks to Jonas for the help.

I've been a little out of touch lately -- crazy accounting project for school -- but was able to carve out a little time to chat with the guys at Engine Yard who are doing some cool things with Ruby. Engine Yard employs Evan Phoenix, the founder of the Rubinius project. The project aims to deliver a virtual machine for Ruby and will be previewing Rails running on Rubinius at RailsConf 2008 later today. According to Evan, Rubinius is an implementation of a Ruby platform, just like the standard Ruby interpreter, IronRuby, MacRuby, JRuby, or countless other implementations. What's interesting... READ MORE

During the webinar "Highly scalable solutions with MySQL and Memcached" Ivan Zoratti announced that Sun will support Memcached as a part of MySQL Enterprise Support.

You may want to check you the white paper "Designing and Implementing Scalable Applications with Memcached and MySQL"

There is another webinar later on today (Designing and Implementing Scalable Applications with Memcached and MySQL), so if you missed out on yesterdays …

We’re looking for experienced OO-PHP programmers. Read all about it here (in Danish only; sorry ’bout that).