Buy Percona ServicesBuy Now!

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

 | 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

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

Percona Live 2018: Closing Ceremony with Lightning Talks

 | April 25, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, High-availability, InnoDB, Insight for DBAs, Percona Live

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

Read More

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

 | April 25, 2018 |  Posted In: Cloud and MySQL, InnoDB, open source databases, Percona Live

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!

 | April 19, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, Percona Live

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

Read More

Binlog and Replication Improvements in Percona Server for MySQL

 | April 16, 2018 |  Posted In: InnoDB, Insight for DBAs, MariaDB, 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 […]

Read More