Monthly Archives - October 2016

Replication Triggers a Performance Schema Issue on 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 Responds to East Coast DDoS Attack

ddos

As noted in several media outlets, many web sites have been affected by a DDoS attack on Dyn today. Since Percona uses Dyn for its DNS server, we are experiencing issues as well.  
The attack has impacted the percona.com web site availability and performance, including all related services such as our forums, blogs and […]

Read more

Percona Server 5.7.15-9 is now available

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

MySQL 8.0 innodb_dedicated_server

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

Read more

A Guide to the Percona Monitoring and Management Demo

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

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’) need […]

Read more

Upgrading to MySQL 5.7? Beware of the new STRICT mode

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

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

1

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

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

Read more

MySQL Downgrade Caveats

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

Read more

Percona Server 5.6.33-79.0 is now available

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

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 and visualization tool. Available […]

Read more