Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 23, 2021
August Is Hot, but Not as Hot as Our Next Community Engineering Meeting!
The engineering marvel that is Percona Monitoring and Management (PMM), has to be, for me, one of the best examples [...]
August 11, 2021
Pros and Cons: When You Should and Should Not Use MongoDB
Quite often we see that the main operational storage is used in conjunction with some additional services, for example, for [...]
August 10, 2021
PostgreSQL PL/Java – A How-To, Part 2: How to Manipulate and Return Tuples
We discussed how to install and create a simple class in the first part of this series where we ran [...]
August 10, 2021
Impact of Network and Cursor on Query Performance of PostgreSQL
Many times, we see PostgreSQL users getting confused about the query/statement duration reported in PostgreSQL logs. Other PostgreSQL tools like [...]
July 30, 2021
Percona Monthly Bug Report: July 2021
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the [...]
July 29, 2021
PostgreSQL PL/Java – A How-To, Part 1
We’ve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. [...]
July 28, 2021
MongoDB: Modifying Documents Using Aggregation Pipelines and Update Expressions
Updating documents on MongoDB prior to version 4.2 was quite limited. It was not possible to set values to a [...]
July 19, 2021
Performing ETL Using Inheritance in PostgreSQL
Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the [...]
July 6, 2021
Move Percona Monitoring and Management Server Data From One Instance Type to Another
Percona Monitoring and Management (PMM2) Server runs as a Docker container, a Virtual appliance, or as an instance on Amazon [...]
June 30, 2021
Percona Monthly Bug Report: June 2021
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the [...]
June 2, 2021
Inspecting MySQL Servers Part 2: Knowing the Server
In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect [...]
June 1, 2021
Inspecting MySQL Servers Part 1: The Percona Support Way
When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz [...]
April 28, 2021
Resolving the MySQL Active-Active Replication Dilemma
Multi-writer replication has been a challenge in the MySQL ecosystem for years before truly dedicated solutions were introduced – first [...]
April 27, 2021
Percona Monthly Bug Report: April 2021
Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the [...]
April 23, 2021
Yearly Reminder: DDLs That Fail to Propagate May Cause Percona XtraDB Cluster Inconsistencies
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. [...]
April 19, 2021
MySQL Group Replication: Conversion of GR Member to Async Replica (and Back) In the Same Cluster
MySQL Group Replication is a plugin that helps to implement highly available fault-tolerant replication topologies. In this blog, I am [...]
April 16, 2021
Integrated Alerting Design in Percona Monitoring and Management
Percona Monitoring and Management 2.13 (PMM) introduced the Integrated Alerting feature as a technical preview. It adds a user-friendly way [...]
April 12, 2021
Replay the Execution of MySQL With RR (Record and Replay)
Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at [...]
March 30, 2021
How To Automate Dashboard Importing in Percona Monitoring and Management
In this blog post, I’ll look at how to import custom dashboards into Percona Monitoring and Management (PMM) 2.x, and [...]
March 26, 2021
Overview of MySQL Alternative Storage Engines
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability [...]