Tag - MySQL 5.7

Solve Query Failures Regarding ONLY_FULL_GROUP_BY SQL Mode

Solve Query Failures SQL mode

“Hey, what’s going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors.”
This is a question some customers have asked me after upgrading MySQL. In this article, we’ll see what one of the most frequent […]

Read more

Binlog and Replication Improvements in Percona Server for MySQL

Percona Server for MySQL 8.0

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

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately.

MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read more

Learning MySQL 5.7: Q & A

MySQL 5.7

In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7!
First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here.
I received a number of interesting questions in the webinar that I’ve followed up with below.
Would there […]

Read more

A Little Trick Upgrading to MySQL 5.7

Upgrading to MySQL 5.7

In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7.
I covered this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017.
On Upgrading to MySQL 5.7
We’ve been doing upgrades for quite a while here are Percona, and we try to optimize, standardize and […]

Read more