# Percona Published articles for Percona. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## The ideal database for AI agents doesn't exist yet, says Percona CEO DevFeed: [The ideal database for AI agents doesn't exist yet, says Percona CEO]() Original publisher: [Read original article]() Author: Richard Speed Published: 2026-09-18T12:34:00Z Content type: news Language: en Sources: [www.theregister.com - Articles]() Topics: [Artificial Intelligence](), [Database]() Tags: [agentic-ai](), [agents](), [ai](), [ai-and-ml](), [database](), [databases](), [open-source](), [percona]() ### AI overview The article reports that existing database vendors were caught off guard by the iterative workloads of AI agents, while the requirements for a clean-slate database solution remain unclear. ### Source excerpt Iterative workloads caught vendors off guard, but requirements for a clean-slate solution remain unclear ## Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026 DevFeed: [Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026]() Original publisher: [Read original article]() Author: Gülçin Yıldırım Jelínek Published: 2026-09-17T14:02:33Z Content type: article Language: en Sources: [ClickHouse Blog]() Topics: [PostgreSQL](), [clickhouse](), [Monitoring](), [Percona]() Tags: [2026](), [clickhouse](), [conference](), [monitoring](), [notes](), [percona](), [percona-live](), [postgres](), [postgresql]() ### AI overview Notes from PGDay Lowlands and Percona Live 2026, including a lightning talk about using pg_clickhouse and pg_stat_ch to combine PostgreSQL with ClickHouse for analytics, plus a session on PostgreSQL 19 monitoring. ### Source excerpt Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam. ## pgBackRest Compression: How Much CPU Is a Smaller Backup Worth? DevFeed: [pgBackRest Compression: How Much CPU Is a Smaller Backup Worth?]() Original publisher: [Read original article]() Author: Agustín Gallego Published: 2026-09-16T21:43:06Z Content type: comparison Language: en Sources: [Blog - Percona]() Topics: [Compression](), [Algorithms](), [PostgreSQL](), [postgresql 18](), [backups](), [Percona]() Tags: [algorithms](), [backup](), [compare](), [compression](), [cpu](), [percona](), [postgresql](), [postgresql-18](), [uncategorized]() ### AI overview This comparison measures pgBackRest compression algorithms and levels on Percona Distribution for PostgreSQL 18.4. It finds that low-level Zstandard offers a favorable balance between CPU use and backup size, with zst(3) near the efficiency curve's shoulder. ### Source excerpt In this blog post, we'll compare pgBackRest's compression algorithms and levels to find where spending more CPU stops buying a meaningfully smaller backup. The short version of the answer, which we'll build up to with real numbers, is that Zstandard at a low level is the sweet spot, and its default (zst(3)) already sits right ... Continued The post pgBackRest Compression: How Much CPU Is a Smaller Backup Worth? appeared first on Percona. ## Performance improvements in Percona Server 8.4.11-11 DevFeed: [Performance improvements in Percona Server 8.4.11-11]() Original publisher: [Read original article]() Author: Bogdan Degtyariov Published: 2026-09-15T11:52:54Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [Percona Server for MySQL](), [Percona](), [MySQL](), [Cache](), [Scalability](), [Database]() Tags: [benchmark](), [benchmarks](), [cache](), [io](), [mysql](), [percona](), [percona-server-for-mysql](), [performance](), [scalability]() ### AI overview This article describes performance and scalability improvements in Percona Server for MySQL 8.4.11-11, focusing on changes to the InnoDB buffer pool and page flushing. It explains how narrowing mutex coverage and using finer-grained latching allows physical reads to proceed more in parallel, particularly for read-heavy, I/O-bound workloads. ### Source excerpt Focusing on Percona Server 8.4.11-11 My previous post (Performance Progression of Percona Server for MySQL 8.4) did a brief review of the performance changes in Percona Server for MySQL 8.4 released in 2026. I recommend reading it first to better understand the material in this post. Version 8.4.11-11 includes patches that deliver significant improvements in ... Continued The post Performance improvements in Percona Server 8.4.11-11 appeared first on Percona. ## Percona and HexaCluster: Faster, Safer Oracle Migration DevFeed: [Percona and HexaCluster: Faster, Safer Oracle Migration]() Original publisher: [Read original article]() Author: Percona Team Published: 2026-09-14T22:19:16Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [Oracle Database](), [migration](), [Open Source](), [PostgreSQL](), [Database Migration](), [Replication](), [Tooling]() Tags: [database](), [database-migration](), [database-trends](), [engineering](), [insight-for-dbas](), [insight-for-developers](), [migration](), [open-source](), [oracle](), [partners](), [percona](), [postgresql](), [replication](), [schema](), [sql](), [tooling](), [validation]() ### AI overview Percona and HexaCluster describe a partnership for moving organizations from Oracle, SQL Server, DB2, and Sybase ASE to supported open source databases, primarily PostgreSQL. HexaCluster provides assessment and migration engineering through DMAT and HexaRocket, while Percona provides distributions, operators, and long-term support. HexaRocket combines schema migration, data migration, validation, change data capture, live replication, and reverse replication in one platform. ### Source excerpt Percona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering ... Continued The post Percona and HexaCluster: Faster, Safer Oracle Migration appeared first on Percona. ## Enabling TLS in PXC without Downtime DevFeed: [Enabling TLS in PXC without Downtime]() Original publisher: [Read original article]() Author: Juan Arruti Published: 2026-09-09T23:32:15Z Content type: tutorial Language: en Sources: [Blog - Percona]() Topics: [TLS (Transport Layer Security)](), [Replication](), [Security](), [Network](), [openssl]() Tags: [galera](), [high-availability](), [insight-for-dbas](), [mysql](), [open-source](), [percona](), [pxc](), [replication](), [security](), [ssl](), [tls](), [tls-handshake](), [uncategorized](), [xtradb-cluster-pxc]() ### AI overview This tutorial explains how to enable TLS for replication traffic in Percona XtraDB Cluster without a full cluster restart. Using Galera's socket.dynamic option, operators can perform two rolling restarts: first allowing encrypted and plaintext connections, then enforcing TLS-only communication. ### Source excerpt Starting with Percona XtraDB Cluster (PXC) 8.0, replication traffic encryption is enabled by default. That said, it's common to find clusters running without TLS that suddenly need it: a new compliance requirement, an audit finding, a network segment that is no longer considered trusted. PXC has a variable for exactly that case, pxc-encrypt-cluster-traffic, which handles ... Continued The post Enabling TLS in PXC without Downtime appeared first on Percona. ## Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging DevFeed: [Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging]() Original publisher: [Read original article]() Author: Slava Sarzhan Published: 2026-09-09T16:08:31Z Content type: release Language: en Sources: [Blog - Percona]() Topics: [PostgreSQL](), [Encryption](), [Logging](), [Kubernetes](), [Open Source]() Tags: [cloud](), [encryption](), [hashicorp-vault](), [kubernetes](), [logging](), [open-source](), [operator](), [percona](), [percona-operator-for-postgresql](), [postgresql](), [release](), [replication](), [security](), [slavasarzhan-pg]() ### AI overview Percona Operator for PostgreSQL 3.1.0 adds transparent data encryption with pg_tde, logical replicas for read-only workloads, and persistent logging across Pod restarts. The release also adds official RKE2 support and full ARM64 images. ### Source excerpt Percona Operator for PostgreSQL 3.1.0 takes on three things that decide whether a PostgreSQL platform passes review: is the data encrypted at rest, can it serve reads without straining the primary, and are the logs there when you need them. This release answers all three inside the custom resource, so none of them is a ... Continued The post Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging appeared first on Percona. ## Stefan Fercot Joins Percona to Contribute to pgBackRest DevFeed: [Stefan Fercot Joins Percona to Contribute to pgBackRest]() Original publisher: [Read original article]() Author: Percona Team Published: 2026-09-09T15:55:38Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [Percona](), [backups]() Tags: [backups](), [percona](), [percona-live](), [postgres](), [postgresql]() ### AI overview Stefan Fercot joined Percona's Postgres engineering team to increase its contributions to pgBackRest, a backup and restore tool. The article describes his prior advocacy for the project and Percona's sponsorship of its development. ### Source excerpt If you have spent any time in the Postgres community, you already know the name pgstef. Stefan Fercot has spent years as one of the most visible advocates for pgBackRest, a familiar face at European Postgres conferences, and countless hallway conversations about backups, high availability, and everything in between. Now he is doing that work ... Continued The post Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam appeared first on Percona. ## OpenID Connect Authentication for MySQL, Now Fully Open Source DevFeed: [OpenID Connect Authentication for MySQL, Now Fully Open Source]() Original publisher: [Read original article]() Author: Michał Jankowski Published: 2026-09-02T08:56:26Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [MySQL](), [OpenID connect (OIDC)](), [Authentication](), [JSON Web Tokens](), [OAuth](), [Open Source]() Tags: [authentication](), [jwks](), [jwt](), [mysql](), [oauth](), [oauth-2-0](), [oidc](), [open-source](), [openid-connect](), [percona](), [percona-server-for-mysql](), [percona-software](), [security]() ### AI overview Percona Server for MySQL includes an open-source OpenID Connect authentication plugin for specified 8.4 and 9.7 releases. The article explains how it authenticates users through standards-compliant identity providers and describes capabilities beyond the MySQL Enterprise plugin, including JWKS signing-key synchronization, group-to-role mapping, and proxy-user support. ### Source excerpt Percona Server for MySQL now ships with a fully open source OpenID Connect (OIDC) authentication plugin, available starting with Percona Server for MySQL 8.4.11-11 and 9.7.2-2 (not yet released as of this writing). It allows a MySQL account to authenticate against any standards-compliant Identity Provider (IdP) instead of relying on a locally stored password, closing ... Continued The post OpenID Connect Authentication for MySQL, Now Fully Open Source appeared first on Percona. ## Benchmarking vector indexes DevFeed: [Benchmarking vector indexes]() Original publisher: [Read original article]() Author: Evgeniy Patlan Published: 2026-08-27T13:35:32Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [benchmarking](), [Ground truth / benchmark quality](), [Databases](), [ann](), [datasets](), [Sorting]() Tags: [ai-vector](), [ann](), [benchmark](), [benchmarking](), [benchmarks](), [blog](), [blog-post](), [data](), [database-performance](), [database-trends](), [databases](), [datasets](), [embeddings](), [index](), [measurements](), [model](), [open-source](), [percona](), [points](), [report](), [run](), [search](), [sorting](), [vector-search](), [vectorsearch]() ### AI overview This article explains how Percona's vector-bench measures vector indexes by building database engines from pinned versions, running them in identical containers with the same data and hardware, and comparing consistent measurements. It describes embeddings, exact search, approximate nearest neighbour search, and ground truth as the brute-force reference needed to evaluate index accuracy. ### Source excerpt Nearly every database has vector search now, and every one of them has a blog post with a big number in it. Almost none of those numbers can be checked, because the thing that makes them meaningful is usually missing. We built a vector-bench to stop guessing. You name the engines you want, build them ... Continued The post Benchmarking vector indexes appeared first on Percona. ## Performance Progression of Percona Server for MySQL 8.4 DevFeed: [Performance Progression of Percona Server for MySQL 8.4]() Original publisher: [Read original article]() Author: Bogdan Degtyariov Published: 2026-08-27T13:07:20Z Content type: article Language: en Sources: [Blog - Percona]() Topics: [MySQL](), [benchmarking](), [Benchmark](), [Scalability](), [configuration](), [cpu](), [Hardware]() Tags: [2026](), [benchmark](), [benchmarking](), [benchmarks](), [concurrency](), [configuration](), [cpu](), [data](), [database](), [hardware](), [intel](), [latency](), [load](), [measurement](), [mysql](), [percona](), [percona-server-for-mysql](), [performance](), [processors](), [run]() ### AI overview This article investigates read/write performance changes across Percona Server for MySQL 8.4 versions released in 2026. It describes benchmark scope, database and buffer-size combinations, configuration, and CPU-frequency controls, while excluding features, security patches, latency percentiles, and resource-utilization measurements. ### Source excerpt 1. Purpose and scope This performance investigation aims to look into the read/write performance of Percona Server for MySQL 8.4 and how it changed between versions released in 2026: 8.4.8-8 released on 12 March 2026 8.4.10-10 released on 30 June 2026 8.4.11-11 released on 20 August 2026 We want to see if there are improvements ... Continued The post Performance Progression of Percona Server for MySQL 8.4 appeared first on Percona. ## Why the need for humans won't disappear in the age of autonomous databases DevFeed: [Why the need for humans won't disappear in the age of autonomous databases]() Original publisher: [Read original article]() Author: Chris J. Preimesberger Published: 2026-06-04T17:18:07Z Content type: article Language: en Sources: [Kubernetes Overview, News and Trends | The New Stack]() Topics: [Databases](), [Kubernetes](), [Artificial Intelligence](), [Automation]() Tags: [ai](), [ai-agents](), [automation](), [database](), [databases](), [event-coverage](), [kubernetes](), [open-source](), [percona](), [sponsor-percona](), [sponsored-event-coverage]() ### AI overview The article argues that autonomous databases will change rather than eliminate the database administrator role. Routine patching, scaling, and maintenance may increasingly be handled by machine learning and AI agents, while human expertise shifts toward data integrity, access patterns, system architecture, and governance. It also links database autonomy to cloud-native infrastructure and Kubernetes. ### Source excerpt The promise of fully autonomous systems -- databases that manage, heal, and optimize themselves amid rapidly increasing data stores -- The post Why the need for humans won't disappear in the age of autonomous databases appeared first on The New Stack. ## Neon at Percona Live 2022 DevFeed: [Neon at Percona Live 2022]() Original publisher: [Read original article]() Author: Bojan Serafimov Published: 2022-08-19T16:53:33Z Content type: article Language: en Sources: [Blog -- Neon Docs]() Topics: [Databases](), [Developer experience](), [Cloud](), [Open Source]() Tags: [cloud](), [company](), [conference](), [database](), [developer](), [developer-experience](), [open-source](), [percona](), [percona-live](), [scale](), [self-service]() ### AI overview Neon's participation in Percona Live 2022 focused on developer experience for database operations. The article describes Neon's managed self-service cloud Postgres, its architecture, and features including scale-to-zero, branching, time travel, and point-in-time recovery. ### Source excerpt Percona Live, the biggest open source database conference took place in Texas on May 16, 2022, and we were happy to be a part of it. Neon is a database focused on Developer Experience (DevX) and DevX was one of the conversation topics at the conference. Percona's poll results sho... ## Daily MySQL backups with xtrabackup DevFeed: [Daily MySQL backups with xtrabackup]() Original publisher: [Read original article]() Author: Tom Published: 2016-04-23T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [backups](), [MySQL](), [Percona](), [Encryption](), [MariaDB](), [passwords]() Tags: [backup](), [backups](), [config](), [credentials](), [database](), [encryption](), [files](), [local](), [mariadb](), [mysql](), [nas](), [password](), [percona](), [script](), [security]() ### AI overview A tutorial on using xtrabackup for daily MySQL backups, including backup creation, encrypted credential handling, archive storage, and restoration. It compares xtrabackup with standard MySQL dumps and discusses MariaDB, Percona, and NAS storage. ### Source excerpt I've been using standard MySQL dumps as backup technique on my VPS for few years. It works fine and backups were usable few times when I needed them. But in other places I'm using xtrabackup1. It's faster when crating backups and a lot faster when restoring them - they're binary so there is no need to reevaluate all SQL create tables/inserts/etc. Backups also include my.cnf config file so restoring on other machine should be easy. ## MySQL - reset root password DevFeed: [MySQL - reset root password]() Original publisher: [Read original article]() Author: Tom Published: 2015-12-28T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [MySQL](), [passwords](), [Databases](), [configuration]() Tags: [configuration](), [credentials](), [linux](), [localhost](), [mariadb](), [mysql](), [password](), [percona](), [root](), [set]() ### AI overview A tutorial explaining how to reset a MySQL user password, including the root password, by stopping MySQL, using an init file with a SET PASSWORD command, starting the server with that file, and then deleting it. ### Source excerpt It will happen from time to time, that you're on alien machine and have to brutally update things in db without knowing credentials. Example is for root (quite secure candidate to change because it shouldn't be used in app 😃 ) but will work for any user. shutdown db service mysql stop create text file with command like this (update user accordingly) ex. in /tmp/pwchange.txt SET PASSWORD FOR "root"@"localhost" = PASSWORD("HereYourNewPassword"); start mysqld with --init-file param mysqld_safe --init-file=/tmp/pwchange.txt sometimes you may require to point configuration file ex. --defaults-file=/etc/mysql/my.cnf ## Mention's CTO journey to 400,000 users DevFeed: [Mention's CTO journey to 400,000 users]() Original publisher: [Read original article]() Author: Hexa Published: 2015-10-22T12:17:15Z Content type: article Language: en Sources: [eFounders]() Topics: [App](), [Monitoring](), [Crawler](), [Concurrency](), [race-condition](), [Go Language](), [MySQL](), [API](), [Kafka](), [Redis](), [Percona](), [backups]() Tags: [api](), [backups](), [developer](), [development](), [dns](), [go](), [kafka](), [monitoring](), [mysql](), [percona](), [programming](), [race-condition](), [redis](), [startup](), [tech](), [users]() ### AI overview Mention's co-founder and CTO describes the technical challenges involved in growing the real-time monitoring application to 400,000 users. The article covers high-concurrency web crawling, a libc DNS resolver race condition, and the use of Go as a workaround. It also explains Mention's storage architecture using Percona MySQL, Redis for caching, Kafka for messaging, and incremental backups. ### Source excerpt Mention is a real-time monitoring application used to track and analyze trends and e-reputation in a very complete and intuitive way. Co-founded in 2010, it now counts 400,000 users across the world. This impressive growth rate not only implies great marketing talent but also impressive technical achievements. Arnaud le Blanc, Mention's co-founder and CTO, tells us about how he got Mention there. You gotta love technical challenges "When we developed Mention, our main competitor was Google Alerts, which feels a little like being David versus Goliath at first. But then it became one of the reasons I like my job: it is very challenging. Getting to this point of a product development involves a true entrepreneurial mindset. Before being Mention's CTO, I was a developer and then the lead developer working on the media monitoring feature at Pressking. eFounders offered me to become Mention's co-founder. I might not have thought of myself as an entrepreneur before, although today, I really feel like Mention is my product: I've built it together with my co-founders. Building an application like Mention is full of technical challenges. We handle a large amount of data, crawl thousands of web page per second, built an open API for our own apps, and use lots of third-party APIs." FOCUS: a challenge overcome when developing Mention's web crawler Since Mention crawls a large amount of web pages in parallel, there is a point when the crawler reaches a high concurrency level and stresses the OS: that is when we got to the limit of our system. In our case, these limits entailed the appearance of a race condition in the libc's DNS resolver. libc was sending over DNS queries on random unrelated file descriptors, which was leading to weird behaviors. The bug was reported and fixed a few months later, but in the meantime, we had to use the plain-Go DNS resolve, which happened to work really well. "At Mention, several millions of Mentions are inserted in user feeds per day (see infogra ## MySQL - Proste metody optymalizacji DevFeed: [MySQL - Proste metody optymalizacji]() Original publisher: [Read original article]() Author: Tom Published: 2011-12-29T00:00:00Z Content type: tutorial Language: pl Sources: [Tomasz Gągor]() Topics: [MySQL](), [Cache]() Tags: [backup](), [cache](), [index](), [information-schema](), [mariadb](), [mysql](), [percona](), [schema](), [var]() ### AI overview A Polish tutorial presents MySQL configuration adjustments for improving database performance, covering MyISAM key caching, InnoDB buffer pool and log file sizing, and the storage and compaction behavior of InnoDB data files. ### Source excerpt Wcześniej czy później zawsze pojawia się potrzeba zoptymalizowania naszej bazy MySQL. Przedstawię kilka zmian w konfiguracji, które powinny zwiększyć wydajność w większości przypadków. MyISAM - key_buffer_size Najprostszą optymalizacją baz/tabel z mechanizmem MyISAM jest odpowiednie dobranie bufora na cache dla kluczy i indeksów (dane nigdy nie są cachowane). Poniższe zapytanie pozwala oszacować zalecany rozmiar cache'u: SELECT CONCAT(ROUND(KBS/POWER(1024, IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999), SUBSTR(' KMG',IF(PowerOf1024<0,0, IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_key_buffer_size FROM (SELECT LEAST(POWER(2,32),KBS1) KBS FROM (SELECT SUM(index_length) KBS1 FROM information_schema.tables WHERE engine='MyISAM' AND table_schema NOT IN ('information_schema','mysql')) AA ) A, (SELECT 2 PowerOf1024) B; Wynik określa zalecany rozmiar bufora (parametr key_buffer_size w pliku /etc/mysql/my.cnf) dla bieżącego stanu bazy - warto ciut dodać na zapas. Na systemach 32 bitowych parametr key_buffer_size może przyjmować maksymalnie 4GB, na 64 bitowych maksymalnie 8GB. ## MySQL - dostęp zdalny na szybko DevFeed: [MySQL - dostęp zdalny na szybko]() Original publisher: [Read original article]() Author: Tom Published: 2011-08-27T00:00:00Z Content type: tutorial Language: pl Sources: [Tomasz Gągor]() Topics: [MySQL](), [SQL](), [Databases](), [Server]() Tags: [apt](), [debian](), [flush](), [ip](), [localhost](), [mariadb](), [mysql](), [percona](), [root](), [server](), [sql]() ### AI overview A Polish tutorial explains how to install MySQL Server on Debian and configure remote access. It covers granting privileges, limiting access by IP address, changing the MySQL bind address, and restarting the server. ### Source excerpt Instalacja serwera MySQL na Debianie jest niezwykle prosta i sprowadza się do jednego polecenia: sudo apt-get install mysql-server Polecenie to zainstaluje i uruchomi usługę serwerową MySQL. W czasie instalacji będziemy proszeni o podanie hasła dla root'a (które oczywiście dobrze jest zapamiętać bądź zapisać). Tak zainstalowana baza nasłuchuje na lokalnym porcie (localhost:3306) umożliwiająć dostęp wyłącznie root'owi. Jest to bardzo bezpieczna konfiguracja... Ale jeśli nie mamy zamiaru na tej samej maszynie instalować oprogramowania zarządzającego to nie zawsze jest to wygodne, tym bardziej gdy przykładowo mamy działającego phpmyadmin'a na jakimś serwerze www. W takim przypadku pierwszą rzeczą, którą robię jest udostępnienie dostępu zdalnego dla root'a. Warto zaznaczyć że uprawnienia root'a można nadać dowolnemu użytkownikowi (np. romanowi) co jest dużo bezpieczniejszą konfiguracją niż działanie bezpośrednio na koncie root'a (którego nazwa jest powszechnie znana).