Percona

Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL

Enable data-at-rest encryption in Percona Server for MySQL 8.0.30+ with AWS KMS. Manage cryptographic keys easily across AWS services.

MySQL General Tablespaces: A Powerful Storage Option for Your Data

MySQL general tablespaces are user-defined storage containers for multiple InnoDB tables that provide flexibility in data organization and performance optimization.

PMM Dump GUI in Percona Monitoring and Management 2.41.0

We have introduced a new feature for PMM that allows you to collect the necessary data about your database performance with just one click.

The Various Methods to Backup and Restore ProxySQL

The backup and restore of ProxySQL Configurations can be performed by using the following methods Config file backup, mysqldump, and physical snapshot.

Is Thread Pool Plugin the Right Choice for Your Workload?

Performance can significantly decrease due to the thread pool plugin, depending on the workload. Here's what you need to know.

Audit DROP Statements in Percona Server for MySQL

The audit plugin is a powerful tool we have at our disposal in Percona Server for MySQL to trace all DROP events in the server and analyze them to understand if the behavior is normal.

Human Factors Behind Incidents: Why Settings Like “idle_session_timeout” Can Be a Bad Idea

PostgreSQL 14 introduced the parameter idle_session_timeout, and, unfortunately, it has become one of the most misused parameters in many PostgreSQL installations.

Introducing the MySQL Audit Log Filter Plugin

The MySQL Audit Log Filter, an upgraded audit plugin with enhanced functionality akin to MySQL Enterprise Audit, is now available in technical preview as of Percona Server for MySQL 8.0.34-26.

Cloud Native Predictions for 2024

As we look into what the next year holds, our attention is drawn to the 2024 cloud-native landscape and how it is maturing, growing, and evolving. 

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard.

What’s New in Percona Toolkit 3.5.6

Percona Toolkit 3.5.6 was released on December 21, 2023. This blog post covers the main changes in this release.

The Pros and Cons of Wildcard Indexes on MongoDB

How can we manage the creation of indexes on a collection where we cannot foresee the fields we could have? Let's look at Wildcard Indexes on MongoDB.

Percona Monitoring and Management High Availability – A Proof of Concept

Explore the key steps to attain Percona Monitoring and Management high availability, ensuring reliable and continuous monitoring of your database systems.

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Explore the benefits and challenges of using huge pages with PostgreSQL in a Kubernetes environment, with insights into optimizing database performance and practical tips for effective integration.

How to Monitor Online InnoDB Buffer Pool Resizing

The InnoDB buffer pool caches frequently accessed data and index pages in memory to accelerate performance. Here's how to monitor online InnoDB buffer pool resizing.

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

PG_TDE (PostgreSQL Transparent Data Encryption) is an experimental transparent data encryption access method for PostgreSQL 16, available on GitHub as an extension for vanilla PostgreSQL. Today, we'd like to share more details about the extension, including information about its internal architecture.

Setting Up Percona Monitoring and Management Alerts for External Channels (Telegram, Slack, WebHook)

Setting up Percona Monitoring and Management alerts for well-known communication platforms like Telegram, Slack, and WebHook can significantly enhance your monitoring strategy. Here's how.

Migrating from MySQL to PostgreSQL Using pgloader

Need to move from an existing DBMS platform to Postgres? Here's how to migrate from MySQL to PostgreSQL Using pgloader.

Percona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023

Percona software releases and updates December 4 - 18, 2023.

Exploring the Improved CREATEROLE Attribute for User Management in PostgreSQL 16

Discover the enhancements to the CREATEROLE attribute in PostgreSQL 16 and how it transforms the management of users and roles by its improved integration with the database's privilege and authentication systems.

Why Choose a Third-Party Database Migration Service

Find out how and why a third-party database migration service can ease the process of migrating from a proprietary to an open source database.

How To Scale a Single-Host PostgreSQL Database With Citus

Explore architectural design considerations for scaling out your PostgreSQL database system using Citus, a freely downloadable and fully featured extension.

Best Practices for a Seamless MongoDB Upgrade

Elevate your database's performance and security with our guide to MongoDB upgrade best practices.

Top 3 Questions From Percona k8s Squad Ask-Me-Anything Session

The Percona Kubernetes Squad held the first AMA session to address inquiries regarding the utilization of Kubernetes for database deployment. Here are the top three questions raised during the session.

Percona Operators Deployment Explained: Delving Into Cluster-Wide vs. Namespace-Scoped

Percona Operators come with cluster-wide and namespace-scope deployments, and this blog looks at the differences for security, availability, and performance.

Is ANALYZE TABLE Safe on a Busy MySQL Database Server?

As long as your database runs on the most recent version of MySQL or MariaDB variant, running ANALYZE TABLE should be safe and not cause any unexpected stalls.

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

