Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 27, 2020
Generating Numeric Sequences in MySQL
What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement [...]
July 24, 2020
MongoDB: Utilization of an Index on Subdocuments
MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index [...]
June 29, 2020
Percona Server for MySQL Highlights – Extended Slow Query Logging
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server [...]
June 29, 2020
Security Threat Tool Design in Percona Monitoring and Management
Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated [...]
June 2, 2020
Intro to Grafana Plugin Development
The frontend part of Percona Monitoring and Management (PMM) is a set of extensions for Grafana, and the Grafana documentation [...]
May 21, 2020
Failover of Logical Replication Slots in PostgreSQL
Missing Piece: Failover of the Logical Replication Slot Logical decoding capability has existed in PostgreSQL for the last several versions, [...]
April 27, 2020
How Do Ansible Tags Work?
One of the most confusing Ansible features is the tags, and in this blog, I will try to clarify how [...]
March 9, 2020
Using Different Versions of a Package in an Application via Go Modules
Sometimes you need to write an application that should use different versions of the same package, for example, the ability [...]
February 19, 2020
Webinar 2/26: Building a Kubernetes Operator for Percona XtraDB Cluster
This talk covers some of the challenges we sought to address by creating a Kubernetes Operator for Percona XtraDB Cluster, [...]
February 7, 2020
Webinar 2/19: 17 Things Developers Need to Know About Databases
Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, [...]
February 3, 2020
ClickHouse and MySQL – Better Together
It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, [...]
January 21, 2020
Ever Heard of Postgres?
Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of [...]
January 2, 2020
Implementing a Database Center of Excellence
In your organization, who decides what database platform will be utilized for that new application being built? For many groups, [...]
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 [...]
October 29, 2019
Column Histograms on Percona Server and MySQL 8.0
From time to time you may have experienced that MySQL was not able to find the best execution plan for [...]
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 19, 2019
Upcoming Webinar 7/23: 10 Common Mistakes Java Developers Make when Writing SQL
Please join Percona’s Senior Support Engineer Charly Batista as he presents “10 Common Mistakes (Java) Developers Make when Writing SQL” [...]
June 26, 2019
Stored Functions and Temporary Tables are Not a Good Fit
In this blog post, I am going to show why we have to be careful with stored functions in select [...]