Someone in the forums recently asked about ways to migrate individual accounts from one ZCS instance to another, so thought I’d share the enlightenment with all. Whether you are going from an on-premise install to a hosting provider, want to create handy archives of old employee accounts, or just need to duplicate mailbox contents of a user; the syntax in this article proves remarkably useful, and applies to all editions.

There are a multitude of comparable RFE’s on addressing this need via different approaches. (Bugzilla entries 19630, 29573, 28443 & 30163 to name a few.) Some want graphical tools to browse data …

A compilation of today's news of interest:

I'll be attending and speaking at the T-DOSE 2008 conference in Eindhoven (NL). In 2006 I talked about MySQL Cluster; this year I'll be talking about Monitoring MySQL. I did it a few weeks ago on the Nagios Conference in Nurmberg (DE) and will continue on that, probably giving more details and examples.Of course, I'll be showing off our MySQL Enterprise Monitor!
The conference spans 2 days, 25/26 October, and I'll be hanging around! Make sure to ask me questions, vent frustration, share success stories, etc..

It's been a week or 2 and some of you may already have heard that PBXT has moved from Sourceforge to Lauchpad.net: https://launchpad.net/pbxt.

There are several very good reasons for the move, not the least of which is that MySQL has already moved to Launchpad, and Drizzle is there too. It simply makes sense for a storage engine like PBXT to be on the same platform.

And check this out, Stewart Smith has already ported PBXT to Drizzle. You will find the tree here: PBXT in …

Vyatta has rocked the networking world by developing the first commercially supported, open source router and firewall solution. Ambitions of changing the rules of the game of a huge industry, come with very critical data - which doubles in size every year! They also come with a very heterogeneous environment:  Fedora, Debian, Red Hat, and Ubuntu - well, as long as it is a Linux distro

Vyatta recognized the need for a formal backup solution to replace the homegrown backup scripts, and chose Amanda Enterprise. Amanda backs up terabytes of Vyatta’s data spread across web sites, e-mail server, source-code repository, databases, and user files. Here is the full story.

Yesterday I saw an announcement in the MySQL internals@ list, about a new storage engine being released. DDengine has created a revision engine, a sort of embedded proxy inside MySQL that keeps track of the changes you do to your data.
The idea is clever. You write to your table, update and delete without any concern, and the revision engine stores your changes in the background.
I wanted to tried the engine on my laptop (Mac OSX), but there was no binary available for this architecture. I contacted the authors and I received prompt assistance until I had the product installed. Unfortunately, it crashes immediately. Well, it's to be expected for a version 0.1.
I then tried on Linux, and also here I received very quick assistance from Peter Benjamin Volk, Project Head at DDengine.
It now works on Linux, …

Introduction

If you are hosting your website with Yahoo Small Business Hosting, you will be forced to use a web based admin tool to manage your MySQL database. In fact, the help page on managing MySQL categorically mentions that “You will not be able to access your database using a desktop client or other tools run outside of Yahoo!”(I bet they don’t read our blog). In this article, I will show you how you can use all the cool and powerful features of SQLyog Enterprise with Yahoo Small Business Hosting. The same concepts can be applied to connect to other hosting providers like Godaddy, Network Solutions etc. which don’t provide direct access to MySQL database.

Step by Step Setup Guide

1. Login to your Yahoo web-hosting and you will land in home page of “Web Hosting Control …

Wasn't EnterpriseDB focusing on replacing Oracle in some cases, with specific Oracle-compatible features tacked onto its PostgreSQL base? This seems like a reasonable thing to do, good for them.

What I'm just amazed about is that EnterpriseDB in public communications and appearances keeps focusing on MySQL. What's the point? This started long ago with a movie on the EnterpriseDB site, featuring sharks - which I believe was aimed at the MySQL dolphin, but my memory may be faulty there.

Anyway, now there's an upcoming broadcast with some high-up person from EnterpriseDB, and the topic is "The great debate: PostgreSQL vs MySQL". No I will not provide links, as I don't think it's a worthwhile topic in this context, particularly if it's initiated by one vendor who has their own (albeit unclear) agenda. The info didn't even tell if anyone else was invited so it could be a very one-sided debate ;-)

It seems …

In part 1 we got the cluster monitoring up and running. Indeed a good step forward into taming Cluster. This time we are going to add process management to our solution - if a node fails (ndbd, ndb_mgmd, mysqld etc) fails, then it should be automatically restarted.

To do this we need:

• initd scripts for each process so there is a way to start and stop the processes.
  
• process management software (i have chosen monit for this).

The initid scripts presented below are templates and you may have to change things such as paths.
For monit we do not need init.d scripts as we will install monit in inittab so that the OS (I live in a Linux world so if you use Solaris or something this may not necessarily apply in …