Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 4, 2019
Percona XtraDB Cluster 5.7.24-31.33 Is Now Available
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available [...]
January 3, 2019
Upcoming Webinar Friday 1/4: High-Performance PostgreSQL, Tuning and Optimization Guide
Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his High-Performance PostgreSQL, Tuning and Optimization Guide on Friday, [...]
December 21, 2018
Backup and Restore a PostgreSQL Cluster With Multiple Tablespaces Using pg_basebackup
pg_basebackup is a widely used PostgreSQL backup tool that allows us to take an ONLINE and CONSISTENT file system level [...]
December 20, 2018
Percona Database Performance Blog 2018 Year in Review: Top Blog Posts
Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. The closing of a year [...]
December 13, 2018
MongoDB Backup: How and When To Use PSMDB hotbackup and mongodb_consistent_backup
We have many backup methods to backup a MongoDB database using native mongodump or external tools. However, in this article, [...]
December 10, 2018
Percona XtraBackup 8.0.4 Is Now Available
Percona is glad to announce the release of Percona XtraBackup 8.0.4 on December 10, 2018. You can download it from our download site and apt and yum [...]
December 7, 2018
MySQL 8 and The FRM Drop… How To Recover Table DDL
… or what I should keep in mind in case of disaster To retrieve and maintain in SQL format the [...]
December 5, 2018
Nondeterministic Functions in MySQL (i.e. rand) Can Surprise You
Working on a test case with sysbench, I encountered this: [crayon-691104c2d3567102758206/] I was really surprised. First, and the most important, [...]
December 4, 2018
MongoDB 4.0: Using ACID Multi-Document Transactions
MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article we’re going to [...]
November 30, 2018
PostgreSQL Streaming Physical Replication With Slots
PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead [...]
November 29, 2018
MySQL High Availability: Stale Reads and How to Fix Them
Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how [...]
November 28, 2018
Setting innodb_open_files Higher Than open_files_limit
The settings of MySQL configuration variables have a fundamental impact on the performance of your database system. Sometimes it can [...]
November 26, 2018
Upcoming Webinar Thurs 11/29: Improve MongoDB Performance with Proper Queries
Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt, as he presents Improve MongoDB Performance with Proper Queries on Thursday, [...]
November 25, 2018
See Percona CEO Peter Zaitsev’s Keynote at AWS re:Invent: MySQL High Availability and Disaster Recovery
Join Percona CEO Peter Zaitsev at AWS re:Invent as he presents MySQL High Availability and Disaster Recovery on Tuesday, November [...]
November 23, 2018
Compression Options in MySQL (Part 1)
Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data [...]
November 22, 2018
Caveats With pt-table-checksum Using Row-Based Replication, and Replication Filters
As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the [...]
November 21, 2018
Identifying Unused Indexes in MongoDB
Like MySQL, having too many indexes on a MongoDB collection not only affects overall write performance, but disk and memory [...]
November 19, 2018
Installing and Configuring JIT in PostgreSQL 11
Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement [...]
November 16, 2018
PostgreSQL Minor Versions: Time to Update!
In this blog post we’ll look at what the newly-released PostgreSQL minor versions contain. You probably want to update your [...]
November 15, 2018
How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse
Let’s talk about MySQL high availability (HA) and synchronous replication once more. It’s part of a longer series on some high [...]