All Blogs / Technology / Programming / Database Development / Popular

Thoughts on MySQL 8.0 Invisible Indexes

MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us? There are a couple of use cases. One of them is if you want to […]

Monitoring OS metrics for Amazon RDS with Grafana

This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you already use Grafana). Setup 1. Create an IAM user on the AWS […]

Percona Poll: What Database Technologies are You Using?

Take Percona’s poll on what database technologies you use in your environment. Different databases get designed for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Show More Summary

Percona Live Open Source Database Conference 2017: Submit Papers ASAP!

The Percona Live Open Source Database Conference 2017 call for papers is closing soon! Get in your submissions ASAP! After this past sold-out Percona Live Europe in Amsterdam, we’ve decided that expansion definitely works! The diverse list of topics at the recent conference convinced us that variety is both the spice of life. It’s the […]

TokuDB and PerconaFT Data Files: Database File Management Part 2 of 2

This is the second installment of the blog series on TokuDB and PerconaFT data files. You can find my previous post here. In this post we will discuss some common file maintenance operations and how to safely execute these operations. Moving TokuDB data (table/index) files to another location outside of the default MySQL datadir TokuDB uses […]

Announcing MyRocks in Percona Server for MySQL

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

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

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

Percona Responds to East Coast DDoS Attack

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 web site availability and performance, including all related services such as our forums, blogs and […]

Percona Server 5.7.15-9 is now available

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

Three Things to Consider When Thinking About 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’) […]

Future Tidal Wave of Mobile Video

In this article I will examine the growing trends of Internet Mobile video and how consumer behaviour is rapidly adopting to a world of ‘always on content’ and discuss the impact on the underlying infrastructure.

MySQL 8.0: Descending Indexes Can Speed Up Your Queries

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

MySQL Downgrade Caveats

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

A Guide to the 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 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 […]

Upgrading to MySQL 5.7? Beware of the new 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 [crayon-5806b85f22752219823635-i/] to...Show More Summary

Percona Server 5.6.33-79.0 is now available

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

Datanet: a New CRDT Database that Let's You Do Bad Bad Things to Distributed Data

We've had databases targeting consistency. These are your typical RDBMSs. We've had databases targeting availability. These are your typical NoSQL databases. If you're using your CAP decoder ring you know what's next...what databases...Show More Summary

Stuff The Internet Says On Scalability For October 14th, 2016

Hey, it's HighScalability time: A pattern from the collective unconscious of the universe. Scott Kelly's brilliant Year in Space Photos. If you like this sort of Stuff then please support me on Patreon. $1.5 million: new iOS hack bug...Show More Summary

Percona Monitoring and Management 1.0.5 is now available

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. Show More Summary

Update the Signing Key for Percona Debian and Ubuntu Packages

In this blog post, we’ll explain how to update the signing key for Percona Debian and Ubuntu packages. Some of the users might have already noticed following warning on Ubuntu 16.04 (Xenial Xerus): W: More Summary

Copyright © 2015 Regator, LLC