MySQL

Category to track posts in PlanetMySQL

ProxySQL 2.0.4 and proxysql-admin tool Now Available

implement ProxySQL with AWS Aurora

ProxySQL 2.0.4, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.
ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò […]

Read more

Percona Server for MySQL 5.7.26-29 Is Now Available

Percona announces the release of Percona Server for MySQL 5.7.26-29 on May 27, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.26, including all the bug fixes in it. Percona Server for MySQL 5.7.26-29 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and […]

Read more

Critical Update for Percona Server for MySQL 5.6.44-85.0

Percona Server for MySQL 8.0

This is a CRITICAL update and the fix mitigates the issues described in CVE-2019-12301. If you upgraded packages on Debian/Ubuntu to 5.6.44-85.0-1, please upgrade to 5.6.44-85.0-2 or later and reset all MySQL root passwords.
 
Issue
On 2019-05-18 Percona discovered an issue with the Debian/Ubuntu 5.6.44-85.0-1 packages for Percona Server for MySQL. When the previous versions, […]

Read more

Check Out the Percona Live 2019 Live Stream!

percona live

Feeling the FOMO? Now you don’t have to! With the Percona Live Open Source Database Conference 2019 Live Stream, you’ll practically be there in person, living the experience to the fullest. Our keynote stage features morning and lunchtime keynotes on Wednesday, May 29th and morning keynotes on Thursday, May 30th. Join us at home […]

Read more

Percona Server for MySQL 5.6.44-85.0

Percona Server for MySQL 8.0

NOTE [2019-05-18]: Debian/Ubuntu 5.6.44-85.0-1 packages were replaced today in the repositories with the 5.6.44-85.0-2 because they would reset the root password to an empty string during the upgrade on Debian/Ubuntu (bug #5640). If you upgraded packages on Debian/Ubuntu to the 5.6.44-85.0-1 please upgrade to 5.6.44-85.0-2 and re-set your root password.
Percona announces the release of […]

Read more

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

Community Update for PL Open Source Database Conference 2019

Percona Live community dinner on the Lone Star River Boat

It’s not long now before we’ll be gathering in Austin TX for this year’s Percona Live event. It’s the only conference of its type dedicated entirely to open source databases – of all marques. From a community perspective, we have a few updates to share.
Community Dinner
We’re happy to say that PlanetScale have stepped up […]

Read more

Percona XtraBackup 8.0.6 Is Now Available

Percona XtraBackup 8.0

Percona is glad to announce the release of Percona XtraBackup 8.0.6 on May 9, 2019. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]

Read more

MySQL InnoDB Sorted Index Builds

Bulk load of 7.7

It’s not essential to understand how MySQL® and Percona Server for MySQL build indexes. However, if you have an understanding of the processing, it could help when you want to reserve an appropriate amount of space for data inserts. From MySQL 5.7, developers changed the way they built secondary indexes for InnoDB, applying a […]

Read more