To continue creating added benefits for our users and customers, we are adding telemetry directly to our core database products. Learn why.

Percona Monitoring and Management 2.40.1, Percona Distribution for MongoDB 6.0.11: Release Roundup October 31, 2023

Percona software releases and updates October 16 - 31, 2023.

Resolving Data Drift in a Dual-Primary Topology With Replica in MySQL/MariaDB

Maintaining a dual-primary topology can be a difficult, but the tools pt-table-checksum and pt-table-sync are essential for resolving these issues and for efficient verification.

Database Migration Plan: Avoiding Common Pitfalls in Open Source Migration

Understand the most common pitfalls with database migration, learn how to avoid them, & learn how to create an effective open source database migration plan.

Scalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus

In part two of this series, we will use the worker nodes from part one to establish a multi-node Citus cluster with Percona Distribution PostgreSQL 15 and implement sharding techniques.

Scalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances

The first installment of Scalable Solutions with Percona Distribution for PostgreSQL where we demonstrate how to establish a Citus database spanning multiple nodes.

Our Kudos to All Percona Community Contributors

We would like to highlight the most active contributors to Percona software during 2023 and say thank you.

From Proprietary to Open Source: The Complete Guide to Database Migration

Learn everything you need to know about database migration from proprietary to open source, including tools you'll need to use and steps you'll need to take.

Reduce RPO, Encrypt Backups, and More in 1.15.0 Release of Percona Operator for MongoDB

Percona Operator for MongoDB v.1.15.0 comes with enhancements like RPO with PITR for and Server-Side Encryption (SSE) for backups.

5 Changes You Should Know in MongoDB 7.0

MongoDB 7.0 brought several changes in this new release, and these are the ones we believe might directly impact your daily operations.

Using CLONE INSTANCE With DATA DIRECTORY on Replicas With Data

Using the MySQL CLONE INSTANCE  command with the safety option DATA DIRECTORY  when you do not have enough disk space to store two datasets.

Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test

Since PostgreSQL doesn't have TDE features yet, PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that Percona wants to provide.

Percona Monitoring and Management 2.40.0, Percona Server for MongoDB 7.0.2-1 (RC): Release Roundup October 16, 2023

Percona software releases and updates October 2 - 16, 2023.

Debugging MySQL Core File in Visual Studio Code

Visual Studio Code (VS) supports memory dump debugging via the C/C++ extension in MySQL. Here's how to do it.

Comprehensive Insights Into SDI in MySQL 8.0

Serialized dictionary information (SDI) files in MySQL 8 store serialized metadata about database objects such as tables, indexes, and other schema-related details.

Kubernetes Observability: Code Profiling With Flame Graphs

Due to container complexity and security aspects, it’s challenging to achieve Kubernetes observability. However, kubectl-flame can automate profiling gathering.

MongoDB Queries Slow Due to Flow Control but No Replication Lag?

Ever encountered MongoDB queries delayed by Flow Control but found no lagged secondaries? Here's one possible reason why.

Deep Dive Into Roles in MySQL 8.0

Roles are used to distribute privileges in MySQL databases and can help simplify the management overhead and complexity of your access control system.

Migrate Data From Atlas to Self-Hosted MongoDB

Step-by-step instructions on how to install and utilize MongoShake for data migration from Atlas to self-hosted MongoDB.

Percona Server for MongoDB 7 Is Now Available

We are happy to announce the availability of Percona Server for MongoDB 7, a drop-in replacement solution for MongoDB Community Edition, with additional features.

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Demonstrating the process of applying MySQL schema changes on K8s by using K8s Jobs and the pt-online-schema-change utility.

Share Your DBaaS Opinion, Get Some Swag

Help us shape the future of Percona Everest, our DBaaS solution that enables users to deploy and manage databases regardless of their preferred environment.

PostgreSQL Tuple-Level Statistics With pgstattuple

Learn how the pgstattuple extension can be used for tuple-level analysis and finding bloated tables or vacuuming candidates.

Announcing the Alpha Release of Percona Everest: An Open Source Private DBaaS

Percona is thrilled to unveil Percona Everest, a revolutionary open source private Database as a Service (DBaaS) solution.

PostgreSQL Role Inheritance in Reverse: Discovering Descendant Roles in Reverse Gear

The role_inheritance_reverse function allows you to explore role inheritance in reverse, uncovering all the roles that inherit from a specific role.

What’s New in Percona Toolkit 3.5.5

Learn more about the October 3, 2023 release of Percona Toolkit 3.5.5, a collection of advanced open source command-line tools.

PostgreSQL Job Scheduler: pg_timetable

