Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 15, 2024
Understanding Cloud-Native Databases: An In-Depth Guide
A cloud-native database isn’t just a database that happens to be sitting in the cloud; it’s built from the ground [...]
February 13, 2024
PostgreSQL Column Alignment and Padding – How To Improve Performance With Smarter Table Design
In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or [...]
February 9, 2024
Can Disk Space Be Saved in MySQL by Adding a Primary Key?
Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day [...]
February 7, 2024
Decoupling Backup and Expiry Operations in PostgreSQL With pgBackRest
Backup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration [...]
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 [...]
February 6, 2024
Are Your MySQL Users Using ‘password’ or ‘thebossisajerk’ as Passwords?
Are your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security [...]
February 5, 2024
Five Notable Changes in Percona Everest Alpha
Percona Everest is a cloud-native database platform to deploy and manage enterprise-grade PostgreSQL, MongoDB, and MySQL database clusters. Percona Everest [...]
February 2, 2024
Considering a MongoDB Migration? Why Percona Should Be Your First Choice
As a DBA or database architect, you’re well-acquainted with the offerings of MongoDB Community Edition, MongoDB Enterprise, and MongoDB Atlas. [...]
February 2, 2024
What is Transparent Data Encryption (TDE)? The Ultimate Guide
This blog was originally published in December of 2022 and updated in February of 2024. Encrypting data at rest in [...]
February 2, 2024
Segmentation Fault – A DBA Perspective
Segmentation fault - A DBA perspective INTRODUCTION On occasions, DBAs come across segmentation fault issues while executing some queries. However, [...]
February 1, 2024
Understanding Replication in PostgreSQL – How to Set Up PostgreSQL Streaming Replication
This blog was originally published in September 2018 and was updated in Feburary of 2024 Configuring replication between two databases [...]
February 1, 2024
MySQL vs PostgreSQL: Key Features and Use Cases
This blog was originally published in June of 2023 and updated in February of 2024. For more than a quarter [...]
February 1, 2024
Choosing the Best MySQL High Availability Solution: 20 Key Questions and Considerations
This blog was originally published in June 2016 but was updated in February 2024. In this blog post, we’ll look [...]
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 30, 2024
Master PostgreSQL Upgrades: The Ultimate Checklist
Are you planning to upgrade your PostgreSQL database but feeling overwhelmed by the complexity of the task? We have something [...]
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 24, 2024
An Introduction to Vector Databases
Imagine that winter is coming to the south of the planet, that you are going on a vacation trip to [...]
January 18, 2024
Syscalls Analysis in MySQL When Using innodb_flush_method and innodb_use_fdatasync
In this blog post, we will discuss how to validate at the operating system level the effects of changing the [...]
January 17, 2024
Quick Peek: MySQL 8.0.36 and 8.3
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what [...]
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, [...]