You can keep up with the latest developments in MySQL software in a number of ways, including various blogs and other channels. However, for the most correct (if somewhat dry and factual) information, you can go directly to the source. 

Major Releases 

For every major release, the MySQL docs team creates and maintains a "nutshell" page containing the significant changes in that release. For the current GA release (whatever that is) you'll find it at this location:

https://dev.mysql.com/doc/mysql/en/mysql-nutshell.html

 At the moment, this redirects to the summary notes for MySQL 5.6. The notes for MySQL 5.7 are also available at that website, at the URL http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html, and …

You can keep up with the latest developments in MySQL software in a number of ways, including various blogs and other channels. However, for the most correct (if somewhat dry and factual) information, you can go directly to the source. 

Major Releases 

For every major release, the MySQL docs team creates and maintains a "nutshell" page containing the significant changes in that release. For the current GA release (whatever that is) you'll find it at this location:

https://dev.mysql.com/doc/mysql/en/mysql-nutshell.html

 At the moment, this redirects to the summary notes for MySQL 5.6. The notes for MySQL 5.7 are also available at that website, at the URL http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html, and …

Table of Content

• Introduction
• Prerequisites
  • System information
  • Installed packages
  • Required packages
• Upgrade the first node
  • …

System information before the upgrade:

1- Operating System: CentOS release 6.4 (64 bit)
2- Cluster system consists of 3 cluster nodes (192.168.1.251 "gcservera",192.168.1.252 "gcserverb" & 192.168.1.253 "gcserverc") and Galera Load Balancer (GLB) installed on another server (192.168.1.250 "control").

The following packages are installed on the 3 cluster nodes:

1- MySQL version: mysql-5.5.33_wsrep_23.7.6 (tarballs)
2- Galera provider version:galera-23.2.7 (RPM)
3- MyEnv version: 1.0

Notes:

- For more information about MyEnv myenv.
- You can use the normal mysql start and stop commands if you don't want to install MyEnv.
- For more information about GLB …

Tweet

Over on the codecentric blog I published an article about localizing iOS and OS X applications called "Pseudolocalization for Cocoa Apps". It is probably the first of a few, because it turned out rather long already.

At the first ever CodingSerbia conference in Novi Sad, Serbia, I did an introductory talk about how iOS development works in general, with a focus on Java developers who did not have any experience with either the tools, frameworks or even Objective-C as a language.

The slides can be viewed here:


A recording has been made and published on YouTube:

Percona Server version 5.6.14-62.0

Percona is glad to announce the release of Percona Server 5.6.14-62.0 on October 24th, 2013 (Downloads are available here and from the Percona Software Repositories.

Based on MySQL 5.6.14, including all the bug fixes in it, Percona Server 5.6.14-62.0 is the current GA release in the Percona Server 5.6 series. …

I normally don’t write such posts, but this time I’ll do a little whining. I was looking at MySQL’s Bug#69581, which was also filed against MariaDB as MDEV-5102. With some effort (little for this particular bug), one can find out that Bug#69581’s counterpart in Oracle’s internal bug database is Bug#16862316, and the fix is in revision 5366 in MySQL 5.6.14.

There are two problems, though:

• The fix doesn’t include a testcase. We know, Oracle doesn’t publish testcases for crashing bugs, with a justification that it’s for security reasons. However, this bug is not a …

Today I wanted to take a look at improving the performance of tables that cause performance problems based largely on their size. Some of this advice also applies to databases that are large in-aggregate over many tables, but I always find the individually large table a special-case that is problematic.

What you will normally find is that the speed that the table can be modified will trend down as the size increases. Here is what I am going to call the typical B+Tree index performance over time:

This graph taken from a post by MySQL@Facebook. It shows the performance degradation of inserting one billion rows into a table with insert buffer disabled (not recommended, and used for demonstration purposes only). Note that this is in log scale!

The benchmark is called …