Buy Percona ServicesBuy Now!

Announcement: Experimental Build of Percona XtraBackup 8.0

 | September 12, 2018 |  Posted In: Backups, InnoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraBackup

Percona XtraBackup 8.0

Experimental Build of Percona XtraBackup 8.0 released An experimental alpha version of Percona XtraBackup 8.0.1 is now available in the Percona experimental software repositories. A few things to note about this release: We removed the deprecated innobackupex in this release Due to the new MySQL redo log and data dictionary formats the Percona XtraBackup 8.0.x versions […]

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

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

InnoDB Cluster in a Nutshell Part 3: MySQL Shell

 | July 20, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, Insight for Developers, JSON, MySQL

MySQL InnoDB Cluster MySQL Shell

Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last […]

Read More

InnoDB Cluster in a Nutshell: Part 2 MySQL Router

 | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases

MySQL Router MySQL Cluster

MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment […]

Read More

When Database Warm Up is Not Really UP

 | July 10, 2018 |  Posted In: InnoDB, MySQL, Percona Monitoring and Management, PMM

first few minutes MySQL Warm Up graph from PMM

The common wisdom with database performance management is that a “cold” database server has poor performance. Then, as it “warms up”, performance improves until finally you reach a completely warmed up state with peak database performance. In other words, that to get peak performance from MySQL you need to wait for database warm up. This […]

Read More

InnoDB Cluster in a nutshell Part 1: Group Replication

 | July 9, 2018 |  Posted In: Group Replication, High-availability, InnoDB, MySQL

innodb cluster in a nutshell part 1

Since MySQL 5.7 we have a new player in the field, MySQL InnoDB Cluster. This is an Oracle High Availability solution that can be easily installed over MySQL to get High Availability with multi-master capabilities and automatic failover. This solution consists in 3 components: InnoDB Group Replication, MySQL Router and MySQL Shell, you can see […]

Read More

Chunk Change: InnoDB Buffer Pool Resizing

 | June 19, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

innodb buffer pool chunk size

Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. […]

Read More