MariaDB Blog

June 19, 2012

Join SkySQL & Maria DB at the first ever MySQL/NoSQL/Cloud Conference in Buenos Aires, Argentina, June 26-28th

Hosted by Binlogic, the MySQL/NoSQL/Cloud Latin American Conference at the Hilton Buenos Aires in Argentina, June 26-28th, will bring together key members of the of open source database community for two intense days of technical talks and tutorials on popular open source databases like MySQL, MariaDB, and Drizzle; NoSQL databases such as MongoDB and CouchDB; and related technologies such as the Soir and Sphinx search engines.

Read More

June 14, 2012

MySQL & MariaDB RPMs on Enterprise Linux 6

We've had a number of questions from customers lately about a change in Enterprise Linux 6 that introduces compatibility problems between older vendor RPMs (those from dev.mysql.com or Monty Program AB, for instance) and newer OS packages (the ones available from the OS distribution's package repository). Specifically, there is a new "mysql-libs" package that some other EL packages require. In particular, postfix requires mysql-libs, any many packages require postfix, which is the default MTA in EL6.

Read More

June 13, 2012

Monty Program & SkySQL: a statement on the serious security vulnerability that was found in MariaDB and MySQL

Over the past few days extensive conversations around a new security vulnerability in MariaDB and MySQL have taken place. It all started as a chain reaction when Monty Program publicly disclosed information about the flaw they had found and about how to make sure your MariaDB and MySQL installations can be fixed. The initial information got assigned the security vulnerabitlity identifier CVE-2012-2122 and the contents can be seen e.g. here http://seclists.org/oss-sec/2012/q2/493.

Read More

June 12, 2012

MariaDB 5.5 performance on Windows

We haven't posted any Windows benchmarks for a while, and MariaDB for Windows contains some specific improvements which might not be widely know since we haven't talked much about them yet. This post is an attempt to fix that. We'll also share current MySQL 5.5 numbers. My setup is an 8 core 2 socket server (yes, a little bit dated for today, but it is the best machine I have at my disposal), 10K SAS disks with RAID1. I ran sysbench 0.4 single table / 1,000,000 records. I ran the benchmark over a network, with the number of concurrent clients ranging from 4 to 4096.

Read More

June 08, 2012

How To Tune MariaDB Write Performance

This article describes how I tuned MariaDB to give the best write throughput with SSD based storage. When you have a write-heavy application writing into InnoDB, you will probably experience the InnoDB Checkpoint Blues. The effect manifests as stalls - short periods of time where the troughput falls to zero and I/O activity goes crazy. The phenomenon is well known and described i.e. here.

Read More

June 07, 2012

5.5 Series Sysbench OLTP Results

A few days ago MariaDB, MySQL and Percona all three released new versions of the 5.5 server. So I decided it's time to run sysbench once more and compare the OLTP performance. The test candidates are:

  • MariaDB-5.5.24, using either XtraDB (default) or InnoDB
  • MySQL-5.5.25
  • Percona Server 5.5.24-26.0

Read More