article thumbnail

Percona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB

Percona

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

article thumbnail

PMM Is Getting a Modernized Enterprise-Grade Foundation

Percona

If PMM’s use of CentOS 7 has prevented you from using the most popular open source monitoring and management platform, then here’s a quick-start guide that will get you going in seconds! If you’re super impatient and don’t want to wait for us, there’s a migration path that I’ll outline at the end.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Missing Library: A pg_upgrade History

Percona

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. In this blog post, I will show you a particular example I faced when working with an upgrade exercise using pg_upgrade. If all is good, perform the upgrade removing the –check flag. Example case.

C++ 80
article thumbnail

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

Percona

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 done server stopped 16.

article thumbnail

Azure Well-Architected Framework: What it is and how to tame it with AI and automation

Dynatrace

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. The Dynatrace Application Security module automatically detects, assesses, and remediates open-source and third-party vulnerabilities for Java workloads.

Azure 178
article thumbnail

PostgreSQL Parameters: Scope and Priority Users Should Know

Percona

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

article thumbnail

MySQL Capacity Planning

Percona

Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. Conclusion Capacity planning is not something you do once a year or more as part of a general exercise.

Traffic 88