pg_timetable is a completely database-driven way to schedule jobs in PostgreSQL. Here, we highlight some of its main features, installation, and use cases.

Transparent Huge Pages Refresher

Discussing the Transparent Huge Pages memory management feature, its impact on database servers, and how to disable it for optimal performance.

Percona Toolkit – A Quick Introduction to Summary

For an example of what the Percona Toolkit offers, look at the output from pt-summary. This is a handy way to determine the basic parameters that the server is using.

Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

Percona software releases and updates September 18 - October 2, 2023.

Using MySQL Offline Mode To Disconnect All Client Connections

MySQL has a variable called offline_mode to set the server into maintenance mode, which immediately disconnects all client connections.

Don’t Start Using Your MySQL Server Until You’ve Configured Your OS

Reviewing the best practices for optimization we follow in Percona Managed Services before using a MySQL server in production and stage environment.

Replace a Live Mongo Node With a New Node

Comprehensive guide to replacing a live MongoDB node with a new node to avoid a disk getting full or decommissioned.

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

pg_partman is an extension used to create and manage both time-based and serial-based table partition sets in PostgreSQL.

Putting the Fun in MySQL Functional Indexes

Functional Indexes, like other indexes, are a handy way to speed up queries, but be sure to test them with EXPLAIN to ensure the optimizer knows to use them.

Quick Guide to SQL Joins

An easy way to visualize the data captured by various joins using Venn diagrams and their SQL equivalent.

Updated Versions of Percona Distribution for PostgreSQL, Percona XtraDB Cluster: Release Roundup September 4, 2023

Percona software releases and updates August 21 - September 4, 2023.

PostgreSQL for MySQL DBAs Episode 13: Inheritance

Inheritance in PostgreSQL can be a useful way to normalize data, but you need to know that the data does not propagate by itself through the family tree in the way you expect.

PostgreSQL Parameters: Scope and Priority Users Should Know

PostgreSQL parameters can be set at different scopes, and the same one can be specified at different places with different methods. Here are the options.

Backup and Recovery for Databases: What You Should Know

Covering all the elements of database backup and disaster recovery, and proven solutions for maintaining business continuity.

Data Redundancy With the PostgreSQL Citus Extension

The Citus extension horizontally scales PostgreSQL across multiple machines by sharding and creating redundant copies of tables.

Bootstrap PostgreSQL on Kubernetes

Explore the immense value of provisioning PostgreSQL clusters with Percona Operator by using bootstrap capabilities for increased productivity and faster time-to-market.

Failover and Recovery Scenarios in InnoDB Cluster and ClusterSet

Scenarios and methodologies that are very useful to recover cluster nodes and perform some manual failovers in both InnoDB Cluster and Innodb ClusterSet-related environments.

Automated Percona Monitoring and Management Upgrades

How to install, configure, and automate the update process for your Percona Monitoring and Management Server and Client.

The Deprecation of qpress/QuickLZ Compression Algorithm

Percona XtraBackup 8.0.34-29 removes qpress/QuickLZ and makes Zstandard the default compression algorithm for the --compress option.

High Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache?

The shared attributes and differences of high availability and fault tolerance and how to meet your unique requirements for achieving continuous uptime.

Configuring PostgreSQL and LDAP Using StartTLS

How to enable a TLS between a PostgreSQL and the OpenLDAP server.

Updated Percona Distributions for MongoDB, Metadata Table for QAN in PMM: Release Roundup August 21, 2023

Percona software releases and updates August 7 - 21, 2023.

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

Here, we will configure multiple MySQL instances from the generic binaries and manage them using systemd.

Want to Migrate From MariaDB 10.4 to MySQL 8.0 but Facing Hurdles? MySQL 5.7 to the Rescue!

The introduction of a MySQL 5.7 intermediate replica proved to be helpful in migrating from MariaDB 10.4 to MySQL 8.0.

InnoDB ClusterSet Deployment With MySQLRouter

Using InnoDB ClusterSet to provide disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations.

What Is PostgreSQL Used For?

PostgreSQL is open source database software for data management, app development, and analytics in private, commercial, or academic industries.

Streamline the SQL Code: Guide to pgFormatter

Using this guide to pgFormatter, you can achieve consistently formatted, clean, and readable SQL code, improving productivity and reducing errors.

The Future of Open Source is Polarized

While some companies state that changing licenses away from open source is an industry trend, the community sees it as a hostile step.  

An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions

Discover the ins and outs of MySQL replication in this detailed guide. Learn setup, types, benefits, and best practices to streamline your database management.

MySQL 8.0.34 Improved Password Management by Defining the Change Characters Count

Learn how changes in MySQL 8.0.34 improve password validations and add more security when changing the users' passwords.

