EmergencyEMERGENCY? Get 24/7 Help Now!

Update on the InnoDB double-write buffer and EXT4 transactions

 | June 17, 2015 |  Posted In: Benchmarks, Hardware and Storage, InnoDB, MySQL

IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning […]

Read More

MaxScale: A new tool to solve your MySQL scalability problems

 | June 8, 2015 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, XtraDB Cluster

Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to solve, the reality is far more complex. First, the […]

Read More

OpenStack: A MySQL DBA Perspective – Sept. 17 webinar

 | September 11, 2014 |  Posted In: MySQL, OpenStack, Percona XtraDB Cluster, Technical Webinars

I’ll have the pleasure to present, next Wednesday, September 17 at 10 a.m. PDT (1 p.m. EDT) a webinar titled “OpenStack: A MySQL DBA Perspective.” Everyone is invited. The webinar will be divided into two parts. The first part will cover how MySQL can be used by the OpenStack infrastructure including the expected load, high-availability […]

Read More

Getting my hands dirty on an OpenStack lab

 | August 18, 2014 |  Posted In: MySQL, OpenStack

Like you all may know, OpenStack is currently one of the coolest open source projects, so I was thrilled when I was asked to manage the deployment of an OpenStack lab for internal Percona use. Starting from basically zero, I created tasks in our Jira and assigned them to a pool of volunteer consultants. As usual in […]

Read More

How to improve InnoDB performance by 55% for write-bound loads

 | May 23, 2014 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live

Update: do not do this, this has been proven to corrupt data!   During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real […]

Read More

Exploring message brokers

 | May 5, 2014 |  Posted In: High-availability, MySQL

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 […]

Read More

The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB

 | January 10, 2014 |  Posted In: High-availability, MySQL, XtraDB Cluster

Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or software solution like haproxy. In both cases, in order to avoid having a single point of failure, […]

Read More

Q&A: Geographical disaster recovery with Percona Replication Manager

 | December 10, 2013 |  Posted In: High-availability, MySQL

My December 4 webinar, “Geographical disaster recovery with  Percona Replication Manager (PRM),”  gave rise to a few questions. The recording of the webinar and the slides are available here, and I’ve answered the questions I didn’t have time to address below. Q1: Hi, I was wondering if corosync will work in cloud environment. As far as […]

Read More