Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 6, 2024
MySQL 8.2.0 Community vs. Enterprise; Is There a Winner?
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because [...]
January 31, 2024
MySQL Table Size Is Way Bigger After Adding a Simple Index; Why?
It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. [...]
January 25, 2024
Decoding Sequential Scans in PostgreSQL
In every database product, sequential scans or full table scans are often resource consuming, so almost all the developers and [...]
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, [...]
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 [...]
November 13, 2023
Database Upgrades: DIY or Choose a Database Upgrade Consulting Service?
To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End [...]
November 7, 2023
Book Review: PostgreSQL 14 Internals by Egor Rogov
The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to [...]
November 6, 2023
Quick Peek: MySQL 8.2 and 8.0.35
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at [...]
November 3, 2023
How To Scale a Single-Host PostgreSQL Database With Citus
When it comes to Citus, successfully building out and scaling a PostgreSQL cluster across multiple nodes and even across data [...]
October 31, 2023
Percona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB
Percona has a mission to provide the best open source database software, support, and services so our users can innovate [...]
October 5, 2023
Announcing the Alpha Release of Percona Everest: An Open Source Private DBaaS
Today’s businesses face two major challenges when it comes to managing databases: vendor lock-in of public cloud providers and the [...]
October 4, 2023
What’s New in Percona Toolkit 3.5.5
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release. pt-online-schema-change [...]
October 3, 2023
Transparent Huge Pages Refresher
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While [...]
September 22, 2023
You Need to Actively Support Open Source Software or It Will Disappear
Percona is dedicated to open source software. But recently, open source software has come under attack. Once open source software [...]
September 21, 2023
Why You Need To Be at the Southern California Linux Expo
You can show your support for open source software by participating in an event next March in Pasadena, California – [...]
August 30, 2023
PostgreSQL Parameters: Scope and Priority Users Should Know
This blog was published in August 2023 and updated in April 2024. PostgreSQL allows its users to set parameters at [...]
August 30, 2023
Backup and Recovery for Databases: What You Should Know
People used to say, “Coal is king,” and for decades, it was. Coal powered just about everything, but mismanagement and [...]
August 29, 2023
Data Redundancy With the PostgreSQL Citus Extension
Over the years, I’ve had the opportunity to architect all sorts of configurations using Postgres as a backend. I’ve always [...]