Exploring MySQL 8 New Transaction Data Dictionary: Storing Information About Database Objects

The primary goal of the MySQL 8 Transaction Data Dictionary is to enhance the overall performance, stability, and scalability of MySQL databases.

Provisioning Replication With Clone Plugin

How to configure a new MySQL replica using the clone plugin, introduced in MySQL 8.0.17 as a convenient method for cloning data.

MySQL Capacity Planning

MySQL capacity planning is not something you do once a year; it’s part of a regular day-to-day activity for DBAs.

Percona Backup for MongoDB 2.2.1, Updates to Percona Distribution for MySQL, : Release Roundup August 7, 2023

Percona software releases and updates July 24 - August 7, 2023.

Understanding the Differences Between InnoDB Undo Log and Redo Log

The differences between InnoDB undo log and redo log, exploring their significance, and providing code examples to illustrate their usage.

The Ultimate Guide to MySQL Partitions

In this blog, we provide a comprehensive guide to understanding MySQL partitioning, including how it works, the various types of MySQL partitions, and more!

Custom Percona Monitoring and Management Dashboards

This post shows you how to create custom PMM dashboards based on data stored inside MySQL. You'll be able to create application dashboards.

Database Server Lifecycle for MySQL and MariaDB

Peter Zaitsev takes a look at the lifecycle and release management for MySQL and MariaDB servers, where we are now, and some relevant historical background.

The Invisibilities in MySQL 8.0

A couple of pretty new features in MySQL 8.0 (and one old one): Invisible columns, Generated invisible primary keys, and Invisible indexes.

MySQL 5.7 to 8.0 Upgrade – In-Place or Logical Upgrade?

With MySQL 5.7 End of Life two months away, those of you who have waited may be wondering which is the best way to upgrade - an In-Place or Logical upgrade.

How to Monitor Your MySQL Database Restore Progress

Discussing two distinct and effective methods to calculate the percentage progress of the MySQL restore process.

MongoDB Security: Top Security Concerns and Best Practices

Address top MongoDB security concerns and adopt best practices. Safeguard your data with expert strategies for enhanced protection. Learn how in our blog.

How to ALTER a VARCHAR Column Online in MySQL: Caveats and Solutions

In this blog, we explore the process of altering VARCHAR columns online, delving into insights gained while expanding the size of such columns.

Migrating From On-Prem to RDS MySQL/Aurora? DEFINERS Is the Answer

Using mysqldump, generating a single table, and creating objects which have a certain DEFINER to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS).

Dynamic SQL Workaround in MySQL: Prepared Statements

While MySQL lacks built-in support for dynamic SQL, this article presents a workaround using prepared statements.

Should You Keep Your Business Logic In Your Database?

Now is the time to see where you can use some of these techniques to start moving some of your business logic to the database.

LTS and Innovation Releases for Percona Server for MySQL

Yes, you can expect to see LTS and Innovation releases for Percona MySQL that will follow the same support lifecycle.

A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0

Taking a look at what Oracle delivered with MySQL 8.0.34 and 8.1.0 on July 17th, 2023.

Ten Recommendations for Running Your MongoDB Environment

MongoDB is the most-used NoSQL database. Here are ten essential techniques you can apply to make the most of MongoDB for your applications.

20X Faster Backup Preparation With Percona XtraBackup 8.0.33-28!

With Percona XtraBackup 8.0.33-28, xtrabackup --prepare is faster and more memory efficient with the dictionary cache, and the time taken for a new node to join the PXC Cluster is also significantly reduced.

Faster Streaming Backups – Introducing Percona XtraBackup FIFO Parallel Stream

Percona XtraBackup 8.0.33-28 introduces a new datasink for true parallel streaming utilizing FIFO for faster streaming backups.

Announcing the Availability of Percona Backup for MongoDB 2.2.0

We are excited to announce the availability of Percona Backup for MongoDB 2.2.0, a fully supported, open source, community backup tool for MongoDB.

Upgrade to Grafana 9.2.20 in PMM 2.38, New Data Sink in Percona XtraBackup 8.0.33-28: Release Roundup July 24, 2023

Percona software releases and updates July 10 - 24, 2023.

How To Measure the Network Impact on PostgreSQL Performance

It is very common to see many infrastructure layers standing between a PostgreSQL database and the Application server.  The most common ones are connection poolers, load balancers, routers, firewalls, etc.  We often forget or take for granted the network hops involved and the additional overhead it creates on the overall performance. But it could cause […]

Deploy PostgreSQL on Kubernetes Using GitOps and ArgoCD

Learn how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD.

Update Percona Monitoring and Management Agent Settings for Already-Added Instances

How to edit some options after adding a remote MySQL instance to Percona Monitoring and Management without having to remove and re-add the instance.

