# Percona

The Way is Open

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Java4Shell Vulnerability: Percona Security Update

DevFeed: [Java4Shell Vulnerability: Percona Security Update](<https://devfeed.tech/articles/java4shell-vulnerability-percona-security-update-144768.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/java4shell-vulnerability-percona-security-update/>)

Author: John Lionis

Published: 2026-11-19T10:23:26Z

Content type: news

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [openjdk](<https://devfeed.tech/topics/openjdk.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>), [software security audit](<https://devfeed.tech/topics/software-security-audit.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [base64](<https://devfeed.tech/tags/base64.md>), [code-execution](<https://devfeed.tech/tags/code-execution.md>), [corruption](<https://devfeed.tech/tags/corruption.md>), [critical](<https://devfeed.tech/tags/critical.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-114938](<https://devfeed.tech/tags/cve-2026-114938.md>), [decoder](<https://devfeed.tech/tags/decoder.md>), [disclosure](<https://devfeed.tech/tags/disclosure.md>), [distributions](<https://devfeed.tech/tags/distributions.md>), [java](<https://devfeed.tech/tags/java.md>), [java4shell](<https://devfeed.tech/tags/java4shell.md>), [memory](<https://devfeed.tech/tags/memory.md>), [memory-corruption](<https://devfeed.tech/tags/memory-corruption.md>), [openjdk](<https://devfeed.tech/tags/openjdk.md>), [percona](<https://devfeed.tech/tags/percona.md>), [rce](<https://devfeed.tech/tags/rce.md>), [security](<https://devfeed.tech/tags/security.md>), [security-advisories](<https://devfeed.tech/tags/security-advisories.md>), [security-update](<https://devfeed.tech/tags/security-update.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>)

### AI overview

Percona says it patched all identified affected production systems within its operational scope by November 18, 2026, at 17:13 CET, and assessed systems that did not need patching as unaffected. The company reports that its WAF adds protection against applicable exploitation attempts, and its investigations found no indicators of compromise or evidence of customer data impact. Percona says it continues monitoring Java4Shell and conducting follow-up assessments. The excerpt describes Percona's response; it does not provide broader remediation guidance or technical details about the vulnerability beyond reported memory corruption in Java's Base64 decoder and potential unauthenticated remote code execution under certain conditions.

### Source excerpt

November 19, 2026 | Percona Security Team Percona is aware of the recently disclosed Java4Shell vulnerability (CVE-2026-114938), a critical security issue reportedly affecting OpenJDK and related Java distributions. The vulnerability involves memory corruption in Java's Base64 decoder and may allow unauthenticated remote code execution (RCE) under certain conditions. Following the public disclosure, Percona's Security ... Continued The post Java4Shell Vulnerability: Percona Security Update appeared first on Percona.

## Inside Kvrocks

DevFeed: [Inside Kvrocks](<https://devfeed.tech/articles/inside-kvrocks-136404.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/inside-kvrocks/>)

Author: Martin Visser

Published: 2026-11-16T21:49:34Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [rocksdb](<https://devfeed.tech/topics/rocksdb.md>), [valkey](<https://devfeed.tech/topics/valkey.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Redis](<https://devfeed.tech/topics/redis.md>), [in-memory database](<https://devfeed.tech/topics/in-memory-database.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [all](<https://devfeed.tech/tags/all.md>), [based](<https://devfeed.tech/tags/based.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [course](<https://devfeed.tech/tags/course.md>), [data](<https://devfeed.tech/tags/data.md>), [fast](<https://devfeed.tech/tags/fast.md>), [first](<https://devfeed.tech/tags/first.md>), [i](<https://devfeed.tech/tags/i.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [it](<https://devfeed.tech/tags/it.md>), [it-s](<https://devfeed.tech/tags/it-s.md>), [kvrocks](<https://devfeed.tech/tags/kvrocks.md>), [live](<https://devfeed.tech/tags/live.md>), [my](<https://devfeed.tech/tags/my.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-live](<https://devfeed.tech/tags/percona-live.md>), [post](<https://devfeed.tech/tags/post.md>), [ram](<https://devfeed.tech/tags/ram.md>), [redis](<https://devfeed.tech/tags/redis.md>), [rocksdb](<https://devfeed.tech/tags/rocksdb.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [valkey](<https://devfeed.tech/tags/valkey.md>)

### AI overview

Kvrocks stores Redis- and Valkey-compatible data on disk in RocksDB, avoiding an in-memory dictionary of every key, while retaining RESP compatibility with existing clients. Its performance depends on cache hit rates, storage speed and write-driven LSM compaction: point reads check memtables, bloom filters and cached blocks before reaching disk, while range scans read adjacent collection rows and bypass Kvrocks' block cache. Collections use metadata plus versioned per-element rows; deleting a collection removes its metadata immediately, while compaction later reclaims orphaned rows. WAL sync settings trade durability against write cost. Kvrocks uses Valkey Cluster's 16,384 slots and cluster-aware clients, but topology is pushed by a controller through CLUSTERX SETNODES rather than gossip; standalone-to-cluster conversion requires data migration, and slot rebalancing briefly pauses for final catch-up and ownership change. The excerpt describes mechanisms and tradeoffs, but provides no benchmark results.

### Source excerpt

How Valkey/Redis data lives on RocksDB Based on my Percona Live 2026 talk "On-disk and Redis Compatible: Evaluating Kvrocks." I will cover benchmarking Kvrocks in a separate post. We all run Valkey or Redis for well-known reasons: all the data lives in RAM, and it's fast. Storing data in RAM is of course expensive. ... Continued The post Inside Kvrocks appeared first on Percona.

## Just Because You Can, Doesn't Mean You Should: Re-evaluating Galera Node Weights

DevFeed: [Just Because You Can, Doesn't Mean You Should: Re-evaluating Galera Node Weights](<https://devfeed.tech/articles/just-because-you-can-doesn-t-mean-you-should-re-evaluating-galera-node-weights-133659.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/just-because-you-can-doesnt-mean-you-should-re-evaluating-galera-node-weights/>)

Author: Marco Tusa

Published: 2026-11-13T14:01:47Z

Content type: opinion

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>)

Tags: [balance](<https://devfeed.tech/tags/balance.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bootstrap](<https://devfeed.tech/tags/bootstrap.md>), [cluster-management](<https://devfeed.tech/tags/cluster-management.md>), [complex](<https://devfeed.tech/tags/complex.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [component](<https://devfeed.tech/tags/component.md>), [database-administration-dba](<https://devfeed.tech/tags/database-administration-dba.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [fault-tolerance](<https://devfeed.tech/tags/fault-tolerance.md>), [galera](<https://devfeed.tech/tags/galera.md>), [galera-arbitrator-garbd](<https://devfeed.tech/tags/galera-arbitrator-garbd.md>), [galera-cluster](<https://devfeed.tech/tags/galera-cluster.md>), [high-availability-ha](<https://devfeed.tech/tags/high-availability-ha.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [node-weighting-pc-weight](<https://devfeed.tech/tags/node-weighting-pc-weight.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [percona-xtradb-cluster-pxc](<https://devfeed.tech/tags/percona-xtradb-cluster-pxc.md>), [primary-component](<https://devfeed.tech/tags/primary-component.md>), [quorum](<https://devfeed.tech/tags/quorum.md>), [risk](<https://devfeed.tech/tags/risk.md>), [split-brain](<https://devfeed.tech/tags/split-brain.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

Galera quorum depends on weighted membership, not simply on node count. The text gives the check as Σ p-w < 2-(Σ m-w + Σ l-w): unreachable nodes remain counted in the previous PRIMARY view, graceful departures are credited to the new component, and nodes that joined after that view do not count. An even split in counted weight can still make the cluster lose PRIMARY; odd node counts avoid that tie only in simple cases. Changing weights can shift which failures a cluster survives rather than increase general resilience: a weight-2 node behaves like two nodes that always fail together, and misassigned weights can let one failure bring the cluster down. The author favors keeping clusters simple and using weights only as deliberate tiebreakers; for multi-DC setups, the text suggests a third site or arbitrator, while noting that a cluster that shrinks can still reach a tie. It does not provide the detailed weight examples mentioned in the excerpt.

### Source excerpt

We all know that when using a cluster based on Galera (Codership) such as Percona XtraDB Cluster (PXC), it is recommended to deploy an odd number of nodes. The generic answer to this recommendation is that otherwise the risk of having an inconsistent cluster (like split-brain) is higher. (see Get started with Percona XtraDB Cluster ... Continued The post Just Because You Can, Doesn't Mean You Should: Re-evaluating Galera Node Weights appeared first on Percona.

## Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management

DevFeed: [Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management](<https://devfeed.tech/articles/introducing-percona-database-service-pds-an-experiment-in-simplifying-database-management-131068.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-database-service-pds/>)

Author: Andrey Glazkov

Published: 2026-11-12T16:43:13Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [self-service](<https://devfeed.tech/topics/self-service.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [AI Integration Strategies](<https://devfeed.tech/topics/ai-integration-strategies.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [access-controls](<https://devfeed.tech/tags/access-controls.md>), [account](<https://devfeed.tech/tags/account.md>), [actions](<https://devfeed.tech/tags/actions.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-assistant](<https://devfeed.tech/tags/ai-assistant.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-eks](<https://devfeed.tech/tags/amazon-eks.md>), [amazon-elastic-kubernetes-service](<https://devfeed.tech/tags/amazon-elastic-kubernetes-service.md>), [application](<https://devfeed.tech/tags/application.md>), [database](<https://devfeed.tech/tags/database.md>), [database-management](<https://devfeed.tech/tags/database-management.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [developer](<https://devfeed.tech/tags/developer.md>), [environment](<https://devfeed.tech/tags/environment.md>), [experiment](<https://devfeed.tech/tags/experiment.md>), [management](<https://devfeed.tech/tags/management.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-announcements](<https://devfeed.tech/tags/percona-announcements.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prototype](<https://devfeed.tech/tags/prototype.md>), [service](<https://devfeed.tech/tags/service.md>)

### AI overview

Percona Database Service (PDS) is an experimental centralized platform for provisioning and managing MySQL and PostgreSQL on Kubernetes while databases remain in the customer's AWS account. Built on OpenEverest, its current setup connects an EKS environment to a control plane; a generated local command can create a four-node cluster and S3 bucket or reuse an existing PDS installation. Database creation uses Dev, Staging, and Prod profiles, with high availability enabled from Staging onward. Public access adds a provider-billed load balancer and requires an IP or CIDR allowlist. The interface supports status and basic metrics, scaling, scheduled or on-demand backups, and activity history; PMM integration adds deeper performance diagnostics. Teams, users, and invitations provide initial shared management, while finer governance controls remain under development. AI clients such as Cursor and Claude can be connected through separate browser authentication and configurable permissions, including distinct authorization for deletion or restoration. PDS is an early preview whose capabilities may change.

### Source excerpt

It's Thursday afternoon, and a developer has an idea. Nothing complicated. They are working on a new application feature and want to test an idea before committing to a larger implementation. A quick prototype is already running locally. So far, so good. Next, they want to deploy the application to a shared environment so their ... Continued The post Introducing Percona Database Service (PDS): An Experiment in Simplifying Database Management appeared first on Percona.

## Deploying OpenEverest on a 3-Node K3s Cluster

DevFeed: [Deploying OpenEverest on a 3-Node K3s Cluster](<https://devfeed.tech/articles/deploying-openeverest-on-a-3-node-k3s-cluster-131065.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/deploying-openeverest-on-a-3-node-k3s-cluster/>)

Author: Arunjith Aravindan

Published: 2026-11-12T03:52:56Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [k3s](<https://devfeed.tech/topics/k3s.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [3](<https://devfeed.tech/tags/3.md>), [api](<https://devfeed.tech/tags/api.md>), [backups](<https://devfeed.tech/tags/backups.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [console](<https://devfeed.tech/tags/console.md>), [databases](<https://devfeed.tech/tags/databases.md>), [failover](<https://devfeed.tech/tags/failover.md>), [k3s](<https://devfeed.tech/tags/k3s.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [kubernetes-operators](<https://devfeed.tech/tags/kubernetes-operators.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [node](<https://devfeed.tech/tags/node.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [platform](<https://devfeed.tech/tags/platform.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [scaling](<https://devfeed.tech/tags/scaling.md>), [servers](<https://devfeed.tech/tags/servers.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

The guide builds a three-node K3s lab on Ubuntu 26.04, installs OpenEverest with Helm, and creates a three-node Percona XtraDB Cluster (PXC) with HAProxy. It covers preparing nodes, joining workers, configuring the console through SSH and kubectl port-forwards, and connecting to MySQL from a laptop. K3s local-path storage is node-local: volumes are created after pod scheduling, cannot be expanded, and are deleted with their claims; if a node is lost, Galera can rebuild data from surviving replicas. The guide explains that PXC nodes accept writes, while routing writes through one HAProxy target helps avoid Galera certification conflicts. It notes that running database pods on the control-plane node is acceptable for a test lab but recommends worker-only placement in production. Part 2 is described as covering Galera health indicators and a live failover test.

### Source excerpt

Part 1 of 2: From bare Ubuntu servers to a running MySQL cluster OpenEverest is an open source platform for running databases such as MySQL, PostgreSQL and MongoDB on Kubernetes. You get a web console and an API, and Kubernetes operators handle provisioning, scaling, backups and failover behind the scenes. This post builds a small ... Continued The post Deploying OpenEverest on a 3-Node K3s Cluster appeared first on Percona.

## Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test

DevFeed: [Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test](<https://devfeed.tech/articles/inside-an-openeverest-mysql-cluster-galera-health-and-a-live-failover-test-131066.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/inside-an-openeverest-mysql-cluster-galera-health-and-a-live-failover-test/>)

Author: Arunjith Aravindan

Published: 2026-11-12T03:51:17Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [health check](<https://devfeed.tech/topics/health-check.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [Logging and metrics](<https://devfeed.tech/topics/logging-and-metrics.md>), [container-networking](<https://devfeed.tech/topics/container-networking.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [created](<https://devfeed.tech/tags/created.md>), [data](<https://devfeed.tech/tags/data.md>), [data-loss](<https://devfeed.tech/tags/data-loss.md>), [failover](<https://devfeed.tech/tags/failover.md>), [first](<https://devfeed.tech/tags/first.md>), [galera](<https://devfeed.tech/tags/galera.md>), [health](<https://devfeed.tech/tags/health.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [inside](<https://devfeed.tech/tags/inside.md>), [k3s](<https://devfeed.tech/tags/k3s.md>), [live](<https://devfeed.tech/tags/live.md>), [look](<https://devfeed.tech/tags/look.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [node](<https://devfeed.tech/tags/node.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [test](<https://devfeed.tech/tags/test.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

The excerpt reports a three-node Percona XtraDB Cluster managed by OpenEverest. Galera health is checked through wsrep status: healthy nodes were Synced and Primary, with cluster size three and matching last-committed values. In a live test, deleting the writer pod shifted new one-second inserts through HAProxy to another node with no failed writes; after rejoining, the original writer became preferred again. It caught up via IST from a donor's gcache in about 0.2 seconds. All three nodes ended with 1,007 rows and matching checksums. The test depended on short, newly opened connections: existing connections close and uncommitted transactions are lost, so applications need reconnect-and-retry logic. With local-path storage, the pod must return to the node holding its volume; loss of that volume would require SST. The excerpt also cautions against taking two of three nodes offline because the remaining node loses quorum.

### Source excerpt

Part 2 of 2: Reading wsrep status, killing the writer, and proving zero data loss In Part 1 we built a 3-node K3s cluster, installed OpenEverest, and created a 3-node Percona XtraDB Cluster (PXC) named mysql-vjg. In this post we look inside that cluster. Section A explains how to read Galera's wsrep_* status variables, so ... Continued The post Inside an OpenEverest MySQL Cluster: Galera Health and a Live Failover Test appeared first on Percona.

## Ten ways a glibc change can break your PostgreSQL cluster

DevFeed: [Ten ways a glibc change can break your PostgreSQL cluster](<https://devfeed.tech/articles/ten-ways-a-glibc-change-can-break-your-postgresql-cluster-129676.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/ten-ways-a-glibc-change-can-break-your-postgresql-cluster/>)

Author: Pablo Svampa

Published: 2026-11-11T20:46:25Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [comparison](<https://devfeed.tech/tags/comparison.md>), [corruption](<https://devfeed.tech/tags/corruption.md>), [database](<https://devfeed.tech/tags/database.md>), [glibc](<https://devfeed.tech/tags/glibc.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [text](<https://devfeed.tech/tags/text.md>)

### AI overview

glibc locale changes can leave PostgreSQL data and behavior inconsistent after an upgrade; rebuilding indexes alone may not repair the damage. The article demonstrates effects including missed index lookups, accepted duplicates, broken foreign-key enforcement, misplaced partition rows, stale CHECK constraints and generated values, and changed text-range results. It recommends diagnosing indexes with amcheck, auditing stored rows and constraints, removing duplicates where needed, moving mispartitioned rows, recomputing generated values and materialized views, then refreshing collation versions and running ANALYZE. Order matters: refresh materialized views only after rebuilding their source indexes, and refresh the collation version last. Some range-query changes are valid under the new locale rules and have no repair; review affected queries. The described audit queries cover columns but not expressions, and the author notes they may still be incomplete.

### Source excerpt

Between any two glibc versions, locales can change, and those changes alter the order of character string comparison (text/varchar/char/citext). It may also happen that locales are removed, such as en_US@ampm, present in RHEL8 and removed in RHEL9, and aa_ER@saaho, present in RHEL9 and then renamed to ssy_ER in RHEL10. Since PostgreSQL relies on locales to ... Continued The post Ten ways a glibc change can break your PostgreSQL cluster appeared first on Percona.

## Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL

DevFeed: [Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL](<https://devfeed.tech/articles/heavy-mysql-reports-in-seconds-open-source-htap-with-dbtrail-and-percona-server-for-mysql-127457.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/heavy-mysql-reports-in-seconds-open-source-htap-with-dbtrail-and-percona-server-for-mysql/>)

Author: Vadim Tkachenko

Published: 2026-11-10T21:04:03Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [column](<https://devfeed.tech/tags/column.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [docker](<https://devfeed.tech/tags/docker.md>), [docker-compose](<https://devfeed.tech/tags/docker-compose.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [hammerdb](<https://devfeed.tech/tags/hammerdb.md>), [history](<https://devfeed.tech/tags/history.md>), [htap](<https://devfeed.tech/tags/htap.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [reports](<https://devfeed.tech/tags/reports.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

In a DBTrail project benchmark, 12 of 14 analytical reports ran faster on DBTrail's columnar copy than on a Percona Server for MySQL replica; the slowest fell from 225 seconds to 7.94 seconds, while the two lightest reports favored Percona Server. Across 4,436 paired rounds, the copy was 6.5x faster by geometric mean, but it lagged the source by one to five minutes. DBTrail follows the database and uses query plans to route most SELECTs between the server and its copy without requiring rewritten or tagged queries. Its read-only port can be paired with ProxySQL to send writes and transactions to the source. In a separate MariaDB workload test with reports running alongside 400 transactions per second, routing through DBTrail kept p95 latency near 13 ms versus 6,960 ms with reports on the database, and 22x more reports completed. These are project-run results on specific workloads; the excerpt recommends benchmarking one's own reports.

### Source excerpt

In Part 1 we ran analytical reports in DuckDB on a DBTrail copy instead of on MySQL. This time I want to look at a different question: what if the application does not need to know the copy exists? Most MySQL servers have a few queries that make someone wait. The monthly report that aggregates ... Continued The post Heavy MySQL Reports in Seconds: Open Source HTAP with DBTrail and Percona Server for MySQL appeared first on Percona.

## Beyond the Version Bump: Running PostgreSQL Major Upgrades in Percona Operator for PostgreSQL

DevFeed: [Beyond the Version Bump: Running PostgreSQL Major Upgrades in Percona Operator for PostgreSQL](<https://devfeed.tech/articles/beyond-the-version-bump-running-postgresql-major-upgrades-in-percona-operator-for-postgresql-124174.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/beyond-the-version-bump-running-postgresql-major-upgrades-in-percona-operator-for-postgresql/>)

Author: Anil Joshi

Published: 2026-11-09T08:06:54Z

Content type: tutorial

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Operator for PostgreSQL](<https://devfeed.tech/topics/percona-operator-for-postgresql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [compatibility](<https://devfeed.tech/tags/compatibility.md>), [crd](<https://devfeed.tech/tags/crd.md>), [database](<https://devfeed.tech/tags/database.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [disk-space](<https://devfeed.tech/tags/disk-space.md>), [dump](<https://devfeed.tech/tags/dump.md>), [featured](<https://devfeed.tech/tags/featured.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [k8s](<https://devfeed.tech/tags/k8s.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [logical-replication](<https://devfeed.tech/tags/logical-replication.md>), [major](<https://devfeed.tech/tags/major.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-distribution-for-postgresql](<https://devfeed.tech/tags/percona-distribution-for-postgresql.md>), [percona-operator-for-postgresql](<https://devfeed.tech/tags/percona-operator-for-postgresql.md>), [percona-postgresql-operator](<https://devfeed.tech/tags/percona-postgresql-operator.md>), [percona-services](<https://devfeed.tech/tags/percona-services.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [planet-postgresql](<https://devfeed.tech/tags/planet-postgresql.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgres-major-upgrade](<https://devfeed.tech/tags/postgres-major-upgrade.md>), [postgres-upgrade](<https://devfeed.tech/tags/postgres-upgrade.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-18](<https://devfeed.tech/tags/postgresql-18.md>), [restore](<https://devfeed.tech/tags/restore.md>), [sql](<https://devfeed.tech/tags/sql.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>)

### AI overview

Percona Operator for PostgreSQL added in-place major upgrades through a PerconaPGUpgrade resource, first as a technical release in v2.4.0 and generally available in v2.9.0. The operator pauses and shuts down the cluster, runs `pg_upgrade --link` on the primary volume, resynchronizes replicas, then restarts the cluster on the new version. This avoids copying database files, reducing upgrade time and additional disk needs, but causes downtime and invalidates existing logical replicas, which must be checked and reseeded. The article recommends upgrading older operators to at least v2.4.0-1, checking OS/glibc and collation changes (including patch-level OS changes), validating extensions such as pgaudit, and rehearsing at least three upgrades with application checks before production cutover. It also describes checking the upgrade resource and logs if a run fails or stalls.

### Source excerpt

It was quite challenging to perform postgres major upgrade, e.g., v17 to v18, in a Percona operator/K8s environment. There was no convenient approach to accomplish this task. The only viable solutions left were a Manual Dump/Restore to a new environment or using Logical replication. But these options were not free from challenges. Procuring a new ... Continued The post Beyond the Version Bump: Running PostgreSQL Major Upgrades in Percona Operator for PostgreSQL appeared first on Percona.

## MongoDB 9.0 vs. 8.0 vs. 8.3: A Quick First Look at Performance

DevFeed: [MongoDB 9.0 vs. 8.0 vs. 8.3: A Quick First Look at Performance](<https://devfeed.tech/articles/mongodb-9-0-vs-8-0-vs-8-3-a-quick-first-look-at-performance-121692.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/mongodb-9-0-vs-8-0-vs-8-3-a-quick-first-look-at-performance/>)

Author: Ivan Groenewold

Published: 2026-11-06T10:36:47Z

Content type: comparison

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [gcp](<https://devfeed.tech/tags/gcp.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [performance](<https://devfeed.tech/tags/performance.md>)

### AI overview

In this quick test, MongoDB 9.0 used less CPU per operation than 8.0 and 8.3 across all three data sizes, yielding about 6% higher speed when CPU-bound and about 2% when memory or disk was the limit. The test used one deterministic PLGM flights workload on identical three-node replica sets, with one hardware configuration; all versions chose the same query plans. Results varied by data size and query type, and the 8M-document runs did not finish a full command pass within 30 minutes. The author presents the findings as an early indication, not an extensive benchmark or upgrade rationale, and recommends testing against one's own workload and server bottlenecks. PLGM can run custom queries or replay captured mongod traffic.

### Source excerpt

In my previous post I said that MongoDB published some impressive numbers for 9.0, but I couldn't find any details about how the tests were done. I ended with "always run your own benchmarks". So I figured I should follow my own advice. Let me be clear up front: this is a first, quick test, ... Continued The post MongoDB 9.0 vs. 8.0 vs. 8.3: A Quick First Look at Performance appeared first on Percona.

## WooCommerce Analytics with DuckDB

DevFeed: [WooCommerce Analytics with DuckDB](<https://devfeed.tech/articles/woocommerce-analytics-with-duckdb-119603.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/woocommerce-analytics-with-duckdb/>)

Author: Juan Arruti

Published: 2026-11-05T16:31:19Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [columnar](<https://devfeed.tech/tags/columnar.md>), [columnar-databases](<https://devfeed.tech/tags/columnar-databases.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [databases](<https://devfeed.tech/tags/databases.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [innodb](<https://devfeed.tech/tags/innodb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [storage-engine](<https://devfeed.tech/tags/storage-engine.md>), [woocommerce](<https://devfeed.tech/tags/woocommerce.md>)

### AI overview

Columnar DuckDB replicas can speed WooCommerce analytics while the primary MySQL InnoDB server handles transactions. In a test with 400,000 orders, asynchronous replication to AliSQL's DuckDB engine reduced database size from 7.3 GiB to 601 MiB. Built-in reports ran roughly 10-63 times faster, segmented reports 14-83 times faster, and all eleven reports from an unmodified customer analytics plugin were faster; a query against live order tables took about 4.1 seconds on DuckDB versus 4 minutes 16 seconds on InnoDB. The setup used a second copy of WooCommerce pointed at the replica because WordPress uses one database connection for analytics and store traffic. Results have caveats: some MySQL-specific SQL failed on DuckDB, text grouping can differ because DuckDB ignores column collations, and floating-point decimal handling caused sub-cent differences. DuckDB also exposes less monitoring detail. The article notes that Percona does not offer or support a production DuckDB build.

### Source excerpt

MySQL and DuckDB Unlike row-oriented databases, which store data for a single record sequentially on disk, favoring single-row lookups, columnar databases store all the values from a column contiguously in storage, allowing only the selected column to be read from disk. The default MySQL engine is InnoDB, which is ACID-compliant and great for OLTP (Online ... Continued The post WooCommerce Analytics with DuckDB appeared first on Percona.

## General Availability of Percona Search for MongoDB

DevFeed: [General Availability of Percona Search for MongoDB](<https://devfeed.tech/articles/general-availability-of-percona-search-for-mongodb-117803.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/general-availability-of-percona-search-for-mongodb/>)

Author: Radoslaw Szulgo

Published: 2026-11-03T18:48:06Z

Content type: release

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [hybrid-search](<https://devfeed.tech/topics/hybrid-search.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [Percona Software](<https://devfeed.tech/topics/percona-software.md>), [search-engines](<https://devfeed.tech/topics/search-engines.md>), [voyage-ai](<https://devfeed.tech/topics/voyage-ai.md>)

Tags: [air-gapped](<https://devfeed.tech/tags/air-gapped.md>), [alerting](<https://devfeed.tech/tags/alerting.md>), [api](<https://devfeed.tech/tags/api.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [availability](<https://devfeed.tech/tags/availability.md>), [azure-openai](<https://devfeed.tech/tags/azure-openai.md>), [backup](<https://devfeed.tech/tags/backup.md>), [bearer-token](<https://devfeed.tech/tags/bearer-token.md>), [embedding](<https://devfeed.tech/tags/embedding.md>), [general-availability](<https://devfeed.tech/tags/general-availability.md>), [hugging-face](<https://devfeed.tech/tags/hugging-face.md>), [hybrid](<https://devfeed.tech/tags/hybrid.md>), [inference](<https://devfeed.tech/tags/inference.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-search-for-mongodb](<https://devfeed.tech/tags/percona-search-for-mongodb.md>), [production](<https://devfeed.tech/tags/production.md>), [release](<https://devfeed.tech/tags/release.md>), [search](<https://devfeed.tech/tags/search.md>), [vector](<https://devfeed.tech/tags/vector.md>)

### AI overview

Percona Search for MongoDB 1.70.5-3 is generally available for production and adds Hugging Face Inference API as an automatic embedding provider. Its `mongot` process runs alongside `mongod`, syncing search indexes through change streams; automatic embeddings can keep vectors updated and embed queries without a separate application pipeline. Teams can choose providers per index: local OpenAI-compatible servers or in-cluster Hugging Face TEI keep text inside the cluster and work without outbound access, with hardware as the cost; hosted options include OpenAI, Azure OpenAI, Hugging Face Inference API, and Voyage AI. The new Hugging Face provider uses the `hf-inference` feature-extraction pipeline and a bearer-token access credential. The release is based on upstream `mongot` 1.70.5. Kubernetes deployment through Percona's Operator is supported; backup and monitoring are roadmap items. The text also identifies operational gaps: index rebuilds can take days, manual filesystem snapshots lack scheduling and point-in-time consistency, and high disk usage can leave search results stale without monitoring.

### Source excerpt

Percona Search for MongoDB 1.70.5-3 is now Generally Available and supported for production use. You can now easily run full-text, vector, and hybrid searches with automatic embedding on production Percona Server for MongoDB deployments. The release also adds the Hugging Face Inference API as a new automatic embedding provider. In this blog post, I cover why ... Continued The post General Availability of Percona Search for MongoDB appeared first on Percona.

## An alternative to sharding a MongoDB replica set that outgrew its memory: a proof of concept

DevFeed: [An alternative to sharding a MongoDB replica set that outgrew its memory: a proof of concept](<https://devfeed.tech/articles/an-alternative-to-sharding-a-mongodb-replica-set-that-outgrew-its-memory-a-proof-of-concept-112687.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/an-alternative-to-sharding-a-mongodb-replica-set-that-outgrew-its-memory-a-proof-of-concept/>)

Author: Zelmar Michelini

Published: 2026-11-02T17:34:07Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [sharding](<https://devfeed.tech/topics/sharding.md>)

Tags: [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [cache](<https://devfeed.tech/tags/cache.md>), [hetzner](<https://devfeed.tech/tags/hetzner.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [production](<https://devfeed.tech/tags/production.md>), [proof-of-concept](<https://devfeed.tech/tags/proof-of-concept.md>), [proxy](<https://devfeed.tech/tags/proxy.md>), [replica](<https://devfeed.tech/tags/replica.md>), [sharding](<https://devfeed.tech/tags/sharding.md>)

### AI overview

Thermocline is a proof of concept that places a smaller, faster MongoDB replica set in front of an existing replica set used as an archive. An application connects through a proxy; the fast tier starts empty and fills from archive data and documents requested by traffic, with document age determining tier placement. In Hetzner Cloud tests on the same hardware, the tiered setup handled 1.6x to 5.2x more operations per second, depending on workload; a recent-data-heavy mix rose from 4,447 to 23,340 operations per second, with read p95 latency falling from 86 ms to 6 ms. During a 30-minute cold-start test, throughput averaged 42% above the old cluster alone, passing its result after 100 seconds. Gains depend on workload: reads served by the fast tier benefit, while other traffic still reaches the archive. The author presents this as an unproven-in-production POC, not a demonstrated production replacement for sharding or larger servers.

### Source excerpt

An alternative to sharding a MongoDB replica set that outgrew its memory: a proof of concept A replica set that no longer fits in memory Most MongoDB replica sets start small. The working set fits in the WiredTiger cache, reads come from memory, and nobody thinks about disks. Then the data keeps growing. Orders, events ... Continued The post An alternative to sharding a MongoDB replica set that outgrew its memory: a proof of concept appeared first on Percona.

## What's New in PSMDB Sandbox: Six Months of Updates

DevFeed: [What's New in PSMDB Sandbox: Six Months of Updates](<https://devfeed.tech/articles/what-s-new-in-psmdb-sandbox-six-months-of-updates-109119.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/whats-new-in-psmdb-sandbox-six-months-of-updates/>)

Author: Ivan Groenewold

Published: 2026-10-30T11:14:05Z

Content type: release

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Software](<https://devfeed.tech/topics/percona-software.md>), [Ansible](<https://devfeed.tech/topics/ansible.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [ansible](<https://devfeed.tech/tags/ansible.md>), [automation](<https://devfeed.tech/tags/automation.md>), [aws](<https://devfeed.tech/tags/aws.md>), [azure](<https://devfeed.tech/tags/azure.md>), [backups](<https://devfeed.tech/tags/backups.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [changes](<https://devfeed.tech/tags/changes.md>), [clustersync-for-mongodb](<https://devfeed.tech/tags/clustersync-for-mongodb.md>), [community](<https://devfeed.tech/tags/community.md>), [features](<https://devfeed.tech/tags/features.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [pbm](<https://devfeed.tech/tags/pbm.md>), [pcsm](<https://devfeed.tech/tags/pcsm.md>), [percona](<https://devfeed.tech/tags/percona.md>), [platforms](<https://devfeed.tech/tags/platforms.md>), [pmm](<https://devfeed.tech/tags/pmm.md>), [ps4m](<https://devfeed.tech/tags/ps4m.md>), [psmdb](<https://devfeed.tech/tags/psmdb.md>), [sandbox](<https://devfeed.tech/tags/sandbox.md>), [terraform](<https://devfeed.tech/tags/terraform.md>), [ui](<https://devfeed.tech/tags/ui.md>), [updates](<https://devfeed.tech/tags/updates.md>), [web](<https://devfeed.tech/tags/web.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

PSMDB Sandbox has grown from a MongoDB automation UI into a broader lab for Percona's MongoDB stack. It can set up source and target clusters with Percona ClusterSync and monitor migration progress in PMM; deploy MongoDB Community, Enterprise, or PSMDB on VM targets; and test mongot search, Vault-backed encryption, LDAP, and audit logging. Users can disable PMM or PBM agents for lighter deployments, while MongoDB 9.x combinations with PBM, mongot, or PCSM are rejected until verified. The UI supports some post-deployment topology changes but blocks changes it cannot safely apply. New helpers install platform prerequisites, plgm replaces YCSB for load generation, and parallel Ansible runs shorten cloud configuration. The project is community maintained and not covered by Percona support.

### Source excerpt

Earlier this year, we introduced PSMDB Sandbox, a lightweight web UI that sits on top of our Terraform and Ansible automation for MongoDB. Since then, the project has changed a lot. It has a new name and repository, and it supports many more Percona products, MongoDB features and platforms. In this post, I will go ... Continued The post What's New in PSMDB Sandbox: Six Months of Updates appeared first on Percona.

## Benchmarking Vector search in six database engines

DevFeed: [Benchmarking Vector search in six database engines](<https://devfeed.tech/articles/benchmarking-vector-search-in-six-database-engines-107424.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/benchmarking-vector-search-in-six-database-engines/>)

Author: Evgeniy Patlan

Published: 2026-10-29T16:46:38Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [ann](<https://devfeed.tech/topics/ann.md>), [Database](<https://devfeed.tech/topics/database.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [ai-vector](<https://devfeed.tech/tags/ai-vector.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [clients](<https://devfeed.tech/tags/clients.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [database](<https://devfeed.tech/tags/database.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [databases](<https://devfeed.tech/tags/databases.md>), [dimensions](<https://devfeed.tech/tags/dimensions.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [engines](<https://devfeed.tech/tags/engines.md>), [hnsw](<https://devfeed.tech/tags/hnsw.md>), [index](<https://devfeed.tech/tags/index.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [memory](<https://devfeed.tech/tags/memory.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [openai](<https://devfeed.tech/tags/openai.md>), [search](<https://devfeed.tech/tags/search.md>), [vector](<https://devfeed.tech/tags/vector.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>)

### AI overview

In one run on one machine, six vector databases showed large differences in build time and index size, while four were within 2x throughput of each other at recall 0.99. Builds ranged from 1.9 minutes to 6.7 hours and indexes from 3.9 to 15.1 GiB. At 32 clients, pgvector reached 21.7x its single-client throughput; the three InnoDB-based engines stayed near 1x, though six concurrency results were withdrawn because MariaDB Connector/C clients could wait on the Python interpreter lock. Filter handling also differed: pgvector's default post-filtering could return fewer than k rows at low selectivity; MariaDB and AliSQL preserved recall but became extremely slow; Percona Search pre-filtered and sped up as filters tightened, with lower recall from scalar quantization; Valkey remained accurate and usable at 1%. The authors recommend pgvector for concurrent traffic with iterative scan enabled for filtered queries, Valkey for accurate fast filters when memory and write behavior suit, and MariaDB 12.3 for small, accurate indexes and modest concurrency. Results are limited to one corpus, dimensionality, machine, and run; three churn measurements were incomplete.

### Source excerpt

We loaded 990,000 OpenAI embeddings of 1,536 dimensions into six databases that index vectors themselves, built an HNSW index in each, and measured five things: time to a queryable index, storage and memory, recall against throughput, throughput under concurrent clients, and what happens when 10% of the corpus is rewritten. Same host, same container shape, ... Continued The post Benchmarking Vector search in six database engines appeared first on Percona.

## PLGM Has Grown Up: A New UI and Many More Features

DevFeed: [PLGM Has Grown Up: A New UI and Many More Features](<https://devfeed.tech/articles/plgm-has-grown-up-a-new-ui-and-many-more-features-107426.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/plgm-has-grown-up-a-new-ui-and-many-more-features/>)

Author: Daniel Almeida

Published: 2026-10-29T14:57:09Z

Content type: release

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [Test automation](<https://devfeed.tech/topics/test-automation.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [browser](<https://devfeed.tech/tags/browser.md>), [charts](<https://devfeed.tech/tags/charts.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [featured](<https://devfeed.tech/tags/featured.md>), [features](<https://devfeed.tech/tags/features.md>), [has](<https://devfeed.tech/tags/has.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [load](<https://devfeed.tech/tags/load.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [performance](<https://devfeed.tech/tags/performance.md>), [queries](<https://devfeed.tech/tags/queries.md>), [schema](<https://devfeed.tech/tags/schema.md>), [test](<https://devfeed.tech/tags/test.md>), [tips](<https://devfeed.tech/tags/tips.md>), [tool](<https://devfeed.tech/tags/tool.md>), [ui](<https://devfeed.tech/tags/ui.md>), [yaml](<https://devfeed.tech/tags/yaml.md>)

### AI overview

PLGM lets teams benchmark MongoDB using their own schemas and queries, and its new web UI adds workload modeling, query analysis, run trends, and replay across multiple servers. After a run, it samples executed queries with explain--including fast queries--and reports scan efficiency, latency, workload impact, execution overhead, and available $lookup work. It can suggest indexes based on existing indexes, while labeling its efficiency score as a rule of thumb and treating recommendations as suggestions to test. Trends compare retained runs and flag insufficient data as not comparable. For fair server comparisons, PLGM can replay recorded operations or generate deterministic traffic; it can also convert MongoDB JSON logs or system.profile exports into recordings. Across two to eight servers, it checks document counts and indexes before running and compares live charts and per-operation outcomes. Writes are analyzed without rerunning the actual write, and $out/$merge pipelines are only planned. Recordings and outcome files contain real query values, and should be handled like production data.

### Source excerpt

Back in December I introduced Percona Load Generator for MongoDB Clusters (PLGM), a benchmark tool built around one idea: test your database with your own schema and your own queries, not some random data. At the time, PLGM was a command-line tool. You edited a YAML file, ran the binary, and read the numbers in ... Continued The post PLGM Has Grown Up: A New UI and Many More Features appeared first on Percona.

## Percona Operator for MySQL 1.3.0: autopilot tuning, zero-data-loss async failover, encrypted PITR

DevFeed: [Percona Operator for MySQL 1.3.0: autopilot tuning, zero-data-loss async failover, encrypted PITR](<https://devfeed.tech/articles/percona-operator-for-mysql-1-3-0-autopilot-tuning-zero-data-loss-async-failover-encrypted-pitr-107425.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-operator-for-mysql-1-3-0/>)

Author: Slava Sarzhan

Published: 2026-10-29T14:24:47Z

Content type: release

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona](<https://devfeed.tech/topics/percona.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [Percona Software](<https://devfeed.tech/topics/percona-software.md>), [backups](<https://devfeed.tech/topics/backups.md>), [mysql group replication](<https://devfeed.tech/topics/mysql-group-replication.md>)

Tags: [1-3](<https://devfeed.tech/tags/1-3.md>), [3](<https://devfeed.tech/tags/3.md>), [async](<https://devfeed.tech/tags/async.md>), [asynchronous](<https://devfeed.tech/tags/asynchronous.md>), [automatic-configuration](<https://devfeed.tech/tags/automatic-configuration.md>), [autopilot](<https://devfeed.tech/tags/autopilot.md>), [backup](<https://devfeed.tech/tags/backup.md>), [backups](<https://devfeed.tech/tags/backups.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [data-loss](<https://devfeed.tech/tags/data-loss.md>), [encrypted](<https://devfeed.tech/tags/encrypted.md>), [failover](<https://devfeed.tech/tags/failover.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-operator-for-mysql](<https://devfeed.tech/tags/percona-operator-for-mysql.md>), [point-in-time-recovery](<https://devfeed.tech/tags/point-in-time-recovery.md>), [release](<https://devfeed.tech/tags/release.md>), [rest](<https://devfeed.tech/tags/rest.md>), [zero](<https://devfeed.tech/tags/zero.md>)

### AI overview

Percona Operator for MySQL 1.3.0 adds resource-based MySQL tuning, asynchronous failover that can recover transactions from the failed primary's binary logs before promotion, and encrypted binary log storage for point-in-time recovery. Auto-configuration requires both CPU and memory limits; variables that support it are updated live, while static settings trigger a rolling restart. Async clusters must have backups enabled or reconciliation stops. Failover waits up to an hour by default for the old primary's sidecar to provide missing logs; on timeout it can abort or promote with possible data loss. Encrypted PITR uses per-file keys wrapped by a key encryption key stored in a Kubernetes Secret; restore fails if the keyring or referenced key is missing. The release also enables leader election by default.

### Source excerpt

Percona Operator for MySQL 1.3.0 is out. This release moves three things forward for teams running MySQL on Kubernetes: the operator now tunes MySQL for you based on the pod resources, async clusters can fail over without losing data in flight, and point-in-time recovery works on clusters where binary logs are encrypted at rest. ... Continued The post Percona Operator for MySQL 1.3.0: autopilot tuning, zero-data-loss async failover, encrypted PITR appeared first on Percona.

## Why you should stop using ARBITERS in MongoDB

DevFeed: [Why you should stop using ARBITERS in MongoDB](<https://devfeed.tech/articles/why-you-should-stop-using-arbiters-in-mongodb-105591.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/why-you-should-stop-using-arbiters-in-mongodb/>)

Author: Jean da Silva

Published: 2026-10-28T22:07:29Z

Content type: opinion

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Post Mortem](<https://devfeed.tech/topics/post-mortem.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [arbiter](<https://devfeed.tech/tags/arbiter.md>), [atlas](<https://devfeed.tech/tags/atlas.md>), [availability](<https://devfeed.tech/tags/availability.md>), [big-data](<https://devfeed.tech/tags/big-data.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [data-center](<https://devfeed.tech/tags/data-center.md>), [data-replication](<https://devfeed.tech/tags/data-replication.md>), [durability](<https://devfeed.tech/tags/durability.md>), [elections](<https://devfeed.tech/tags/elections.md>), [fault-tolerance](<https://devfeed.tech/tags/fault-tolerance.md>), [flow-control](<https://devfeed.tech/tags/flow-control.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [percona](<https://devfeed.tech/tags/percona.md>), [performance](<https://devfeed.tech/tags/performance.md>)

### AI overview

The article recommends avoiding MongoDB arbiters in production because they provide election votes but store no data and do not count toward data-bearing acknowledgments, commit points, or flow control. Its incident examples describe write throughput collapsing after a data-center failure, writes being throttled when too few data-bearing members applied them, and acknowledged w:1 writes being rolled back after a primary failed before another node copied them. A third data-bearing node could preserve a copy in the latter scenario, though writes that never reach it can still roll back. The text says MongoDB recommends P-S-S for three-member sets; PSA is a lower-cost fallback with only two full data copies and weaker fault tolerance. It also lists constraints: multiple arbiters are disabled by default from MongoDB 5.3, arbiters can create majority-write and transaction limitations, and MongoDB Atlas tiers do not support them. The recommendation is to avoid arbiters unless the operator understands these tradeoffs.

### Source excerpt

This blog post was born of a discussion with a colleague in Percona Support, who also co-authored it with me here on the use of the ARBITER feature in MongoDB installations nowadays. Turns out, after analyzing past real cases we've faced in support, maybe it's time to say goodbye to ARBITERS. We are not saying ... Continued The post Why you should stop using ARBITERS in MongoDB appeared first on Percona.

## How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server

DevFeed: [How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server](<https://devfeed.tech/articles/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server-105590.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/how-to-extract-data-from-innodb-myisam-and-myrocks-files-without-a-running-server/>)

Author: Przemysław Malkowski

Published: 2026-10-28T13:13:49Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Tool](<https://devfeed.tech/topics/tool.md>), [IO](<https://devfeed.tech/topics/io.md>), [Data Quality](<https://devfeed.tech/topics/data-quality.md>)

Tags: [backup-and-recovery](<https://devfeed.tech/tags/backup-and-recovery.md>), [backups](<https://devfeed.tech/tags/backups.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bypass](<https://devfeed.tech/tags/bypass.md>), [cache](<https://devfeed.tech/tags/cache.md>), [cases](<https://devfeed.tech/tags/cases.md>), [complex](<https://devfeed.tech/tags/complex.md>), [data](<https://devfeed.tech/tags/data.md>), [data-recovery](<https://devfeed.tech/tags/data-recovery.md>), [database](<https://devfeed.tech/tags/database.md>), [directories](<https://devfeed.tech/tags/directories.md>), [files](<https://devfeed.tech/tags/files.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [innodb](<https://devfeed.tech/tags/innodb.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [offline](<https://devfeed.tech/tags/offline.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [server](<https://devfeed.tech/tags/server.md>), [snapshots](<https://devfeed.tech/tags/snapshots.md>), [storage](<https://devfeed.tech/tags/storage.md>), [storage-engine](<https://devfeed.tech/tags/storage-engine.md>), [tool](<https://devfeed.tech/tags/tool.md>), [volume](<https://devfeed.tech/tags/volume.md>)

### AI overview

innodump is an experimental, open-source tool for extracting rows offline from InnoDB, MyISAM, and MyRocks files without a running MySQL or MariaDB server. It can dump whole data directories, selected tables, databases, or files to SQL or MySQL Shell-compatible TSV. The `--skip-corrupted` option skips damaged pages, while `--examine` reports readable and corrupted rows; examination scans clustered indexes only and does not detect secondary-index corruption. `--deleted-only` can recover rows still present as delete-marked records. Direct file reads are not a backup method and do not guarantee consistency: live or unprepared files may yield missing, stale, or incorrectly flagged rows, and recently created tables may be absent. For live exports, the article recommends limiting I/O with `--io-limit`, using `--direct-io` to bypass the OS page cache, and reducing CPU priority with `nice`. The project is not officially supported by Percona.

### Source excerpt

Probably everyone responsible for managing database servers at some point realizes that it would be helpful to have a tool capable of extracting data directly from raw database files. Something completely offline, without the need to have a running database server, and that would work with data directories, files, or binary backups (storage volume snapshots, ... Continued The post How to Extract Data from InnoDB, MyISAM, and MyRocks Files Without a Running Server appeared first on Percona.

## PHP2Shell Vulnerability: Percona Security Update

DevFeed: [PHP2Shell Vulnerability: Percona Security Update](<https://devfeed.tech/articles/php2shell-vulnerability-percona-security-update-97751.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/php2shell-vulnerability-percona-security-update/>)

Author: John Lionis

Published: 2026-10-23T13:38:51Z

Content type: news

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [cve remediation](<https://devfeed.tech/topics/cve-remediation.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [Cloudflare](<https://devfeed.tech/topics/cloudflare.md>)

Tags: [cloudflare](<https://devfeed.tech/tags/cloudflare.md>), [code-execution](<https://devfeed.tech/tags/code-execution.md>), [cve](<https://devfeed.tech/tags/cve.md>), [cve-2026-109618](<https://devfeed.tech/tags/cve-2026-109618.md>), [cve-2026-109619](<https://devfeed.tech/tags/cve-2026-109619.md>), [indicators-of-compromise](<https://devfeed.tech/tags/indicators-of-compromise.md>), [iocs](<https://devfeed.tech/tags/iocs.md>), [mitigation](<https://devfeed.tech/tags/mitigation.md>), [patch](<https://devfeed.tech/tags/patch.md>), [patched](<https://devfeed.tech/tags/patched.md>), [percona](<https://devfeed.tech/tags/percona.md>), [php-remote-code-execution](<https://devfeed.tech/tags/php-remote-code-execution.md>), [php2shell](<https://devfeed.tech/tags/php2shell.md>), [remediation](<https://devfeed.tech/tags/remediation.md>), [remote-code-execution-vulnerability](<https://devfeed.tech/tags/remote-code-execution-vulnerability.md>), [security](<https://devfeed.tech/tags/security.md>), [security-advisories](<https://devfeed.tech/tags/security-advisories.md>), [security-patch](<https://devfeed.tech/tags/security-patch.md>), [security-update](<https://devfeed.tech/tags/security-update.md>), [services](<https://devfeed.tech/tags/services.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [vulnerability](<https://devfeed.tech/tags/vulnerability.md>)

### AI overview

Percona says Cloudflare mitigations were in place on affected systems before the official patches became available, and it deployed the patches once released. Its investigation found no customer data impact and no indicators of compromise; Percona reports that all systems have been patched. The company says it continues monitoring and will share further updates if significant findings emerge.

### Source excerpt

About PHP Remote Code Execution Vulnerability (PHP2Shell CVE-2026-109618 & CVE-2026-109619) Percona Security has been actively monitoring and responding to the recently disclosed PHP2Shell vulnerability, assessing its potential impact on our infrastructure and services.Protecting our customers and their data remains our highest priority. Following the disclosure, our Security and IT teams took immediate steps to ensure ... Continued The post PHP2Shell Vulnerability: Percona Security Update appeared first on Percona.

## "MongoDB was slow on Thursday": answering the app team with mongo-health

DevFeed: ["MongoDB was slow on Thursday": answering the app team with mongo-health](<https://devfeed.tech/articles/mongodb-was-slow-on-thursday-answering-the-app-team-with-mongo-health-88717.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/mongodb-was-slow-on-thursday-answering-the-app-team-with-mongo-health/>)

Author: Zelmar Michelini

Published: 2026-10-16T17:32:21Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>)

Tags: [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [docker](<https://devfeed.tech/tags/docker.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>)

### AI overview

mongo-health analyzes MongoDB diagnostic metrics to investigate past performance problems on self-managed and Atlas replica sets. It retains three months of per-second FTDC data and runs 68 checks hourly, reporting findings with charts and incident history. Examples cover missing indexes, slow storage, packet loss, checkpoints, write patterns and cache pressure. It complements live monitoring: it does not send alerts and does not yet support sharded clusters.

### Source excerpt

Monday, 9:00. The app team writes: "MongoDB was slow on Thursday afternoon. What happened?" No alert fired, nobody looked at the time, and now it is your problem. The answer is usually in the FTDC. Every mongod writes a sample of its own metrics once per second into diagnostic.data, and MongoDB calls this Full Time ... Continued The post "MongoDB was slow on Thursday": answering the app team with mongo-health appeared first on Percona.

## How Linux Large Folios Can Amplify Disk Writes in PXC/Galera Workloads

DevFeed: [How Linux Large Folios Can Amplify Disk Writes in PXC/Galera Workloads](<https://devfeed.tech/articles/when-a-small-change-writes-too-much-how-a-linux-kernel-improvement-can-strike-you-in-pxc-galera-workloads-88718.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/when-a-small-change-writes-too-much-how-a-linux-kernel-improvement-can-strike-you-in-pxc-galera-workloads/>)

Author: Przemysław Malkowski

Published: 2026-10-16T12:58:08Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Linux Kernel](<https://devfeed.tech/topics/linux-kernel.md>), [XFS](<https://devfeed.tech/topics/xfs.md>)

Tags: [galera](<https://devfeed.tech/tags/galera.md>), [hardware-and-storage](<https://devfeed.tech/tags/hardware-and-storage.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [large-folios](<https://devfeed.tech/tags/large-folios.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mmap](<https://devfeed.tech/tags/mmap.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [page-cache](<https://devfeed.tech/tags/page-cache.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

An investigation into periodic disk-write bursts in a PXC/Galera cluster links the behavior to Linux large folios after an operating system upgrade. Galera's memory-mapped cache can trigger writeback of entire folios for small updates, amplifying disk writes. The article explains why InnoDB writes behaved differently and discusses diagnostic signals and possible workarounds.

### Source excerpt

We've recently been dealing with an interesting customer case where a PXC version upgrade from 5.7 to 8.0 seemed to trigger a completely unexpected problem. Even though the workload and MySQL settings did not change, all PXC members began exhibiting sparse but regular bursts of massive disk writes. Yet the MySQL side workload statistics that ... Continued The post When a Small Change Writes Too Much - How A Linux Kernel Improvement Can Strike You in PXC/Galera Workloads appeared first on Percona.

## JavaScript in MySQL: Extending SQL, Not Moving the Application

DevFeed: [JavaScript in MySQL: Extending SQL, Not Moving the Application](<https://devfeed.tech/articles/javascript-in-mysql-extending-sql-not-moving-the-application-87983.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/javascript-in-mysql-extending-sql-not-moving-the-application/>)

Author: Marco Tusa

Published: 2026-10-15T15:12:30Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [JavaScript](<https://devfeed.tech/topics/javascript.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>)

Tags: [application-logic-vs-database-logic](<https://devfeed.tech/tags/application-logic-vs-database-logic.md>), [component-js-lang](<https://devfeed.tech/tags/component-js-lang.md>), [data-validation](<https://devfeed.tech/tags/data-validation.md>), [database-administration-dba](<https://devfeed.tech/tags/database-administration-dba.md>), [database-architecture](<https://devfeed.tech/tags/database-architecture.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [json-processing](<https://devfeed.tech/tags/json-processing.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona-live-europe-2026](<https://devfeed.tech/tags/percona-live-europe-2026.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [stored-procedures](<https://devfeed.tech/tags/stored-procedures.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [v8-engine](<https://devfeed.tech/tags/v8-engine.md>)

### AI overview

The article explains how JavaScript routines in MySQL can extend SQL with specialized data operations while keeping business decisions in application code. It describes runtime restrictions, demonstrations involving deduplication and validation, and criteria for deciding which functions belong in the database. It also recommends a shared review process for developers and database administrators. The feature is available as a technology preview in Percona Server for MySQL, with SQL execution from JavaScript still on its roadmap.

### Source excerpt

At Percona Live Europe 2026, Dmitry Lenev and I presented JavaScript in My Database? Over My Dead Query, the story of component_js_lang, the V8-based JavaScript engine for Percona Server for MySQL 8.4. That experience told us few things: The presentation was seen as "for developers" What most DBA or DevOps heard was "JavaScript in the ... Continued The post JavaScript in MySQL: Extending SQL, Not Moving the Application appeared first on Percona.

## Thread Pool in Percona Server and MySQL (Part 2)

DevFeed: [Thread Pool in Percona Server and MySQL (Part 2)](<https://devfeed.tech/articles/thread-pool-in-percona-server-and-mysql-part-2-85430.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/thread-pool-in-percona-server-and-mysql-part-2/>)

Author: Bogdan Degtyariov

Published: 2026-10-12T11:14:07Z

Content type: comparison

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [threadpools](<https://devfeed.tech/topics/threadpools.md>), [Percona](<https://devfeed.tech/topics/percona.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-thread-pool](<https://devfeed.tech/tags/mysql-thread-pool.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [thread-pool](<https://devfeed.tech/tags/thread-pool.md>)

### AI overview

The article compares thread pool performance in Percona Server for MySQL and MySQL across buffer pool sizes and connection counts. Percona's thread pool performs better when the data set is not fully buffered, while MySQL performs better in fully buffered tests. The article also reports that optimal thread pool settings differ between the two servers.

### Source excerpt

Thread Pool in Percona Server and MySQL (Part 2) The previous Part 1 focused on explaining the idea of thread pool, configuration options and analysis of thread pool efficiency in Percona Server for MySQL 9.7.1-1 against the base line, which is the same server without thread pooling. We recommend reading the post with Part 1 ... Continued The post Thread Pool in Percona Server and MySQL (Part 2) appeared first on Percona.

[Next page](<https://devfeed.tech/sources/blog-percona.md?cursor=WyIyMDI2LTEwLTEyVDExOjE0OjA3KzAwOjAwIiwgIjgyMzI0YTg2LTk1OWUtNGE0Yy04ZDczLWQxNWIxYTQyMzVlYyJd>)