InnoDB

InnoDB Cluster in a nutshell Part 1: Group Replication

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

MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED

MySQL 8.0 hot rows

In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, we’ll look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows? It’s likely that you have the application […]

Read more

Chunk Change: InnoDB Buffer Pool Resizing

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 […]

Read more

How Binary Logs (and Filesystems) Affect MySQL Performance

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

Percona Live 2018: Closing Ceremony with Lightning Talks

Mariella ViaSat Percona Live 2018

Percona Live 2018 is officially done! The closing ceremony ends the conference with a last few lightning talks and a prize giveaway.
We ended the Percona Live 2018 conference the same way we started: with talks! This year, we had our lightning talks as part of our closing ceremony. They included:
Amazon Aurora MySQL and RDS […]

Read more

Percona Live 2018: POLARDB, an InnoDB Based Shared-Everything Storage Solution

Inaam Alibaba Percona Live 2018

We’re heading into the home stretch at Percona Live 2018, but the sessions are continuing. I was able to attend a talk this afternoon given by Inaam Rana, a Database Developer at Alibaba Cloud, on PolarDB, an InnoDB based shared-everything storage solution.
POLARDB provides read scale out on shared everything architecture. It features 100% backward […]

Read more

Congratulations to Our Friends at Oracle with the MySQL 8.0 GA Release!

MySQL 8.0 GA

It is a great today for whole MySQL community: MySQL 8.0 was just released as GA!
Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading.
If you can’t wait to upgrade to MySQL 8.0, […]

Read more

Binlog and Replication Improvements in Percona Server for MySQL

Percona Server for MySQL

Due to continuous development and improvement, Percona Server for MySQL incorporates a number of improvements related to binary log handling and replication. This results in replication specifics, distinguishing it from MySQL Server.
Temporary tables and mixed logging format
Summary of the fix:
As soon as some statement involving temporary tables was met when using a mixed binlog format, MySQL switched to […]

Read more

Percona Live Europe 2018 – Save the Date!

Percona Live Europe 2018

We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open source database conference.
Percona Live in Santa […]

Read more

Multi-Source Replication Performance with GTID

Multi-Source Replication with GTID

In this blog post, we’ll look at the performance of multi-source replication with GTID.
Note. This blog was edited as I received some comments from Percona colleagues. I’ve updated the contents in the marked EDIT section. Thanks!
Multi-Source Replication is a topology I’ve seen discussed recently, so I decided to look into how it performs with […]

Read more