We’re proud to announce the first General Availability build of our database development tool MySQL Workbench. Version 5.1.16 is now available on our download-servers. On our final run towards GA release of version 5.1 we managed to close 13 bugs and a couple of small issues still found in our previous release. Details on latest changes can be found on our Releases Page. Starting with this release, we recommend to switch from your Workbench 5.0 installation right to the new release (if you haven’t yet) - 5.1 is now our current stable release.

The files for different platforms have been pushed to our main server and will be globally available on our mirrors during the next hours. Please get your copy form our Download page:

…

It is no joke that computer hardware has advanced by leaps and bounds over the past decade. 10 years ago, multicore systems were expensive and high-end; today, your grandmother may have one and probably have no clue what she has!

Alas, application software has not kept pace. The Linux OS has done a fair job at being able to leverage some of the power multicore systems offer us, but applications running on them have not. The same can be said more or less for Windows, but it’s been a long while since I did anything systems-level with Windows. But the same issues do apply, however.

We are today with the multicore situation where we were in the 80′s and the 90′s with the multithreaded issues. Back then, CPUs grew support for multithreaded programming, but software — including some OSes — were slow to adopt. The Macintosh, when it was first released in 1984, would only support “cooperative” multitasking when the underlying …

Shortly after I created the initial packages of embedded InnoDB on the OpenSUSE Build Service, Oracle/Innobase released an updated version (1.0.3.5325). In addition to many improvements and bug fixes, they slightly changed the versioning scheme to better indicate what version of the InnodDB plugin their code is based on (see Vasil's posting on the InnoDB Forums for more information).

I've now updated my InnoDB packages on the Build Service to this version as well - please note that the naming scheme of the shared library package has …

There is a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.

If you would like to try this, you can use MySQL SandBox which can launch a MySQL Master/Slave configuration in seconds. You can get started with MySQL Sandbox and Download 3.0.04.

Sandbox setup

$ make_replication_sandbox ~/mysql/mysql-5.1.35-osx10.5-x86.tar.gz
$ cd ~/sandboxes/rsandbox_5_1_35/

On the master

We will use a modified version of the numbers procedure found at …

We’re proud to announce the availability of our 3rd Release Candidate of MySQL Workbench 5.1. This is the last Release Candidate before 5.1 is released as GA. We keep optimizing and improving the functionality and brushing the last rough corners to be able to provide a shiny Workbench 5.1 GA next week. You can find the details as always on this release on our Releases Page.

Head right over to our Download page to give this last development build a try:

http://dev.mysql.com/downloads/workbench/5.1.html

If you encounter any problems, please report them to our bugtracker. Feel free to contact us any time on IRC (irc.freenode.net, #workbench) for any questions or infos.

- The Workbench Team

For some reason, the creation of a mapping to a database table poses a problem for certain people.

This is how it’s done in PDI 3.2.0 or later in the “Table Output” step:

Ogg video available over here

Until next time,
Matt

Peter Lieverdink (also known as cafuego on IRC/identi.ca, engineer on OurDelta builds and for Open Query) has co-authored a book that’s available since Monday. The title is Pro Linux System Administration published by Apress.

These days some people don’t want to bother with system administration, and either hire or outsource. Others want to find out more and do things themselves (home and small office use), and that’s the intended audience for this book.

Oracle/InnoBase announced the availability of the embedded version of InnoDB at this year's MySQL Conference & Expo, but I have not seen a lot of comments or reviews about it so far. Which surprises me, because I think this is a very interesting piece of technology!

In my opinion it might actually hit the sweet spot for application developers seeking an alternative embedded database solution. SQLite is nice and popular, but it seems to have concurrency issues when used in multi-threaded applications. An embedded MySQL …

After a long hiatus, I am happy to announce that mylvmbackup version 0.12 has now been released. This release includes a large number of improvements, minor code cleanups, as well as some new functionality. In particular, I would like to thank Matthew Boehm, Tim Stoop, Baron Schwartz, Ville Skyttä and Ronald Bradford for their contributions.

Some notable highlights from the ChangeLog:

• Removed the absolute path names to external tools (make sure $PATH is correct)
• Added --log-err to the startup options of the recovery instance to avoid cluttering the server's error log
• Added support for hooks written as Perl Modules. (Matthew Boehm)
• Added support for date/time-formatted path names for backupdir and mountdir (Matthew Boehm)
• Backupdir and …

We’ve just released the second RC of the cross-platform version of MySQL Workbench. Version 5.1.14 is now available for download. We closed 5 bugs since last week and worked on more refinements. For the complete list of changes please take a look at our Releases Page.

Please head over to our Download page to give this release a try:

http://dev.mysql.com/downloads/workbench/5.1.html

End of next week we are going to build another RC release before we’re preparing the final GA release of Version 5.1. If you find bugs, please post it to our bugtracker. Feel free to contact us on IRC (irc.freenode.net, #workbench) for any questions or infos.

- The Workbench Team