PMM Optimizations, Updated Percona Server for MongoDB, proxysql-admin Tool: Release Roundup 2/17/2020

Percona Software Releases

It’s release roundup time here at Percona!
Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself.
Today’s post includes those which have come […]

Read more

How to Run Orchestrator on FreeBSD

In this post, I am going to show you how to run Orchestrator on FreeBSD. The instructions have been tested in FreeBSD 11.3 but the general steps should apply to other versions as well.
At the time of this writing, Orchestrator doesn’t provide FreeBSD binaries, so we will need to compile it.
Preparing the Environment
The first […]

Read more

Introduction to MySQL 8.0 Recursive Common Table Expression (Part 2)

MySQL 8.0 Recursive Common Table Expression

This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table Expression. SQL is generally poor at recursive structures, but it […]

Read more

Compression of PostgreSQL WAL Archives Becoming More Important

Compression of PostgreSQL WAL Archives

As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up.
Old Limitations
There were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores were “High End” and as a DBA, my biggest worry was […]

Read more