Buy Percona ServicesBuy Now!

AMD EPYC Performance Testing… or Don’t get on the wrong side of SystemD

 | July 11, 2018 |  Posted In: Benchmarks, MySQL, Percona Server for MySQL

Ubuntu 16 AMD EPYC

Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when Packet.net started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL under this CPU. In this benchmark, I discovered some […]

Read More

Running Percona XtraDB Cluster in Kubernetes/OpenShift

 | June 25, 2018 |  Posted In: Containers, MySQL, Percona Monitoring and Management, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Diagram of Percona XtraDB Cluster / MySQL running in Kubernetes Open Shift

Kubernetes, and its most popular distribution OpenShift, receives a lot of interest as a container orchestration platform. However, databases remain a foreign entity, primarily because of their stateful nature, since container orchestration systems prefer stateless applications. That said, there has been good progress in support for StatefulSet applications and persistent storage, to the extent that it […]

Read More

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

ClickHouse Meetup in Salt Lake City

 | May 1, 2018 |  Posted In: MyRocks, MySQL, Yandex ClickHouse

ClickHouse Cloud Native Utah

Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, I’ll be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup. Interestingly enough, even though it is totally different from OLTP engines, […]

Read More

A Look at MyRocks Performance

 | April 30, 2018 |  Posted In: Benchmarks, Insight for DBAs, MyRocks, MySQL

MyRocks Performance

In this blog post, I’ll look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. […]

Read More

Sysbench-tpcc Supports PostgreSQL (No, Really This Time)

 | April 19, 2018 |  Posted In: Benchmarks, Database Monitoring, Insight for DBAs, MySQL

Sysbench-tpcc Supports PostgreSQL

This time, we really mean it when we say sysbench-tpcc supports PostgreSQL. When I initially announced sysbench-tpcc, I mentioned it potentially could run against PostgreSQL, but it was more like wishful thinking than reality. The reality was that even though both databases speak SQL, the difference in dialects was too big and the queries written […]

Read More

Analyze MySQL Audit Logs with ClickHouse and ClickTail

 | March 29, 2018 |  Posted In: Database Monitoring, MySQL, Yandex ClickHouse

ClickHouse and ClickTail

In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail. Audit logs are available with a free plugin for Percona Server for MySQL (https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html). Besides providing insights about activity on your server, you might need the logs for compliance purposes. However, on an active […]

Read More

Percona XtraDB Cluster on Amazon GP2 Volumes

and  | March 28, 2018 |  Posted In: AWS, High-availability, Insight for DBAs, Percona XtraDB Cluster

In this blog post, we look at the performance of Percona XtraDB Cluster on Amazon GP2 volumes. In our overview blog post on Best Practices for Percona XtraDB Cluster on AWS, GP2 volumes did not show good results. However, we allocated only the size needed to fit the database (200GB volumes). Percona XtraDB Cluster did not show […]

Read More