Extensibility in MySQL Is Easy

Learn how to set up a build environment for compiling your own MySQL plugin to be loaded into MySQL as a function.

An Enterprise-Grade MongoDB Alternative Without Licensing or Lock-in

Want enterprise-grade MongoDB without the high cost of runaway licensing fees or restrictions of vendor lock-in? Consider Percona Software for MongoDB.

The Power of utf8mb4 in MySQL 8.0: Unleashing the Full Potential of Multilingual Data

MySQL recognizes the need to store and process multilingual data and has introduced utf8mb4 in MySQL 8.0.

MongoDB Version Requirements for Percona Backup for MongoDB

Percona Backup for MongoDB offers comprehensive support and ensures cluster-wide consistent backups for MongoDB without additional costs.

Percona Monitoring and Management 2.38, Updates to Percona Distribution for PostgreSQL: Release Roundup July 10, 2023

Percona software releases and updates June 26 - July 10, 2023.

Online Data Type Change in PostgreSQL

Taking a look at one possibility of changing the data type on a column in a big table with minimal impact.

Setting Up and Deploying PostgreSQL for High Availability

DBAs must take a piecemeal approach to achieve PostgreSQL high availability, bringing together open source extensions and tools from multiple sources. 

One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only

Covering the PostgreSQL scan types (depending on the table), what the queries are retrieving, and the used filters.

The Impacts of Fragmentation in MySQL

Fragmentation in MySQL is a common concern, and highly fragmented tables can affect performance and resource allocation. Here, we discuss fragmentation and its impact on InnoDB.

Upgrade MySQL to 8.0? Yes, but Avoid Disaster!

Should you upgrade MySQL to 8.0? 5.7 is nearing EOL; here's how to make the upgrade go smoothly.

PMM Is Getting a Modernized Enterprise-Grade Foundation

Starting with PMM 2.38.0, we’re making it publicly available on a newer base operating system based on Enterprise Linux 9 (EL9).

PostgreSQL Partitioning Using Traditional Methods

Discussing the default, traditional methods for PostgreSQL partitioning using single columns.

Exploring PostgreSQL Backup Strategies for Enterprise-Grade Environments

Everything you need to know about PostgreSQL backups for enterprise-grade environments. Gain valuable knowledge to safeguard your data.

Aurora vs RDS: How to Choose the Right AWS Database Solution

Looking for help choosing between Amazon Aurora vs RDS? Get expert guidance on selecting the perfect AWS database solution for your exact needs with this guide.

Announcing the General Availability of Percona Operator for PostgreSQL Version 2

Percona Operator for PostgreSQL version 2 simplifies the deployment and management of PostgreSQL clusters on Kubernetes.

Find the WAL Count Between Two Segments in PostgreSQL

Calculating the numerical difference between WAL files contributes to effective management and of the PostgreSQL database recovery/archiver processes.

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

How to install or upgrade a Percona Server for MySQL or MySQL 8 specific version on Debian in a test or production environment.

Should PostgreSQL Become Multi-Threaded?

Is it time to make PostgreSQL multi-threaded? Peter Zaitsev weighs in.

Database Teams Run Denver Marathon Relay at Percona Live 2023

Percona Live 2023 took place right after the Denver Marathon, so Percona Staff, Conference Attendees, and local community members took part in this event, and ran as four teams - MySQL, MongoDB, PostgreSQL, and MariaDB.

Ready-to-Use High Availability Architectures for MySQL and PostgreSQL

Percona high availability architectures for MySQL and PostgreSQL are proven to keep operations running optimally, even during peak usage or technical challenges.

Critical CVE Fix in PMM, Updates to Percona Distribution for MySQL: Release Roundup June 12, 2023

Percona software releases and updates May 29 - June 12, 2023.

Monitoring a PostgreSQL Patroni Cluster

Quick and easy guide to monitoring a PostgreSQL Patroni cluster using Percona Monitoring and Management.

Unleashing the Power of PostgreSQL Event-Based Triggers

Triggers on DDL events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema.

Conquering Mt. Elbert After Percona Live 2023 in Denver

Fresh from attending Percona Live in Denver, we set off on a journey to conquer Mt Elbert, standing proud at 14,438' (4400m).

PMM Authentication Bypass Vulnerability Fixed in 2.37.1

Today we’re releasing PMM 2.37.1 with a fix for CVE-2023-34409 that addresses the PMM authentication bypass vulnerability.

Configuring PgBouncer for Multi-Port Access

While PostgreSQL can sit on both a UNIX DOMAIN socket and IPv4, IPv6 port, etc., one is constrained to listen to just one port. With help from systemd, we can use PgBouncer with a concoction of configuration files.

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

