EmergencyEMERGENCY? Get 24/7 Help Now!

Announcing MyRocks in Percona Server for MySQL

 | October 24, 2016 |  Posted In: MySQL, Percona Server

MyRocks in Percona Server

Announcing MyRocks in Percona Server for MySQL. RocksDB has been taking the world by the storm! RocksDB counts Facebook, LinkedIn, Pinterest, Airbnb and Netflix among its users. It is the storage engine for many open source database technologies, including CockroachDB, Apache Flink, TiKV and Dgraph. It is also integrated with MySQL and MongoDB as the MyRocks and […]

Read More

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

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

Replication triggers a Performance Schema issue

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, Percona Software, TokuDB

Percona Server 5.7.15-9

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

Descending Indexes

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


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


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’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.