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

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

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

Using the loose_ option prefix in my.cnf

 | October 11, 2016 |  Posted In: MySQL

loose_ option

In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example:

The MySQL manual has a solution: use the loose_ prefix option in my.cnf file. In the prior example, if we specify loose_bogus_option=1 […]

Read More

Take Percona’s One-Click 2017 Top Database Concerns Poll

 | October 10, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Database Monitoring, High-availability, MariaDB, MongoDB, MySQL

2017 top database concerns

Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]

Read More

Percona Live Europe 2016: Day Two Keynote Speakers

 | October 5, 2016 |  Posted In: MySQL, Percona Live

percona live europe

Hello again, from day two of the sold out Percona Live Europe Open Source Database Conference! There is still much excitement here at the conference, and today looks to be just as busy as yesterday. Day two of Percona Live Europe 2016 kicked off once again with a keynote presentation by Percona co-founder and CEO […]

Read More

Using the super_read_only system variable

 | September 27, 2016 |  Posted In: MySQL


This blog post will discuss how to use the MySQL super_read_only system variable. It is well known that replica servers in a master/slave configuration, to avoid breaking replication due to duplicate keys, missing rows or other similar issues, should not receive write queries. It’s a good practice to set read_only=1 on slave servers to prevent any […]

Read More

Sixth Annual Percona Live Open Source Database Conference 2017 Call for Speakers Now Open

 | September 22, 2016 |  Posted In: MySQL

The Call for Speakers for Percona Live Open Source Database Conference 2017 is open and accepting proposals through Oct. 31, 2016. The Percona Live Open Source Database Conference 2017 is the premier event for the diverse and active open source community, as well as businesses that develop and use open source software. Topics for the […]

Read More

How X Plugin Works Under the Hood

 | September 16, 2016 |  Posted In: Insight for DBAs, MySQL

X Plugin

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]

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.