WordPress turned 20 on May 27th. While not the first open source CMS, it caught on like nothing before and helped spread open source to millions.

Migrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft

Tips and tricks for successfully migrating from MariaDB to Percona Server for MySQL 8, with a focus on security.

Disaster Recovery for PostgreSQL on Kubernetes

Percona Operators provide a solution to streamline disaster recovery for PostgreSQL clusters running on Kubernetes.

Updates to Percona Distributions for PostgreSQL, Percona XtraDB Cluster, Percona XtraBackup: Release Roundup May 29, 2023

Percona software releases and updates May 8 - 29, 2023.

MySQL Connection Security With Connection Control Plugins

The MySQL connection control plugin can be very useful to limit the inconvenience of a brute force attack or unseemly TCP connections.

Backup and Restore with MyDumper on Docker

MyDumper now offers a simple and powerful way to migrate data in a MySQL dockerized environment.

MongoDB 4.2 EOL… And Its Implications

With MongoDB 4.2 reaching EOL in April, you should move away from it ASAP. This version has just become a possible threat to your security.

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

How you can use Percona Kubernetes Operator for MySQL and ProxySQL to build a sharded environment with a good level of automation.

Understanding Linux IOWait

Why looking at the “IOWait” portion of CPU usage to indicate whenever the system is I/O-bound is unreliable, and what better indicators you can use instead.

Restoring a Snapshot of a Sharded MongoDB Cluster to a Kubernetes-Based MongoDB Environment

How to restore a snapshot from a traditional VM-based sharded MongoDB cluster to a freshly deployed Percona Operator for MongoDB cluster on Kubernetes.

Vendor Lock-in: What It Is and How To Avoid It

Learn how you can have enterprise-grade open source software with the support of a global community — without vendor lock-in.

How To Start Logical Replication in PostgreSQL for Specific Tables Based on a pg_dump

Exploring the use of pg_dump and pg_restore for conducting the initial data synchronization in PostgreSQL.

Percona Monitoring and Management 2.37, Percona Distribution for MongoDB 5.0.17: Release Roundup May 8, 2023

Percona software releases and updates April 24 - May 8, 2023.

Percona Monitoring and Management 2.37: The Improved Inventory View, New Experimental Dashboards for Kubernetes Monitoring, and More!

Announcing Percona Monitoring and Management 2.37, which includes a revamped Inventory view, new experimental dashboards for Kubernetes monitoring, as well as many other improvements and new features.

MongoDB Database Backup: Best Practices & Expert Tips

In this blog post, we will discuss different MongoDB database backup best practices and strategies, their use cases, as well as the pros and cons of taking different types of backups.

How To Use pt-secure-collect for Capturing Data in a Secure Way From the OS and Database System

Pt-secure-collect from Percona helps capture required data securely while aiding in masking the existing information.

ChatGPT vs. MySQL DBA Challenge

Asking ChatGPT some questions that a MySQL DBA usually needs to answer in an interview process — and seeing how it does.

Save Money in AWS RDS: Don’t Trust the Defaults

Want to save money on your AWS RDS bill? I’ll show you some MySQL settings to tune to get better performance, and cost savings, with AWS RDS.

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

In this blog post, we cover PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance PostgreSQL performance.

Add More Security to Your Percona Server for MongoDB With AWS IAM integration!

The release of Percona Server for MongoDB 6.0.5-4 introduced improvements to the way we handle master key rotation as well as AWS IAM integration.

Open Source vs. Proprietary Database Software: What To Choose?

While open source refers to software that is free, modifiable, and shareable, proprietary software is licensed and copyrighted. Learn all the differences here.

Open Source Software Security: Is Open Source Software Safe?

Curious about open source software safety? Our blog provides a deep dive into the question: "is open source software safe?" and offers expert level insights.

Speeding Up Restores in Percona Backup for MongoDB

Time is of the essence when dealing with a database restore. Discover how Percona Backup for MongoDB can speed up restores and give you peace of mind.

PostgreSQL Indexes Can Hurt You: Negative Effects and the Costs Involved

Because indexes come with a cost in terms of performance and resource consumption, here's a list of 10 problems that PostgreSQL Indexes can cause.

How to Persist a Hashed Format Password Inside ProxySQL

Learn about the password formats inside ProxySQL and how to persist a hashed password inside the ProxySQL mysql_users table.

Percona XtraDB Cluster 8.0.32-24, Updated Percona Backup for MongoDB: Release Roundup April 24, 2023

Percona software releases and updates April 10 - 24, 2023.

Fixing Errant GTID With Orchestrator: The Easy Way Out

Exploring one of the easy features that can help us in fix errant GTID in a replication topology.

Upgrading to MySQL 8: Tools That Can Help

