Database Performance Blog – Percona

It’s National Video Game Day! Whether you love the thrill of high action, immersion into an alternative world, or the challenge of mastering a skill, there’s a game out there for everyone. In gaming, it’s all about a seamless user experience, but behind the game is a complex infrastructure that relies on databases to […]

Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit.
Now, what happens when that doesn’t happen?
In this simple blog, I’m going to show you something interesting that happens when you try to transition from a compressed […]

We all know how important it is to have a proper index in the database in order to do its job effectively. We have been using indexing in our daily life to import daily tasks, without index all tasks would be completed but in a relatively long time.
The basic working of index
Imagine that we […]

Replication sits at the core of database high availability (HA). While on-disk data can be replicated through various methods, whether hardware or software, disk, file, or block-based solutions, without an online copy of the database, HA setup cannot be achieved.
This blog digs into more detail the challenges/conflicts that impact PostgreSQL replication, but before we […]

We highly value security here at Percona, and in this blog post, we will show how to protect your Percona Monitoring and Management (PMM) Server with an SSL certificate and automate its lifecycle by leveraging a proxy server.
Introduction
As you may know, PMM Server provides a self-signed SSL certificate out-of-the-box to encrypt traffic between the […]