Percona's MySQL & InnoDB performance and scalability blog
91k followers 5 artículos/semana
Unleashing the Power of PostgreSQL Event-Based Triggers

PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on...

Wed Jun 7, 2023 16:43
Conquering Mt. Elbert After Percona Live 2023 in Denver

If you’re going to take on the second-highest peak in the lower 48 states, you might as well do it in great company. That’s precisely what we — Matthew Boehm, Michael Coburn, Péter Farkas, Jean-François Gagné, Marcin Gwóźdź, Kenny Gryp, Nando Laudares, and Alexander Rubin — decided to do. Fresh from attending Percona Live in Denver, we set off on a...

Wed Jun 7, 2023 15:07
PMM Authentication Bypass Vulnerability Fixed in 2.37.1

On May 30, Percona was notified of a possible vulnerability in Percona Monitoring and Management (PMM). After researching the report, we agreed with the reporter and began working on a fix to address the issue. Today we’re releasing PMM 2.37.1 with a fix that addresses the PMM authentication bypass vulnerability. This release contains no other features...

Mon Jun 5, 2023 21:02
Configuring PgBouncer for Multi-Port Access

From time to time, situations occur where unusual circumstances dictate out-of-the-box thinking.For example, suppose you have a system where you’ve installed multiple data clusters onto a single host. What you end up with is a host breaking up and sharing valuable system resources, i.e., CPU, RAM, disk, etc., between multiple instances of PostgreSQL...

Mon Jun 5, 2023 16:27
Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions.It was simple, easy to deploy, and easy to use, and WordPress had the added benefit of being...

Fri Jun 2, 2023 15:19
Migrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft

Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem.In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. A comment worth clarifying is that, although Percona Server...

Thu Jun 1, 2023 15:45

Crea tu propio feed de noticias

¿Listo para probarlo?
Comienza una prueba de 14 días, no es necesaria tarjeta de crédito.

Crear cuenta