Tag - insight for DBAs

Testing Percona XtraDB Cluster 8.0 with DBdeployer

In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0.
We at Percona, with my colleague Ramesh Sivaraman, have tested and deployed Percona XtraDB Cluster (PXC) 8.0.18  […]

Read more

Restoring a MongoDB Sharded Cluster to a Different Environment

MongoDB Sharded Cluster

If you have been working in the database field for some time, you have likely come across the need to create a new database, based on an existing one. The most common example I can think of is to create a copy of the production database for testing purposes.
In the case of MongoDB sharded […]

Read more

[Warning] InnoDB: Difficult to Find Free Blocks in the Buffer Pool

InnoDB Buffer Pool

A couple of weeks ago, one of our customers reached us asking about the WARNING messages in their MySQL error log. After a while, there were a few more requests from some other customers asking whether to worry about these messages or not. In this post, I am going to write about the condition […]

Read more

Percona Server for MongoDB LDAP Enhancements: User-to-DN Mapping

Percona Server MongoDB LDAP Mapping

Automatic Role-Based Authorization by LDAP Comes to Percona Server for MongoDB (PSMDB)
In PSMDB 4.2.5-5, admins now have a way to leverage LDAP infrastructure to automatically assign database roles to LDAP-authenticated database users. The keyword is that LDAP Authorization has now been added alongside LDAP Authentication. The feature is in experimental status as of the […]

Read more

A Simple Approach to Troubleshooting High CPU in MySQL

High CPU in MySQL

One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system. The usage of simple OS tools to find the culprit has been a widely used technique for a long time by PostgreSQL and Oracle DBAs, but it […]

Read more