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

Red Hat betas Enterprise Virtualization, partners with HP for SOA. And more.

Follow 451 CAOS Links live @caostheory
“Tracking the open source news wires, so you don’t have to.”

# Red Hat announced that its Enterprise Virtualization portfolio of products is now available for beta testing.

# Red Hat collaborated with HP on SOA.

# David Megginson published mixing GPL and non-GPL: a different perspective. A new take on the MySQL/MariaDB storage engine debate.

# UK Government CIO shed some light on “G-Cloud” plans and how the new open source policy provides an opportunity.

# WAZI: …

It isn’t necessarily immediately obvious how to set up a Cluster on LINUX; this post attempts to show how to get a simple Cluster up and running. For simplicity, all of the nodes will run on a single host – a subsequent post will take the subsequent steps of moving some of them to a second host. As with my Windows post the Cluster will contain the following nodes:

• 1 Management node (ndb_mgmd)
• 2 Data nodes (ndbd)
• 3 MySQL Server (API) nodes (mysqld)

Downloading and installing

Browse to the MySQL Cluster LINUX download page at mysql.com and download the correct version (32 or 64 bit) and store it in the desired directory (in my case, /home/billy/mysql) and then extract and …

There has been a significant increase in interest in the Memcached, the open source distributed memory object-caching system, in recent months, as a number of vendors look to exploit its popularity in Web 2.0 and social networking environments.

Like Hadoop, which has become the focus of a number of commercial plays, it would appear that the time is right for commercialization of Memcached. But what is it, here did it come from, and what are the chances for vendors to rake in serious cash? Here are the details.

What is it?
Pronounced mem-cash-dee, Memcached was originally created by Danga Interactive (the developer of LiveJournal, which was acquired by Six Apart in 2005) to speed up the performance of dynamic Web applications by alleviating database load. Memcached has become an industry standard for improving the performance of dynamic websites.

The code is available from the …