Buy Percona ServicesBuy Now!

Upcoming Webinar Thurs 9/6: Running MySQL in Kubernetes

 | September 4, 2018 |  Posted In: Kubernetes, MySQL, Technical Webinars

Running MySQL in Kubernetes

Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents Running MySQL in Kubernetes on Thursday, September 6th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Without question, Kubernetes is the most popular container orchestration platform. But can it handle databases? I think so, and in this webinar, […]

Read More

Scaling IO-Bound Workloads for MySQL in the Cloud

 | August 29, 2018 |  Posted In: Benchmarks, Cloud and MySQL, Hardware and Storage, InnoDB, MyRocks, MySQL, Percona Server for MySQL

InnoDB / MyRocks throughput on IO1

Is increasing GP2 volumes size or increasing IOPS for IO1 volumes a valid method for scaling IO-Bound workloads? In this post I’ll focus on one question: how much can we improve performance if we use faster cloud volumes? This post is a continuance of previous cloud research posts: Saving With MyRocks in The Cloud Percona […]

Read More

Saving With MyRocks in The Cloud

 | August 1, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MyRocks, MySQL, open source databases

The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I figured that MyRocks would be beneficial for use in cloud workloads, where storage is either slow or expensive. In that earlier post, we demonstrated the benefits of MyRocks, especially for heavy IO workloads. Meanwhile, Mark wrote in […]

Read More

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