Percona's MySQL & InnoDB performance and scalability blog
91k followers 7 articles/week
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 is being locked away by changing licenses and code that you depended on. You either get to pay for the privilege of having less freedom or find yourself sequestered with rapidly aging software.Before open source was available,...

Fri Sep 22, 2023 16:41
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 – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. Percona has sponsored this show for many years, provided presenters, and participated in the expo...

Thu Sep 21, 2023 16:16
How to Read Simplified SHOW REPLICA STATUS Output

As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding the binary log coordinates. I have seen confusion amongst new DBAs on which binary log file...

Wed Sep 20, 2023 16:51
Avoid Surprises When Restarting MySQL — Ensure Dynamic Changes Won’t Be Lost

If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance.Here’s a brief story of how this could happen, to make it clearer:You’re a DBA managing a few MySQL servers. The application using one of...

Wed Sep 20, 2023 15:21
Percona Distribution for PostgreSQL 16 Is Now Available

PostgreSQL Community released PostgreSQL 16 on September 14, 2023.  In years past, we’ve released our Distribution for PostgreSQL a few months later.  We wanted to improve in this regard and establish a new release baseline. Improving quality while maintaining the same resilience towards QA was something we aimed for. It looks like we succeeded, and...

Tue Sep 19, 2023 17:19
Use Physical Backups With MySQL InnoDB Redo Log Archiving

In the world of data backup and security, physical backups play an extremely important role. Physical backup methods are faster than logical because they involve only file copying without conversion. This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur.Physical backups are the backups that...

Tue Sep 19, 2023 15:29

Build your own newsfeed

Ready to give it a go?
Start a 14-day trial, no credit card required.

Create account