When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised because in most cases, we only suggest to change a few settings even though hundreds of options are available. The goal of this post is to give you a list of some of the most critical settings.

We already made such suggestions in the past here on this blog a few years ago, but things have changed a lot in the MySQL world since then!

Before we start…

Even experienced people can make mistakes that can cause a lot of trouble. So before blindly applying the recommendations of this post, please keep in mind the following items:

• Change one setting at a time! This is the only way to estimate if a change is beneficial.
• Most …

As announced last month, MySQL Connect will this year be aligned with Oracle OpenWorld and run from Monday September 29 to Thursday October 2, 2014, in San Francisco.

The MySQL Connect and Oracle OpenWorld Calls for Papers will also open at the same time, and you will most likely be able to submit your sessions between March 4 and April 8 (dates subject to change).

While you will have 5 weeks or so to actually submit your talk proposals, you can already prepare your submissions NOW in order to be ready to submit then, and here is the key information you need to do so. In order to submit a session, you will need to provide:

• Title
• Conference session type: This can be either a conference session (1 hour), a Birds-of-a-Feather session (1 hour), or a tutorial (2,5 hours). You are …

What is it about?

I used to do some benchmarkstuff and blogged about it on my blog written in German. Im going to do testings and benchmarkings again:)

We are going to have a look into ‘benchmarking’ a 3-node Galera Cluster. The application (sysbench) is on a separate node accessing one node of the cluster. This would be the case in a i.e. VIP setup.

Setup

3 Galera Nodes

• Virtual machines (OpenStack) provided by teuto.net
• VCPU: 4
• RAM: 4GB
• OS: Centos 6.4-x86_64
• MySQL-server-5.6.14wsrep25.1-1.rhel6.x86_64
• galera-25.3.2-1.rhel6.x86_64

Separate sysbench node

• Same specs as the Galera nodes
• sysbench 0.5
• oltp test on 5 tables 1000000 rows each (ca. 1.2GB)
• A run took 60 seconds

Last Wednesday, I spoke at the San Francisco MySQL Meetup on the topic of changes coming in MySQL 5.7 (and later).  We actually went through two different slide decks; the first on features being considered for deprecation in MySQL 5.7 (or later), and the second set providing a brief overview of the new features and benefits already introduced in MySQL 5.7 via the development milestone releases (DMRs) published to date.  A big thanks to the entire SF Meetup group, and in particular the organizers (Erin, Mike and Darren), for having me.  The event was streamed and recorded, and you can view the full presentation on YouTube.  The slide deck can be found here.

The discussion around proposed deprecation was good, and this blog serves to document my own notes about what …

I’ve just finishing converting my blog from Jekyll to WordPress.

There were a couple of features I was looking for (such as being able to schedule upcoming posts), but the real reason is that I want to be able to use MySQL 5.7 DMR3 against a tool that I interact with almost every day.

Or as this is more informally known, I wanted to eat my own dogfood:

I now have:

• WordPress 3.8.1
• MySQL 5.7 DMR3
• sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
• All InnoDB Storage Engine
• Disqus comment engine (comment if you think this is cheating)
• “Markdown on Save Improved” plugin.

I apologize for broken images and URLs changing slightly (which will …

This article describes in step by step fashion a guide on how to install and configure a SSH server in a MySQL server running on Windows using FreeSSHd. 

In the previous article, we learned how you can design your database schema so that many customers can share one database and one set of tables. The examples I used were fairly simple: they consisted of single tables or simple hierarchies like the order and line item tables. In those examples, you had a single tenant id that segmented the tables. Now I’d like to introduce the idea of hierarchical segmentation. This is a pretty big term for the idea of allowing customers to see data based on where they are in a hierarchy, like an org chart.

Let’s say you have three sales teams each with its own manager for three regions in the US: East, Central, and West. A salesman in the East only gets to see his own prospects, while the East sales manager sees the prospects of the entire East sales team. At the very top, the VP of US Sales can access the …

We are nearing the one-year anniversary since MySQL 5.6 went GA – which is typically a good time even for the most conservative users to start thinking about upgrading. At this point there is a fair amount of practical use and experience; many bugs have also been fixed (1991 to be exact according to Morgan Tocker).

We also know that MySQL 5.6 has been used in some very demanding environments on a very large scale, such as at Facebook. We also know from the Facebook team, after kindly sharing their upgrade experiences, that it takes a lot of work to upgrade to MySQL 5.6. That’s where Percona can help!

In my webinar this Wednesday, “ …

I have spent some time thinking about and working on a project that went public on GitHub at the beginning of this year. That project is called MaxScale and is primarily a proxy server for MySQL/MariaDB databases, although it can be something much more than this. The obvious and often asked question is why do we need another proxy? I want to try to give you a flavor for what MaxScale is and why I think there is a need for a tool like MaxScale.

The architecture of MaxScale makes it different from your average proxy

• MaxScale has awareness of the content it is shipping.

read more

I have spent some time thinking about and working on a project that went public on GitHub at the beginning of this year. That project is called MaxScale and is primarily a proxy server for MySQL/MariaDB databases, although it can be something much more than this. The obvious and often asked question is why do we need another proxy? I want to try to give you a flavor for what MaxScale is and why I think there is a need for a tool like MaxScale.
The architecture of MaxScale makes it different from your average proxy

• MaxScale has awareness of the content it is shipping.
• As well as being aware of the content the proxy is shipping it is also aware of the configuration and state of the servers to which requests are proxied.
• It provides plugin modules that can be used to implement the routing logic, supported protocols, authentication methods, monitoring and filters.
• The implementation is a …