Buy Percona ServicesBuy Now!

Lock Down: Enforcing SELinux with Percona XtraDB Cluster

 | June 21, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security

SELinux for PXC security

Why do I spend time blogging about security frameworks? Because, although there are some resources available on the Web, none apply to Percona XtraDB Cluster (PXC) directly. Actually, I rarely encounter a MySQL setup where SELinux is enforced and never when Percona XtraDB Cluster (PXC) or another Galera replication implementation is used. As we’ll see, […]

Read More

About ZFS Performance

 | May 15, 2018 |  Posted In: AWS, Hardware and Storage, MySQL, ZFS

ZFS

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 InnoDB? I have read […]

Read More

The hidepid Options for /proc and Percona XtraDB Cluster Don’t Play Well Together

 | December 27, 2017 |  Posted In: MySQL, Percona XtraDB Cluster, Security

hidepid

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 having issues getting SST to work with Percona XtraDB […]

Read More

ZFS from a MySQL perspective

 | November 15, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL, ZFS

Open ZFS logo

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 Linux it is exceptional to encounter another filesystem. Both XFS and […]

Read More

The MySQL High Availability Landscape in 2017 (The Adults)

 | August 22, 2017 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster

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 elders.” Some of these solutions (like replication) are heavily used today […]

Read More