The Wall Street Journal and the San Francisco Chronicle have both written about how high tech companies in Silicon Valley are being much more frugal with investors' money than during the internet boom of the late 1990s.  Not surprisingly, just about every startup I know is using open source, whether it's well known companies like Digg, FaceBook, Linden Lab, or newer entrants like YouSendit, Soonr, …

Werner pointed us to Media Temple's entry on how to Scale MySQL in a large scale hosting environment. The short summary. Put them all in a virtual container and isolate them.

To make life a little easier at home and work I've put together a simple enough script that is run by cron to tally up statistics like: Innodb_data_reads, Innodb_data_writes, Qcache_hits, Qcache_inserts, Questions, Open_files and Open_tables over time (I sample every hour) with the ability to easily expand and add your own `show status` variables.

Next I'll create some nice graphical interface so it's more obvious how the server or cluster is running. You can grab the script over at my CV hosting. Note that actual client writes in a master master environment would be (writes / number of servers) roughly, very roughly. If you have any ideas for countering this please let me know.

Enjoy.
--
Copyright 2006-2008 Andrew Rose [rose.andrew@gmail.com] [andrewrose.co.uk]

I just learned from my colleagues in our Dublin office that Mårten Mickos, CEO of MySQL AB will be visiting them this coming weekend. They would like to take this opportunity to arrange a MySQL User Group Meeting, which will take place on Saturday, 27th of January, 18:00 o'clock in their offices:

MySQL Ireland,
Ground Floor, Misys Building,
Eastpoint Business Park,
Dublin 3
Ireland

This is your chance to meet and talk with Mårten and other MySQLers. There will also be free food and drinks and most likely a tech talk about MySQL (details will follow). So if you are located somewhere around Dublin, make sure to attend this event!

Thanks to MySQL, and in particular Jay, for giving me the opportunity to talk about PBXT at the up-coming MySQL Conference in April. I will be presenting a session with the title: PrimeBase XT: Design and implementation of a transactional storage engine.

Topics include the design of XT and how it differs from conventional implementations, experience with implementing storage engines, surprises and gotchas, and performance. So I think this talk will be of interest to both end-users and other developers of storage engines.

See you there!

If you ever get something like this:

bk clone -lq ndb bug25567

clone: unable to readlock /home/stewart/Documents/MySQL/5.1/ndb

then try this:

bk unlock -s

to remove stale locks.

I have no idea how anybody is meant to come to the command from the error message… blindly guessing ‘bk help unlock’ worked for me though.

In both Oracle and MySQL, you can do:

create table T1 as select * from T1

This CREATE TABLE AS statement basically clones table T1 with its structure and data in T2. This can be pretty handy at times.

The equivalent of that in Sql Server is SELECT INTO. For example, you can do:

select * into T2 from T1

to achieve similar results.

We just published the results of Amanda usage survey and I want to share my personal observations.One of the most inspiring findings is that 95% of respondents would recommend Amanda to a friend. The Loyalty expert Fred Reichheld would be very impressed with such a result. The overall satisfaction with Amanda is also highlighted by the fact that 70% of respondents have been using Amanda for more than 2 years. People use software for such a long time only if it does the job well. Many users reported that Amanda was up to the task recovering files in most critical situations.

I think it is just great that more than 60% of users provided suggestions for new functionality.

Working with Calvin today I took some changes that Trudy had made to ha_example and a couple of fixes Brian Miezejewski made to the skeleton tree and pushed them.

You can download the skeleton here:
http://hg.tangent.org/skeleton-mysql-engine?ca=tip;type=gz

The skeleton is a "one stop startup" for creating a storage engine under MySQL. It has all of the moving parts for an autoconf project setup for you and it includes the example engine to play with. This is not an official project at MySQL just a nice have for people who are interested in getting up and running with a new storage engine quickly.

Calvin is looking at adding support for Windows for plugin builds so that Windows developers can quickly come up to speed in developing engines.

It will make Microsoft's job a bit easier when they …

I recently had a chance to chat with Nora Denzel, former Senior Vice President and General Manager of the Software Global Business Unit of Hewlett Packard, to talk shop about IT operations management and open source's role / opportunity in the space. Here's a snippet of the QA.

Open Sources: How big is the IT monitoring/management space today? Who are the major players that occupy it?

Denzel: In 2006, Gartner released a study that pegged the IT operations management software market at about $7 billion a year with more than 50% of the number going towards IT infrastructure monitoring and management. The dominant legacy players that offer proprietary monitoring solutions are the usual suspects - HP OpenView, IBM Tivoli, CA Unicenter, and to a lesser extent BMC Patrol. Their software is filled to the gills with features, which often goes unutilized I'd like to point out, and is very expensive.

Open …