Yesterday we (Gerry, Lars, Serg) had a mini-MySQL’er reunion courtesy of us all speaking at HighLoad++. Much thanks to the organizers for bringing us out here so that we could all catch up :)

We had a chat about how SHOW CONTRIBUTORS got into the code of MySQL as we were giving ideas to HighLoad++ organizers to raise money for charity. I distinctively remember it had something to do with a charity auction at one of the older MySQL User Conferences in Santa Clara. This was when we had quiz shows! And it was at the UC in 2006 for a charity auction where all proceeds got donated to the EFF. 

I see than Ronald has it in a …

MySQL Notifier is a quick tool for Windows installations to help you manage your instances.

MySQL Notifier allows quick access to MySQL Instances running on a Windows machine in a handy fashion.

It provides a quick way to start, stop or restart your Windows based instances. It also provides easy access to MySQL Workbench (if you have Workbench installed) for system admin, queries, and configuration. It can also call a window for the MySQL Utilities Shell.

A quick way to start, stop, or restart MySQL Instances.

It will ‘discover’ new MySQL services on your Windows system and add them to the tray.

MySQL …

This article is following the previously published investigation about I/O limitations on Linux and also sharing my data from the steps in investigation of MySQL/InnoDB I/O limitations within RW workloads..

So far, I've got in my hands a server with a Fusion-io card and I'm expecting now to analyze more in details the limits we're hitting within MySQL and InnoDB on heavy Read+Write workloads. As the I/O limit from the HW level should be way far due outstanding Fusion-io card performance, contentions within MySQL/InnoDB code should be much more better visible now (at least I'm expecting ;-))

But before to deploy on it any of MySQL test workloads, I want to understand the I/O limits I'm hitting on the lower levels (if any) - first on the card itself, and then on the filesystem levels..

NOTE …

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.10 server with PHP5 support (mod_php) and MySQL support.

This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

read …

I just made MyQuery 3.5.0 available for download from sourceforge. If you do not know about this program, this is my Windows based MySQL Query editor and database monitor program. And yes, it is Windows only.

It was a long time since I updated MyQuery, but I have been been at it for a long time, but slowly as I haven't had the bandwidth, and I have collected a few things I wanted in this release, but of all those things, many has to wait for now, as decided to add a major feature which did require a fair bit of coding and testing: autocomplete. When editing SQL statements, autocomplete for names of tables, columns etc is really useful, but it is not as easy as it sounds. What makes this a bit complicated are things like the default database (which I need to figure out for anything that is typed), table aliases and separate name …

Developers and DBAs often compare and synchronize structures of their database objects (Tables, Views, Triggers, Functions, Events and Stored Procedures) from Development server to Production server and vice-versa. One can use a schema comparison / synchronization tool to synchronize database (DB) objects.

SQLyog’s Schema synchronization tool is simple and intuitive to use for comparing and synchronizing database objects. It comes with new looks and a Filter feature. Database objects’ comparison is now 100x faster.

Using SQLyog, schema synchronization can be usually done in three easy steps:

1. Choose the databases
2. Pressing Compare will show differences between database objects
3. Execute All button will execute the SQL statements to synchronize selected database objects.

Options provided …

Just in case you missed this, last week I announced that my team is looking for an experienced technical writer. Now the job offer has gone live on the Oracle website. Have a look! That's the EMEA job site, but the position is actually available for Europe or North America. The job offer should appear on the American site soon, too.

If you want to join a great team, or if you know someone suitable who does, don't hesitate to contact me!

Continuent announced today its expansion in France. In a move to increase its presence in Europe and to strengthen relationships with existing and prospective contacts in France and Benelux, Axel Faux and Ludovic Launer have joined Continuent's team of database clustering and replication experts. The new sales office in Paris, France's largest economic center, is a continuation of Continuent's

Read the original article at AirBNB didn’t have to fail

Today part of Amazon Web Services failed, taking down with it a slew of startups that all run on Amazon’s Cloud infrastructure. AirBNB was one of the biggest, but also Heroku, Reddit, Minecraft, Flipboard & Coursera down with it. Its not the first time. What the heck happened, and why should we care?

1. Root Cause

The AWS service allows companies like AirBNB to build web applications, and host them on servers owned and managed by Amazon. The so-called raw iron of this army of compute power sits in datacenters. Each datacenter is a …