MySQL

Category to track posts in PlanetMySQL

Percona XtraDB Cluster 5.6.44-28.34 Is Now Available

Percona XtraDB Cluster 5.7

Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the following:

Percona Server 5.6.44-86.0
Codership WSREP API release 5.6.43
Codership Galera library 3.26

All Percona software is open-source and free.
Bugs Fixed

PXC-2487: The […]

Read more

How pt-online-schema-change Handles Foreign Keys

pt-online-schema-change

Foreign key related issues are very common when dealing with DDL changes in MySQL using Percona toolkit. In this blog post, I will explain how the tool (pt-online-schema-change) handles foreign key constraints when executing a DDL change.
First of all, I would like to explain why foreign keys have to be handled at all before […]

Read more

Enterprise Database Solution – Maximizing Return for the Lowest Cost

Enterprise Data Solution

It used to be easy: a company developed a new application, chose a database solution, launched the new application and then tuned the chosen database solution. A team of DBAs looked at the infrastructure as well as the workload and made changes (or suggestions) as needed. The application then stayed in production for years […]

Read more

RHEL 8 Packages Available for Percona Products

percona Redhat Enterprise Linux 8

Redhat Enterprise Linux 8 packages have been released into our repositories.  Recent versions of Percona Server for MySQL, Percona XtraDB Cluster, Percona XtraBackup,  Percona Server for MongoDB, Percona Toolkit, and the PMM Client can now be automatically installed via Redhats dnf utility.
How to install RHEL 8
Visit https://www.redhat.com/en/technologies/linux-platforms/enterprise-linux and follow the instructions.  If you have […]

Read more

Percona Live Community Dinner 2019

It was all aboard the Lone Star river boat for the 100 delegates who joined our Community Dinner. Loading took quite some time, Tom Basil attended to the guest list, and then the necessary signatures for those aboard. I’d woken at 6am to a less than favorable forecast, but the weather was kind to […]

Read more

Percona Monitoring and Management (PMM) 2 Beta Is Now Available

Percona Monitoring and Management

We are pleased to announce the release of PMM 2 Beta!  PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Query Analytics:

MySQL and MongoDB – Slow log, PERFORMANCE_SCHEMA, and Profiler data sources
Support for large environments – default view all queries from all instances
Filtering – display only the results […]

Read more

MySQL Community Awards at Percona Live 2019

It’s that time of year again, and we’ve just had the presentations of the MySQL Community Awards at Percona Live. A more fulsome blog post will be written for the Community Blog in the next few days about the worthy winners. Meanwhile, though, here’s a summary.
Committee Co-Secretaries Emily Slocombe of Square, and Agustin Gallego […]

Read more

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