EmergencyEMERGENCY? Get 24/7 Help Now!

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

 | October 21, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster nodes (mostly configured as default), copied from a production server. We […]

Read More

Percona Server 5.7.15-9 is now available

 | October 21, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona Server for MySQL 5.7.18-15

Percona announces the GA release of Percona Server 5.7.15-9 on October 21, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.15, including all the bug fixes in it, Percona Server 5.7.15-9 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

Read More

MySQL 8.0: Descending Indexes Can Speed Up Your Queries

 | October 20, 2016 |  Posted In: MySQL

MySQL 8.0.1

In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release (new optimizer preview), when you create an index you can specify the […]

Read More

A Guide to the Percona Monitoring and Management Demo

 | October 19, 2016 |  Posted In: Database Monitoring, InnoDB, MongoDB, MySQL, Percona Monitoring and Management

Percona Monitoring and Management Demo

As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with some explanation. This post provides some guidance. The PMM demo has a […]

Read More

Three Things to Consider When Thinking About Containers

 | October 19, 2016 |  Posted In: Docker, Hardware and Storage, MySQL, Solutions Engineering

containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . . How did this happen? From what I understand, containers grew out of Google’s (and others’) […]

Read More

Upgrading to MySQL 5.7? Beware of the new STRICT mode

 | October 18, 2016 |  Posted In: MySQL

STRICT mode

This blog post discusses the ramifications of STRICT mode in MySQL 5.7. In short By default, MySQL 5.7 is much “stricter” than older versions of MySQL. That can make your application fail. To temporarily fix this, change the SQL_MODE to NO_ENGINE_SUBSTITUTION (same as in MySQL 5.6):

MySQL 5.7, dates and default values The default SQL_MODE in MySQL 5.7 […]

Read More

MySQL Downgrade Caveats

 | October 18, 2016 |  Posted In: MySQL

mysql downgrade

In this blog, we’ll discuss things to watch out for during a MySQL downgrade. Previously, I wrote the blog MySQL upgrade best practices. Besides upgrading your MySQL version, sometimes you need to downgrade. When it comes to downgrading MySQL, there are two types of downgrade methods supported: In-Place Downgrade: In this method, you use the existing data […]

Read More

Percona Server 5.6.33-79.0 is now available

 | October 18, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona Server for MySQL 5.7.18-15

Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug fixes in it, Percona Server 5.6.33-79.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this […]

Read More

Percona Monitoring and Management 1.0.5 is now available

 | October 14, 2016 |  Posted In: Events and Announcements, Percona Monitoring and Management

Percona Monitoring and Management

Percona is glad to announce the release of Percona Monitoring and Management 1.0.5. PMM Server is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are available in the documentation. PMM Server changelog Prometheus 1.1.3 Consul 0.7.0 Added Orchestrator – a MySQL replication topology management […]

Read More