New & Featured Articles
Blog articles, announcements, news, updates and more
January 12, 2024
Can’t We Assign a Default Value to the BLOB, TEXT, GEOMETRY, and JSON Data Types?
One of our customers wants to create a table having a column of data type TEXT with the default value, [...]
MOST RECENT ARTICLES
January 11, 2024
Is MySQL Router 8.2 Any Better?
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in [...]
January 9, 2024
Create an AI Expert With Open Source Tools and pgvector
2023 was the year of Artificial Intelligence (AI). A lot of companies are thinking about how they can improve user [...]
January 9, 2024
How to Use Group Replication with Haproxy
When working with group replication, MySQL router would be the obvious choice for the connection layer. It is tightly coupled [...]
January 8, 2024
The Underlying Importance of the server_id Parameter
One of the most underlooked parameters to configure MySQL is server_id, which is an integer number to identify a server [...]
January 8, 2024
16 Updates and Releases to Start the New Year! Roundup January 8, 2024
Welcome to the first release roundup of 2024… and we’ve been busy! Percona is a leading provider of unbiased, performance-first, [...]
January 5, 2024
Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL
The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest [...]
Want to get weekly updates listing the latest blog posts?
Subscribe now and we'll send you an update every Friday at 1pm ET.
January 4, 2024
MySQL General Tablespaces: A Powerful Storage Option for Your Data
Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This [...]
January 3, 2024
PMM Dump GUI in Percona Monitoring and Management 2.41.0
A couple of weeks ago, we announced the first GA release of the PMM Dump: a new support tool that [...]
January 3, 2024
The Various Methods to Backup and Restore ProxySQL
ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the [...]
January 2, 2024
Is Thread Pool Plugin the Right Choice for Your Workload?
TL&DR: Depending on the workload, the thread pool plugin can cause serious performance drops. This post was motivated by two [...]
January 2, 2024
Audit DROP Statements in Percona Server for MySQL
Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal [...]
December 29, 2023
Human Factors Behind Incidents: Why Settings Like “idle_session_timeout” Can Be a Bad Idea
PostgreSQL 14 introduced the parameter [crayon-65a1cbaf262a4741585002-i/], and, unfortunately, many DBAs jumped to start using it without understanding or by ignoring [...]
December 28, 2023
Introducing the MySQL Audit Log Filter Plugin
We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in [...]
December 27, 2023
Cloud Native Predictions for 2024
The evolution of cloud-native technology has been nothing short of revolutionary. As we step into 2024, the cornerstone of cloud-native [...]
December 26, 2023
Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor
This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL [...]
December 22, 2023
What’s New in Percona Toolkit 3.5.6
Percona Toolkit 3.5.6 was released on December 21, 2023. This blog post covers the main changes in this release. New [...]
December 22, 2023
The Pros and Cons of Wildcard Indexes on MongoDB
MongoDB is a schemaless database that is extremely flexible. When you create a collection, you don’t have to specify a [...]
December 21, 2023
Percona Monitoring and Management High Availability – A Proof of Concept
Percona Monitoring and Management (PMM) is a state-of-the-art piece of software that exists in part thanks to great open source [...]