EmergencyEMERGENCY? Get 24/7 Help Now!

The MySQL High Availability Landscape in 2017 (The Elders)

 | June 20, 2017 |  Posted In: Group Replication, GTID, High-availability, MySQL, Percona XtraDB Cluster

High Availability

In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the technologies involved with the high availability (HA) aspects of MySQL. When I joined Percona back in 2009, some of these HA technologies were very popular – […]

Read More

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More

Using Ceph with MySQL

 | July 13, 2016 |  Posted In: Hardware and Storage, High-availability, MySQL, OpenStack

Ceph

Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is similar to the shift from bare disks host configuration to LVM-managed […]

Read More

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