Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 18, 2019
Give Love to Your SSDs – Reduce innodb_io_capacity_max!
The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this [...]
December 17, 2019
Percona Backup for MongoDB in Action
We recently released Percona Backup for MongoDB(PBM) as GA. It’s our open source tool for taking a consistent backup of [...]
November 22, 2019
MySQL UUIDs – Bad For Performance
If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are [...]
November 15, 2019
Don’t Use MongoDB Profiling Level 1
TLDR: It is not profile level 1 that is the problem; it’s a gotcha with the optional ‘slowms’ argument that [...]
November 11, 2019
Prepare Your Databases for High Traffic on Black Friday
It’s November, so we all know what that means; it’s peak shopping season, and no date is bigger than Black [...]
November 8, 2019
Configure HAProxy with PostgreSQL Using Built-in pgsql-check
We discussed one of the traditional ways to configure HAProxy with PostgreSQL in our previous blog about HAProxy using Xinetd. [...]
November 1, 2019
Use MySQL Without a Password (and Still be Secure)
Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to [...]
October 31, 2019
PostgreSQL Application Connection Failover Using HAProxy with xinetd
Recently we published a blog about a very simple application failover using libpq features which could be the simplest of [...]
October 7, 2019
Centralization Vs. Decentralization of DBA Teams
As a Technical Account Manager (TAM), I have seen many of our clients adopt a decentralized DBA Team. In many [...]
October 4, 2019
Percona XtraDB Cluster 8.0 (experimental release) : SST Improvements
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make [...]
October 3, 2019
Percona XtraDB Cluster 8.0 New Feature: wsrep_sst_auth Removal
The problem In PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user [...]
October 1, 2019
Experimental Binary of Percona XtraDB Cluster 8.0
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is [...]
September 26, 2019
Running Percona XtraDB Cluster on Raspberry PI 3
In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show [...]
September 23, 2019
Why Database Schema Optimization Matters
If you have been around MySQL for any length of time, you are probably aware that choosing the correct data [...]
September 23, 2019
Percona Backup for MongoDB 1.0.0 GA Is Now Available
Percona is happy to announce the GA release of our latest software product Percona Backup for MongoDB 1.0.0 on September [...]
September 18, 2019
Percona XtraDB Cluster 5.7.27-31.39 Is Now Available
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from [...]
September 17, 2019
Percona XtraDB Cluster 5.6.45-28.36 Is Now Available
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from [...]
August 13, 2019
SET PERSIST in MySQL: A Small Thing for Setting System Variable Values
To set correct system variable values is the essential step to get the correct server behavior against the workload. In [...]
August 5, 2019
MongoDB: Impact-free Index Builds using Detached ReplicaSet Nodes
Creating an index on a MongoDB collection is simple; just run the command CreateIndex and that’s all there is to [...]
July 17, 2019
MySQL: Disk Space Exhaustion for Implicit Temporary Tables
I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious [...]