Here are the minutes of the server team meeting. They can also be found online with the irc log here.

Meeting Actions

• Daviey to submit UDS-O topic for translations and docs
• jamespage to helpout with verification of euca-dhcp bug
• jamespage to discover process/location for fixing ubuntu server documentation

Review ACTION points from previous meeting

• Daviey to talk with wider docs team regarding translations (deferred, carry over)
• Daviey to talk with docs team about new submissions (New documentation for cluster stack)
  • Daviey has discussed this with the documentation team; most Ubuntu documentation is facing the same issue that the server documentation set is (i.e. lack of resource).
  • [ACTION] Daviey actioned to raise a UDS-O …

Previously in the backup series:

Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup

This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and …

In MySQL 5.6 we’ve added a new feature that closes and unloads table instances from the InnoDB internal data dictionary, once a user configurable threshold is reached. This ends the situation where you could have hundreds of megabytes caching rarely used entries until the server was restarted and will be particularly appreciated by hosting and software as a service providers.

For this we’ve used an existing MySQL config variable table-definition-cache.  This cache limit is a soft limit. This means that if the user has more than table-definition-cache tables open then InnoDB will not force eviction of the table from the InnoDB data dictionary …

The O'Reilly MySQL Users Conference and Expo is just a few days a way! It's April 11-14th in Santa Clara, CA. If you haven't registered, you can still get 20% off your registration using SkySQL's discount code SKY.
As sponsors of the event, SkySQL will be out in full-force at this year's conference. Our executives and our team of MySQL® database experts will be sharing their insights and know-how during the speaking program. You can view a complete list of SkySQL engagements at this year's conference here.
Don't miss SkySQL's Reference Architecture Partner Panel on Wednesday, April 13, 11:55AM, Ballroom H. Kaj Arnö, executive vice president of products for SkySQL will lead a panel of strategic partners including Calpont, Linbit, ScaleDB, Webyog and Zimory in a discussion of SkySQL's Reference Architecture for deploying data infrastructure …

I am glad to announce our brand new website today (www.severalnines.com).

The goal of the company is to make it easy for database developers to build their clustered database platforms, either on-premise or in the cloud.

We invite you to explore the new resources on the website (white papers, videos, new configurator for MySQL Replication, new cluster configurator with cloud options, etc.).

It's been long known that Galera optimistic replication and enterprise-size databases are a match made in heaven. Today we're going to get a little closer to testing this statement.We'll have look at how Galera can scale out Sysbench OLTP complex 60 million rows workload in EC2. This is a first proper benchmark for 0.8 series and also the first benchmark of MariaDB/Galera port, so I'll start modest, just to see how it goes. I chose m1.large instances with 7.8Gb of RAM for cluster nodes and c1.xlarge instance for a client — I don't want the client to be a bottleneck.

For comparison I have also measured performance of a stock standalone MariaDB 5.1.55 server. I used the standard my.cnf that comes with MariaDB Debian package with the following alterations:

max_connections=1024
innodb_buffer_pool_size=6G
…

It's been long known that Galera optimistic replication and enterprise-size databases are a match made in heaven. Today we're going to get a little closer to testing this statement.
We'll have look at how Galera can scale out Sysbench OLTP complex 60 million rows workload in EC2. This is a first proper benchmark for 0.8 series and also the first benchmark of MariaDB/Galera port, so I'll start modest, just to see how it goes. I chose m1.large instances with 7.8Gb of RAM for server nodes and c1.xlarge instance for a client - I don't want the client to be a bottleneck.

For comparison I have also measured performance of a stock standalone MariaDB 5.1.55 server. I used the standard my.cnf that comes with MariaDB Debian package with the following alterations:

max_connections=1024
innodb_buffer_pool_size=6G
innodb_log_file_size=512M

Galera nodes also add

…

I recently worked on a customer case where at seemingly random times, inserts would fail with Innodb error 139. This is a rather simple problem, but due to it’s nature, it may only affect you after you already have a system running in production for a while.

Suppose you have the following table structure:

CREATE TABLE example (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
fname TEXT NOT NULL,
fcomment TEXT,
ftitle TEXT NOT NULL,
fsubtitle TEXT NOT NULL,
fcontent TEXT NOT NULL,
fheader TEXT,
ffooter TEXT,
fdisclaimer TEXT,
fcopyright TEXT,
fstylesheet TEXT,
fterms TEXT,
PRIMARY KEY (id)
) Engine=InnoDB;

Now you insert some test data into it:
mysql> INSERT INTO example
-> VALUES (
->   NULL,
->   'First example',
->   'First comment',
->   'First title',
->   'First subtitle',
->   'First …

Has there been a situation when you needed to perform some serious maintenance work on your db server, and you just don't want anyone at all to connect to the db server?

Here's a one liner:

set global init_connect="kill connection_id();"

(I should have posted this 6 days ago)

Introducing MySQL Workbench Utilities
One of the many new things that is being introduced during the Collaborate 2011 and 2011 MySQL Users’ Conference are some great new additions to some of the external tools for managing MySQL servers. One of those tools receiving updates is the MySQL Workbench.

One of the jewels in a long list of new features is the addition of new command-line utilities to help you administer your servers. The new feature is called MySQL Workbench Utilities. It is a package of easy-to-use utilities for maintenance and administration of MySQL servers. These utilities incapsulate a set of primitive commands bundling them so that you can perform macro operations with a single command. Some of the key features in MySQL Workbench Utilities include:

• Plugin for MySQL Workbench 5.2.31
• Available under the GPLv2 license
• Written in Python
…