THIS BLOG POST GIVES WRONG ADVICE. DON'T DO THIS!

As the zones use ZFS as root filesystem it's easy to do a zfs snapshot/clone to reproduce a zone. The different zones have only one difference: They differ in /etc/nodename, they have different rootpaths and they have different IP addresses.I wrote a script to read from global's /etc/hosts the ip address. Zonerootpath is /zones/zonename and /etc/nodename must contain as well. The name of the zone is always identical to the hostname of the zone. That rule is not from OpenSolaris but from me.  ;-)
Here is my script: Beware: I hate to do a lot of checking. This is not for general use...
#!/bin/bash
echo "Creating zone $1 from zone TEMPLATE"
echo check if $1 does not already exist...
zoneadm list -cv | grep $1 && exit -1

echo -n "Retrieving TEMPLATE's IP: "
TEMPLATE_IP=$(grep TEMPLATE /etc/hosts | nawk '{print $1}')
…

There is a big event coming: Cebit!And with that I took the task to implement a demo for MySQL Enterprise Monitor to show at the Sun booth. So I need a machine for the enterprise monitor and some machines to run MySQL databases. After all I need something to monitor. So the setup will be an Ultra 24 desktop machine installed with OpenSolaris 2008.11 . For every machine I will install a zone to run a separate database and one zone to run the enterprise monitor.
So here is my first round of experiences: Installing a template container on OpenSolaris and cloning …

I've got a sprint scheduled now for PyCon 2009. I can only be there for the first day of sprints. If there's enough interest, we can probably find a way to sprint earlier during some of the open space session; or it can continue after I'm gone.

PyCon 2010 will be in Atlanta, GA, which is a lot closer to home, but not close enough that I can avoid lodging expenses.

MySQL Connector/Net 6.0.0, a new version of the all-managed .NET driver for MySQL has been released.  This is an alpha release and is intended to introduce you to the new features and enhancements we are planning.  This release should not be used in a production environment.

We had three major goals with this release.  Speed, Entity Framework support, and a better Visual Studio experience.  I'm happy to report that we have met all three.  Please see the complete list of changes below.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

• Massive speedups.  We …

After reading Alex’s blog post on generating graphs using google’s graph API I decided to do something similar for MySQL. I created a stored function that takes a height, width and a graph type from the list of available graph types in the graph API. The function returns a url to a google graph that [...]

So I have started training to get fit enough to gracefully reach the top of Kilimanjaro in 2009.
Information on the various routes here.

Here I will keep a log of certain walks I do, and their timings.
Note that time_down usually includes time spent at the summit.

+------------+------------+------------+-----------+------------+------------------------------------------------------+
| date       | start_time | time_there | time_back | time_total | venue                                                |
+------------+------------+------------+-----------+------------+------------------------------------------------------+
| 2008-12-27 | 16:37:00   | 00:47:00   | 00:32:00  | 01:19:00   | Lions Head …

I was testing up our latest Waffle release when I saw this horrid latency, average in the 12+ms range.  So I decided to dig a bit deeper today:

i’ll start with a Single threaded test on the ec2 setup I was complaining about, this is running waffle 0.4 and memcached 1.2.5.

This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.

Let’s start with the bad news first. The relational database is doomed. Or is it? That is the line of inquiry taken by the item by Tony Bain on ReadWriteWeb. “Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud. One key message this sends is, ‘if you want vast, on-demand scalability, you need a non-relational database’.  . . .  Is this a sign that relational databases have had their day and will decline over time?”

Whether or not you believe that your beloved relational DB’s days are numbered, you will be …

Luckily we are still in alpha for the MySQL Proxy which allows us to change the API from time to time.

One of these changes is now merged to trunk and will end up in 0.7.0 which will be packaged soon. Kay knows more.

As talked about in my previous article we exposed more information for the address objects:

• each socket now has a .src and a .dst address
• each address has a human readable .name (previously known as .address in the socket)

The main reason for exposing this information was a mail from a sjmudd:

I want to route all traffic through the proxy for analyzing but still want to be able to route the traffic to several backend servers. For each backend server I would set up a virtual address on the proxy-server and have a …

Hello,

I am pleased to announce that we run an informative webinar during Australia and New Zealand business hours!  In this webinar, we will explain about MySQL 5.1 and other new features which can improve your database performance.  So check it out!

【Webinar Summary】

• Title:

• Boost Performance with 5.1 and Query Analyzer (ANZ)

• Date:

• Wednesday, March 4th, 2009
  10:00 am in Sydney time
  12:00 pm in Wellington

• Presenter:

• Robin Schumacher, Director of Product Management, Sun MySQL
  Rob Young, Senior Manager of Product Management, Sun MySQL

• Register:

…