Buy Percona ServicesBuy Now!

Lock Down: Enforcing AppArmor with Percona XtraDB Cluster

 | August 9, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security

Enforcing AppArmor with Percona XtraDB Cluster

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 AppArmor by default. If you are concerned by computer security and use PXC on Ubuntu, you […]

Read More

Tuning InnoDB Primary Keys

 | July 26, 2018 |  Posted In: InnoDB, 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 databases. There are many aspects related to performance tuning […]

Read More

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