Some of the tools that are available to simplify the upgrade process when upgrading to MySQL 8.

Using Encryption-at-Rest for PostgreSQL in Kubernetes

How to use encryption-at-rest for PostgreSQL in Kubernetes, essential for compliance with regulations that require the protection of sensitive data.

A Workaround for The “RELOAD/FLUSH_TABLES privilege required” Problem When Using Oracle mysqldump 8.0.32

With Percona Server for MySQL 8.0.32-24, there is a solution for the “RELOAD/FLUSH_TABLES privilege required” problem when Using Oracle mysqldump 8.0.32.

Replication Issues and Binlog Compressor

Taking a look at the need for using binlog compression in MySQL and the potential issues it may cause.

InnoDB Performance Optimization Basics

These InnoDB performance optimizations work well for a wide range of applications, though the optimal settings do depend on the workload.

Why PostgreSQL Is a Top Choice for Enterprise-level Databases

Learn all the reasons why PostgreSQL is a top choice for enterprise-level databases.

Deploy Percona Monitoring and Management on Amazon EKS With eksctl and Helm

Learn how to install Percona Monitoring and Management in a Kubernetes cluster on Amazon EKS using Helm and eksctl.

Increase the Ability to Securely Replicate Your Data and Restrict Replication To Row-based Events in MySQL

By combining PRIVILEGE_CHECKS_USER and require_row_format, you can create a more secure replication environment in MySQL.

Multi-tenants and Branches in Neon Serverless PostgreSQL

Vadim Tkachenko covers two important concepts Neon serverless PostgreSQL operates with: Tenants and Data Branches.

Comparisons of Proxies for MySQL

After understanding of the environment, the needs, and the evolution that the platform needs to achieve it's possible to choose a MySQL proxy.

Percona Monitoring and Management 2 Scaling and Capacity Planning

We have tested Percona Monitoring and Management 2.33.0 with its default configuration, and it can monitor more than 1,000 MySQL services with no significant resource usage spikes!

Percona Labs Presents: Infrastructure Generator for Percona Database as a Service (DBaaS)

Introducing the Percona DBaaS Infrastructure Creator, or Percona My Database as a Service (MyDBaaS). Run Percona databases on Kubernetes, the easy way!

Automating Physical Backups of MongoDB on Kubernetes

Reviewing the technical decisions and obstacles we faced when implementing physical backup in Percona Operator for MongoDB version 1.14.0.

Using Docker To Deploy Neon Serverless PostgreSQL

Exploring the benefits of using Docker images for experimenting with serverless PostgreSQL and how to get started with them.

How To Set Up MySQL 8 Replica From Existing MySQL 5.7 Server With Percona XtraBackup

Step by step guide on how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup.

Percona Server for MySQL 5.7.41-44, Percona Distribution for MongoDB 4.2.24: Release Roundup March 13, 2023

Percona software releases and updates February 27 - March 13, 2022.

Capped Collection in MongoDB

Discussing the capped collection of MongoDB, which can be useful to store log file information as it’s close to the speed of writing log information directly to a file system without the index overhead.

Dealing With “Too Many Connections” Error in MySQL 8

One of the most common problems faced is “ERROR 1040 (08004): Too many connections”. Here are the new administrative connections allowed on MySQL 8, which can save us from restarting the instance.

Introducing Percona Builds for Serverless PostgreSQL

Announcing our collaboration with Neon to provide a Serverless PostgreSQL that you can control and manage yourself.

How To Calculate a Good MySQL Redo Log Size in MySQL 8

MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is?

Purging Data When the Table Is Big and Has Children Tables

Getting the MySQL error "Cannot delete or update a parent row: a foreign key constraint fails"? Percona has you covered.

Reduce Your Cloud Costs With Percona Kubernetes Operators

See how running databases on Kubernetes with Percona Operators can reduce your cloud bill when compared to using AWS RDS.

MySQL 5.7 End of Life Six Months Away – Switch to Percona Server for MySQL Today!

The official End of Life for MySQL 5.x is October 2023. With Percona Server for MySQL, you get all the MySQL 8.0 features, and more, for free.

Run Percona Server for MongoDB on Your ARM-based MacBooks and More

With the release of Percona Server for MongoDB 6.0.4, we’ve added native Docker container images for Arm64. These run without needing Rosetta 2 translation or emulation on your Arm-based Macs.

Percona Monitoring and Management 2.35, Percona Backup for MongoDB 2.0.4: Release Roundup February 27, 2023

Percona software releases and updates February 13 - 27, 2022.

PMM Access Control: A Comprehensive Guide With Use Cases and Examples

Looking to implement access control for Percona Monitoring and Management (PMM)? Our comprehensive guide has got you covered with use cases and real-world examples.

