This is the blog of the MariaDB Foundation in particular and the MariaDB project in general. It is used to announce new MariaDB versions, for posts from MariaDB developers about new features, and for news from or about the MariaDB Foundation itself, among other things. For many this is the MariaDB blog, and on behalf of the MariaDB Foundation, welcome! We’re glad you’re here. Thanks for stopping by!

What you may not know is that there’s another MariaDB blog over at https://mariadb.com/blog run by the fine folks at SkySQL (full disclosure: I work for SkySQL, but my posts here are on behalf of the MariaDB project and the Foundation). This other MariaDB blog contains posts about SkySQL’s commercial MariaDB offerings (naturally) but also a lot of other …

Taxonomy upgrade extras: mysqlperformancemonitormonitoringmpmmaasperformance monitor

FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular Database Performance Monitor for MySQL, MariaDB and Percona Server mpm.

This release makes mpm compatible with …

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 14.04LTS)

This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

So I recently had a TBs database that that I had to upgrade from MySQL 5.0 to MySQL 5.5.
This blog post will touch on the following:

• sql_mode 
• innodb_strict_mode 
• SLAVE IO_THREAD 

During the mysql_upgrade process (which does a mysqlcheck) I quickly noticed the following error:

ERROR 1118 (42000) at line 23: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
So I started I had to check a few things first.

# The master DB was > select @@sql_mode; 
+------------+ 
| @@sql_mode | 
+------------+ 
| | 
+------------+ New DB was
…

It’s indeed not possible to limit the number of open files with cgroups.

There was a on Twitter to @MySQL How can I insert “/” into a varchar field please. Since they were polite and used please, I wanted to be helpful.

At first I thought this was the ol’ MySQL string literal problem where you need to have two backslashes to get one backslash in a character field. See String Literals in the MySQL Manual. A lot of people have trouble with the backslash when they first get started with MySQL. From the quote below, you will see that some characters need to be escaped with a backslash. But what about the forward slash?

I remember a previous job were I saved many UNIX file names but I did not remember anything unusual about forward slashed. My mental cache had been flushed of the answer. So I …

LEADERS IN MYSQL DATABASE SUPPORT

When critical technical issues arise, you need swift and effective resolutions from knowledgeable experts. Pythian’s MySQL team brings 76 combined years of MySQL and MongoDB database administration experience to each issue we face. We’re deeply invested in delivering the most relevant and up-to-date database management practices to our clients. Our team members are frequent presenters at conference and hold multiple certifications, including:

• MySQL Cluster certified experts
• MySQL Database certified professionals
• MySQL Developer certified professionals
• M102 MongoDB certifications
• Certified Hadoop, Oracle, and system administration professionals

Pythian delivers high availability, clustering, and replication solutions to ensure you can access your business-critical information securely, and without any downtime. Whether …

Message brokers are not regularly covered here but are, nonetheless, important web-related technologies. Some time ago, I was asked by one of our customer to review a selection of OSS message brokers and propose a couple of good candidates. The requirements were fairly simple: behave well when there’s a large backlog of messages, be able to create a cluster and in case of the failure of a node in a cluster, try to protect the data but never blocks the publishers even though that might imply data lost. Nothing fancy regarding queues and topics management. I decided to write my findings here, before I forget…

I don’t consider myself a message broker specialist and I spent only about a day or two on each so, I may have done some big mistakes configuration wise. I’ll take the blame if something is misconfigured or not used correctly.

…

This month another MySQL User Group meeting is scheduled, this time in Seoul, Korea on May 20, 2014 @ 6:30pm. Please mark your calendar for this day if you are local... It's a great opportunity to hear news about delivering MySQL 5.7.4 as well as we saved some time for a MySQL User Group discussion. Please see details below:

Name: MySQL User Group Meeting

Date: May 20th, 2014

Time: 6:30pm

Place: 15fl. ASEM Tower, (Oracle Korea office), Samsung-dong, Seoul, Korea

For more details see the MySQL Korea User Group Facebook page

Tools for MySQL are a vital part of any deployment, so it’s important to use ones that are reliable and well-designed. Percona Toolkit is a collection of more than 30 command-line tools for MySQL, Percona Server, and MariaDB that can help database administrators automate a variety of database and system tasks. With so many available tools, however, it can be difficult knowing where to start.

For this reason I invite you to join me on Wednesday, May 7 at 10 a.m. Pacific time for a free webinar titled, “The top 9 Percona Toolkit tools that can make your job easier.” You can register directly …