Buy Percona ServicesBuy Now!

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

Percona Live Europe 2018 – Save the Date!

 | April 5, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MyRocks, MySQL, Percona Live, PostgreSQL, ProxySQL, Time Series Database

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

 | March 30, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, Replication

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

Read More

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

Read More

How to Restore MySQL Logical Backup at Maximum Speed

 | February 22, 2018 |  Posted In: Backups, Database Monitoring, Hardware and Storage, InnoDB, Insight for DBAs, MySQL

Restore MySQL Logical Backup

The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense. Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with Percona XtraBackup) could show the same internal database structure corruption as in […]

Read More