PMM V2.35: Label-based Access Control, General Availability of Helm Chart, and More!

Percona Monitoring and Management V2.35 released with a tech preview of label-based access control, the general availability of Helm Chart, among other improvements.

Reducing PostgreSQL Costs in the Cloud

If you’re using PostgreSQL in the cloud, there’s a good chance you’re spending more than you need to spend to get the results you need for your business.

Percona Server for MongoDB 6 Adds Support for Red Hat Enterprise Linux 9

We’re pleased to announce that Percona Server for MongoDB 6.0.4 adds support for Red Hat Enterprise Linux (RHEL) 9 and compatible Linux distributions.

Run For Your Favorite Database at Percona Live 2023

We’re partnering with the Denver Marathon to attract relay teams of five runners each who will complete legs of 3.9 to 6.5 miles (6 to 10 kilometers), and recruiting runners for Team MySQL, Team MariaDB, Team PostgreSQL, and Team MongoDB.

Streaming MongoDB Backups Directly to S3

Here are some simple examples of how to skip local storage and stream MongoDB backups directly to AWS S3.

Feedback Wanted: Making EXPLAIN Require Less Privileges for INSERT/UPDATE/DELETE Statements

We are considering changing EXPLAIN in Percona Server for MySQL to require less privileges for providing execution plans for INSERT/UPDATE/DELETE statements.

PostgreSQL Migration From Digital Ocean DBaaS to Digital Ocean Droplet

How we migrated an entire PostgreSQL cluster from DigitalOcean's Database as a Service (DBaaS) to a DigitalOcean Droplet.

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

Is ChatGPT ready to replace MySQL DBAs? No, and let me show you why.

Deploying MySQL Group Replication With Terraform

We have added the capability to deploy Group Replication configuration with Percona Server for MySQL, and we also can automatically add Group Replication nodes to PMM monitoring.

How Bloom Filters Work in MyRocks

Bloom filters are important for LSM-based databases like MyRocks. Here's how they work and how to use them.

End of Life Notification for PostgreSQL 10

The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page.

Deploying Percona Monitoring and Management With Terraform

We are happy to announce we have added capabilities to deploy Percona Monitoring and Management with Terraform. Here's how.

PostgreSQL for MySQL DBAs Episode 12: Transactions

Transactions are transactions in both MySQL and PostgreSQL, but you get more flexibility for rollbacks with PostgreSQL.

Differing MySQL Client Versions Causing Broken Replication and Collations in Aurora

Recently, a replica running Percona Server for MySQL 5.7, external to AWS Aurora instance version 2.10.2, broke. It had the character set ‘#255’, not available on the list of available collations for the UTF8MB4 character set.

Tech Preview of Percona Operator for MySQL 0.4.0, Percona Distribution for MongoDB 6.0.4: Release Roundup February 13, 2023

Percona software releases and updates January 30 - February 13, 2022.

Percona XtraBackup and MySQL 5.7 Queries in Waiting for Table Flush State

Looking at the cause and possible solution for queries with ​Waiting for table flush state in processlist when taking backups using Percona XtraBackup.

Storage Autoscaling With Percona Operator for MongoDB

ViewBlock, a blockchain explorer, uses the Percona Operator for MongoDB to store critical data. We see how pvc-autoresizer can automate storage scaling for MongoDB clusters on Kubernetes.

Percona XtraBackup Now Supports IAM Instance Profile

Starting with Percona XtraBackup 8.0.31-24, xbcloud can read instance metadata and fetch credentials from an instance profile to authenticate against an S3 bucket.

Database Housekeeping in the New Year

Is your open source database ready for 2023? Now's the time to make sure!

PostgreSQL Database Security: External Server-Based Authentication

External authentication methods such as GSSAPI, LDAP, and RADIUS can enhance PostgreSQL database security, providing a centralized way of managing user access and eliminating the need to store passwords in the database.

An Argument for Logical Failover Slots

In an ideal PostgreSQL world, the perfect implementation of a logical slot failover would have one already in place on the STANDBY, guaranteeing data consistency without fear of loss.

Unlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability

How to use The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability in PostgreSQL.

Why PostgreSQL Needs Transparent Database Encryption (TDE)

While some PostgreSQL Developers believe encryption is a storage-level problem better solved on the filesystem or block device level, Peter Zaitsev does not share that opinion, and many PostgreSQL community members don't either.

Percona Backup for MongoDB 2.0.3, Updates to Percona Distribution for MySQL: Release Roundup January 30, 2023

Percona software releases and updates January 9 - 30, 2022.

Why You Need To Keep Track of Bugs

A recent bug that appeared in MySQL 8.0.32 is a prime example of how a minor bug could have a significant impact on your life and company.