by Yves Trudeau | Feb 11, 2019 | Insight for DBAs, MySQL
In one of my previous posts, I started a series on data compression options with MySQL. The first post focused on the more traditional compression options like InnoDB Barracuda page compression and MyISAM packing. With this second part, I’ll discuss a newer... by Yves Trudeau | Jan 18, 2019 | Insight for DBAs, MariaDB, MySQL, Percona Software
Some time ago I wrote a script to manage asynchronous replication links between Percona XtraDB clusters. The original post can be found here. The script worked well with Percona XtraDB Cluster but it wasn’t working well with MariaDB®. Finally, the... by Yves Trudeau | Nov 23, 2018 | Insight for DBAs, MySQL
Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like... by Yves Trudeau | Nov 1, 2018 | Insight for DBAs, MySQL, Percona Software
by Yves Trudeau | Aug 9, 2018 | MySQL, Percona Software, Security
Recently, I wrote a blog post showing how to enforce SELinux with Percona XtraDB Cluster (PXC). The Linux distributions derived from RedHat use SELinux. There is another major mandatory discretionary access control (DAC) system, AppArmor. Ubuntu, for example, installs... by Yves Trudeau | Jul 26, 2018 | Insight for DBAs, MySQL
The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload.As a principal architect at Percona, one of my main duties is to tune customer... by Yves Trudeau | Jun 21, 2018 | MySQL, Percona Software, Security
by Yves Trudeau | May 15, 2018 | MySQL
If you are a regular reader of this blog, you likely know I like the ZFS filesystem a lot. ZFS has many very interesting features, but I am a bit tired of hearing negative statements on ZFS performance. It feels a bit like people are telling me “Why do you use... by Yves Trudeau | Mar 27, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Architect in Architecture & Projects, Yves Trudeau, as he presents ZFS with MySQL on Wednesday, March 28, 2018, at 7:00 am PDT (UTC -7) / 10:00 am EDT (UTC -4).Are you curious about ZFS? Would you like to learn how to setup... by Yves Trudeau | Feb 8, 2018 | Hardware and Storage, Insight for DBAs, MySQL
While preparing a post on the design of ZFS based servers for use with MySQL, I stumbled on the topic of fsync call performance. The fsync call is very expensive, but it is essential to databases as it allows for durability (the “D” of the ACID... by Yves Trudeau | Dec 27, 2017 | MySQL, Percona Software, Security
In this blog, we’ll look at how the hidepid options for /proc and Percona XtraDB Cluster can fight with one another.One of the things I like about consulting at Percona is the opportunity to be exposed to unusual problems. I recently worked with a customer... by Yves Trudeau | Dec 7, 2017 | Hardware and Storage, Insight for DBAs, MySQL, Percona Software
This post is a hands-on look at ZFS with MySQL.In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a... by Yves Trudeau | Nov 15, 2017 | Hardware and Storage, Insight for DBAs, MySQL
Since the purpose of a database system is to store data, there is close relationship with the filesystem. As MySQL consultants, we always look at the filesystems for performance tuning opportunities. The most common choices in term of filesystems are XFS and EXT4, on... by Yves Trudeau | Sep 22, 2017 | Insight for DBAs, MySQL
For most people (including me until recently) database XA transactions are a fuzzy concept. In over eight years with Percona, I have never had to deal with XA transactions. Then a few weeks ago I got two customers having issues with XA transactions. That deserves a... by Yves Trudeau | Sep 15, 2017 | Insight for DBAs, MySQL, ProxySQL
This post is the third of a series focusing on the MySQL high availability solutions available in 2017.The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and... by Yves Trudeau | Aug 22, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at some of the MySQL high availability solution options.In the previous post of this series, we looked at the MySQL high availability (HA) solutions that have been around for a long time. I called these solutions “the... by Yves Trudeau | Jun 20, 2017 | Insight for DBAs, MySQL, Percona Software
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.... by Yves Trudeau | Dec 1, 2016 | Insight for DBAs, Percona Software
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... by Yves Trudeau | Aug 4, 2016 | MySQL, Percona Software
by Yves Trudeau | Jul 13, 2016 | Hardware and Storage, Insight for DBAs, MySQL
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...