Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
October 10, 2018
Instrumenting Read Only Transactions in InnoDB
Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only [...]
October 10, 2018
MongoDB Replica set Scenarios and Internals – Part 1
The MongoDB® replica set is a group of nodes with one set as the primary node, and all other nodes [...]
October 9, 2018
Announcement: Second Alpha Build of Percona XtraBackup 8.0 Is Available
The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due [...]
October 8, 2018
Persistence of autoinc fixed in MySQL 8.0
The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided [...]
October 8, 2018
Detailed Logging for Enterprise-Grade PostgreSQL
In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled [...]
October 5, 2018
PostgreSQL Extensions for an Enterprise-Grade System
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, [...]
October 5, 2018
MongoDB-Disable Chained Replication
In this blog post, we will learn what MongoDB chained replication is, why you might choose to disable it, and [...]
October 4, 2018
The Importance of mysqlbinlog –version
When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the [...]
October 3, 2018
Finding Table Differences on Nullable Columns Using MySQL Generated Columns
Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the [...]
October 2, 2018
CRITICAL UPDATE for Percona XtraDB Cluster users: 5.7.23-31.31.2 Is Now Available
To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are [...]
October 2, 2018
Scaling PostgreSQL using Connection Poolers and Load Balancers for an Enterprise Grade environment
In the previous blog posts in this series, we’ve covered some of the essential aspects of an Enterprise-grade solution: security, [...]
October 1, 2018
ClickHouse: Two Years!
Following my post from a year ago about ClickHouse I wanted to review what happened in ClickHouse since then. There [...]
October 1, 2018
How To Fix MySQL Replication After an Incompatible DDL Command
MySQL supports replicating to a slave that is one release higher. This allows us to easily upgrade our MySQL setup [...]
September 28, 2018
High Availability for Enterprise-Grade PostgreSQL Environments
High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of [...]
September 28, 2018
Scaling Percona Monitoring and Management (PMM)
Starting with PMM 1.13, PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU [...]
September 26, 2018
Percona XtraDB Cluster 5.7.23-31.31 Is Now Available
This release has been superseded by 5.7.23-31.31.2 after a critical regression was found. Please update to the latest release. Percona [...]
September 25, 2018
Upcoming Webinar Thurs 9/27: Best Practices Using Indexes in MongoDB
Please join Percona’s Principal Architect Alex Rubin as he presents Best Practices Using Indexes in MongoDB on Thursday, September 27th [...]
September 21, 2018
Securing PostgreSQL as an Enterprise-Grade Environment
In this post, we review how you can build an enhanced and secure PostgreSQL database environment using community software. We [...]
September 18, 2018
Percona XtraDB Cluster 5.6.41-28.28 Is Now Available
Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads [...]
September 18, 2018
Monitoring Processes with Percona Monitoring and Management
Please note: This blog refers to Percona Monitoring and Management v1. For information on v2, please visit Understanding Processes Running [...]