# galera (blogs) — RSS Amplifier Recent posts from the 4 feeds in the RSS Amplifier directory that cover galera. Page: Feed: --- ## [Security Advisory: Privileged ClickHouse access through the Grafana data source in PMM](https://www.percona.com/blog/security-advisory-cve-affecting-pmm/) _2026-08-19 · Ben Judge · Blog - Percona_ Date of release: 19 August 2026 Severity: High Affected product: PMM Impacted versions: 3.9.0 and below Summary Percona has recently been made aware of a security vulnerability affecting PMM. We take the security of our products and the protection of our customers’ data with the utmost seriousness. This advisory describes the vulnerability, the immediate steps … Continued The post Security… ## [Stop guessing at gcache: inspect Galera/PXC write sets with gcache-inspector](https://www.percona.com/blog/stop-guessing-at-gcache-inspect-galera-pxc-write-sets-with-gcache-inspector/) _2026-08-19 · Przemysław Malkowski · Blog - Percona_ The common practice is to size the Galera Cache based on write volume measured during peak load, but often it is more of a guesswork. The writeset cache capacity planning is crucial to shorten the maintenance time and avoid long state transfers while the cluster runs with reduced compute power. Now, if you could understand … Continued The post Stop guessing at gcache: inspect Galera/PXC write sets… ## [Percona University Comes to Uruguay](https://www.percona.com/blog/percona-university-comes-to-uruguay/) _2026-08-17 · Agustín Gallego · Blog - Percona_ Percona University is coming to Montevideo. On September 23rd, 2026, we’re getting together for a full day of technical talks on open source software, and you are invited! If you work or study with open source software in Uruguay, this one is for you. It’s a whole day of learning, with the people who build … Continued The post Percona University Comes to Uruguay appeared first on Percona . ## [Replicating from InnoDB into a DuckDB storage engine](https://www.percona.com/blog/replicating-from-innodb-into-a-duckdb-storage-engine/) _2026-08-13 · Evgeniy Patlan · Blog - Percona_ Our first post showed MySQL 9.7 with one change: mark a table ENGINE=DuckDB and its analytical queries run in DuckDB instead of InnoDB. The question we kept getting after that was about replication. Can you keep a normal InnoDB primary for the writes, and run a replica where the big tables are ENGINE=DuckDB? Then the … Continued The post Replicating from InnoDB into a DuckDB storage engine… ## [Percona for MongoDB: RHEL 10, Its Derivatives, and Debian 13 – On Both x86\_64 and ARM](https://www.percona.com/blog/percona-for-mongodb-rhel-10-its-derivatives-and-debian-13-on-both-x86_64-and-arm/) _2026-08-11 · Radoslaw Szulgo · Blog - Percona_ We’re happy to announce that Percona Server for MongoDB (PSMDB) 8.0.28-12 extends platform support to RHEL 10 and its derivatives (Oracle Linux 10, Rocky Linux 10, AlmaLinux 10, and other RHEL-compatible distributions) for both x86\_64 and ARM (aarch64) architectures. This release also adds support for Debian 13 “Trixie” on x86\_64 and ARM64. We’ll continue to … Continued The post Percona for… ## [The open way of Percona Search for MongoDB](https://www.percona.com/blog/the-open-way-of-percona-search-for-mongodb/) _2026-08-07 · Radoslaw Szulgo · Blog - Percona_ Percona Search for MongoDB is Percona’s downstream distribution of mongot, the search engine that provides MongoDB’s full-text and vector search capabilities. With this addition, you can power your applications with AI and advanced search techniques – anywhere, and without vendor lock-in. It’s the same search engine that powers MongoDB Atlas Search. Percona Search for MongoDB … Continued The post… ## [The DuckDB MySQL engine at 500 GB](https://www.percona.com/blog/the-duckdb-mysql-engine-at-500-gb/) _2026-08-07 · Evgeniy Patlan · Blog - Percona_ We ran DuckDB MySQL storage engine at scale factor 500. It is around 500 GB of raw TPC-H, three billion lineitem rows on an 80-core server with 187 GB of RAM. Three engines on the same box: InnoDB, our MySQL+DuckDB engine, and plain DuckDB as the reference. Here is what came out. InnoDB finished 18 … Continued The post The DuckDB MySQL engine at 500 GB appeared first on Percona . ## [The diagnostic data MongoDB Atlas doesn’t hand you](https://www.percona.com/blog/the-diagnostic-data-mongodb-atlas-doesnt-hand-you/) _2026-08-06 · Zelmar Michelini · Blog - Percona_ The diagnostic data MongoDB Atlas doesn’t hand you Every MongoDB server keeps a flight recorder. It’s called FTDC, Full Time Diagnostic Data Capture, and it writes about 5,700 metrics every second into a folder called diagnostic.data, right next to your log. It’s delta-encoded and compressed so aggressively that days of history fit in a few … Continued The post The diagnostic data MongoDB Atlas… ## [Stored Procedures memory consumption in Percona Server for MySQL](https://www.percona.com/blog/stored-procedures-memory-consumption-in-percona-server-for-mysql/) _2026-07-31 · Bogdan Degtyariov · Blog - Percona_ 1. What it is about This investigation began as a performance comparison for different memory allocators. However, during benchmarking, I discovered unexpected effects deserving a more detailed explanation. I hope you find these findings both interesting and useful. Imagine you need to set up a MySQL database server. Every detail is planned: the operating system, … Continued The post Stored… ## [Percona Server for MongoDB 8.3 Technical Preview Is Now Available](https://www.percona.com/blog/percona-server-for-mongodb-8-3-technical-preview-is-now-available/) _2026-07-30 · Radoslaw Szulgo · Blog - Percona_ Percona Server for MongoDB 8.3 is available today as a Technical Preview. It is not for production. It is for your lab, your staging cluster, and your benchmark harness – and for sharing with us what works and what does not. Especially if this version is your segue to leverage upcoming full-text and vector search … Continued The post Percona Server for MongoDB 8.3 Technical Preview Is Now… ## [Home Internet From Space (Sponsored)](https://crawlproof.com/a/ifkgEv98k370) _2026-07-30 · **Sponsored**_ Residential satellite internet that brings connectivity to homes beyond conventional networks ## [Understanding OpenStack Networking: Geneve, VXLAN, and Hardware Offloading Explained](https://vahidhashemi.com/2026/07/07/understanding-openstack-networking-geneve-vxlan-and-hardware-offloading-explained/) _2026-07-07 · Vahid · vahidhsahemi.com_ Demystify OpenStack networking. This comprehensive guide breaks down the critical differences between OVS and OVN, explains why your overlay defaults matter, and outlines the exact hardware offload strategy needed to hit 100 Gbps efficiently. ## [Preparing Your Analytical Databases for Agents](https://vettabase.com/preparing-your-analytical-databases-for-agents/) _2026-06-27 · Federico Razzoli · Vettabase_ Agents can query databases: this has always been the dream of many data people! But there is some work to do to make this process reliable, secure, and valuable for your team. ## [Architecting High-Throughput Databases: Galera’s Synchronous Certification vs. PostgreSQL’s Decoupled MVCC and the Vacuum Trap](https://vahidhashemi.com/2026/06/12/architecting-high-throughput-databases-galeras-synchronous-certification-vs-postgresqls-decoupled-mvcc-and-the-vacuum-trap/) _2026-06-12 · Vahid · vahidhsahemi.com_ When engineering infrastructure for massive scale, the underlying database topology becomes the ultimate chokepoint. Traditional deployment paradigms often mask a harsh reality of connection bloat, network-bound deadlocks, and strict physical throughput limits. To design data planes that do not violently collapse under heavy concurrent workloads, architects must make a definitive choice between… ## [The CNF Illusion: Navigating the Realities of Cloud-Native Networking](https://vahidhashemi.com/2026/05/29/the-cnf-illusion-navigating-the-realities-of-cloud-native-networking/) _2026-05-29 · Vahid · vahidhsahemi.com_ If you keep an eye on the infrastructure space, you’ve almost certainly seen the headlines. The prevailing narrative—echoed in countless medium articles and vendor pitches—is that Cloud-Native Network Functions (CNFs) are the undisputed future, systematically replacing traditional network appliances and legacy Virtual Machines in 5G and enterprise networks. The pitch is undeniable: package your… ## [ATK-Rikoslaki - Aineistopesu](https://ospi.fi/blog/atk-rikoslaki-aineistopesu.html) _2026-05-06 · Oblog_ ## [SQL Savepoints and When to Use Them](https://vettabase.com/sql-savepoints-and-when-to-use-them/) _2026-01-22 · Federico Razzoli · Vettabase_ Not many developers know about savepoints in relational databases. Even less of them know when to use them. It’s not their fault: I can’t remember seeing a good explanation of this feature. Let’s try to clarify this lesser-known functionality. In this article I’m using MariaDB syntax. But the concepts are very similar for other transactional databases. To know the exact syntax you should use on a… ## [Vettabase and HammerDB Partner to de-Risk Database Migrations](https://vettabase.com/vettabase-and-hammerdb-partner-to-de-risk-database-migrations/) _2026-01-20 · Federico Razzoli · Vettabase_ Vettabase and HammerDB are announcing a partnership to de-risk and assist database migrations. As vendor-independent companies that offer services for multiple database technologies, Vettabase and HammerDB intend to help organisations in the delicate move of changing their database systems. For many teams, a migration to another database is a logical option — but it comes with real concerns: Our… ## [Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL](https://vettabase.com/distributed-multi-database-transactions-involving-mariadb-and-postgresql/) _2026-01-19 · Federico Razzoli · Vettabase_ In some situations, an application needs to run a single logical transaction that involves multiple database technologies: in our example, they’ll be MariaDB and PostgreSQL. This is not an optimal scenario and I’m not recommending to design systems in this way. But it’s simply a situation that you might have to deal with in real life, for various reasons that are outside of the scope of this… ## [MariaDB Underrated Features: Zero Dates and Partial Dates](https://vettabase.com/mariadb-underrated-features-zero-dates-and-partial-dates/) _2025-12-30 · Federico Razzoli · Vettabase_ How do you represent information like this in a database? There are many ways to do that. The most common is to split dates into three different columns, each of which will be NULL when it doesn’t have a specific value.But this makes dates harder to validate for the database, it’s inpractical because it complicates SQL queries, and NULL is error-prone. A more practical and efficient way to store… ## [Navigating Tree and Graph Data with Recursive SQL](https://vettabase.com/navigating-tree-and-graph-data-with-recursive-sql/) _2025-12-27 · Federico Razzoli · Vettabase_ Hierarchical and networked data appears everywhere in modern databases: organisational charts, product category trees, dependency graphs, and even transport networks. Applications need to retrieve this data to draw a chart, find out whom a certain employee reports to, or find the routes that connect two train stops. Storing and querying this kind of data in a relational database is not trivial. If… ## [Hire AI-Powered Professionals (Sponsored)](https://crawlproof.com/a/QDg41uBhGBZ6) _2025-12-27 · **Sponsored**_ Browse public gigs, message candidates, and run video interviews — free to start. ## [Deploying garbd (Galera Arbitrator Daemon) | MariaDB Galera pt 2](https://vettabase.com/deploying-garbd-galera-arbitrator-daemon-mariadb-galera-pt-2/) _2025-12-11 · Mike Rykmas · Vettabase_ In the first part of this series, we deployed a 3-node MariaDB Galera Cluster on Ubuntu 24.04. While a 3-node topology provides the best fault tolerance, sometimes you need a simpler setup – for example, a two-node cluster with a lightweight arbitrator to maintain quorum without running a full third MariaDB instance. At Vettabase, we often use this pattern in small or resource-limited… ## [Installing a MariaDB Galera Cluster on Ubuntu 24.04 | MariaDB Galera pt 1](https://vettabase.com/installing-a-3-node-mariadb-galera-cluster-on-ubuntu-24-04-mariadb-galera-pt-1/) _2025-12-04 · Mike Rykmas · Vettabase_ At Vettabase, we’re starting a new blog series on High Availability (HA) with focus on MariaDB Galera Cluster. This series will be a collection of hands-on guides, each tackling one practical topic: from installation, configuration, and adding or removing nodes, to backups, upgrades, and schema changes. Our goal is simple: create a complete, practical reference that anyone can follow to deploy and… ## [Benefits of Importing Data with MariaDB CONNECT and PostgreSQL Data Wrappers](https://vettabase.com/benefits-of-importing-data-with-mariadb-connect-and-postgresql-data-wrappers/) _2025-12-02 · Federico Razzoli · Vettabase_ There are many ways to import data from external sources into a database. MariaDB and PostgreSQL offer native solutions: the MariaDB CONNECT storage engine and PostgreSQL Foreign Data Wrappers. Unfortunately, these options are often overlooked, in favour of more expensive, more fragile and slower solutions. Let’s see what CONNECT and FDWs are, and why they are often the best choice for importing… ## [Powershelling to renew certificates on Windows servers](https://ospi.fi/blog/powershelling-to-renew-certificates-on-windows-servers.html) _2025-11-13 · Oblog_ ## [SRA 8.1 taulut vektorigrafiikkana](https://ospi.fi/blog/sra-8-1-taulut-vektorigrafiikkana.html) _2025-11-09 · Oblog_ ## [Automation Via UEFI](https://vahidhashemi.com/2025/11/05/automation-via-uefi/) _2025-11-05 · Vahid · vahidhsahemi.com_ In large-scale datacenter environments, traditional BIOS-based automation quickly becomes a bottleneck. This post explores how I automated server provisioning and RAID configuration directly through UEFI, without using a live OS. From building a bootable ISO with xorriso to embedding BOOTX64.EFI from EDK2, we’ll walk through each step — creating startup scripts, managing RAID controllers, and… ## [Why Your Database Deserves Consistent Names and Types](https://vettabase.com/why-your-database-deserves-consistent-names-and-types/) _2025-08-22 · Federico Razzoli · Vettabase_ I see a lot of problems with database schemas: missing indexes, wrong types, tables used like an spreadsheet… but all these problems are widely known. An often overlooked problem is inconsistency. Let me explain how you should guarantee database consistency, and how inconsistency is making your life more sad than it would be otherwise. What Schema Inconsistency Is The inconsistencies we’ll talk… ## [Pipewire, pro-audio, default sink/source](https://ospi.fi/blog/pipewire-pro-audio-default-sink-source.html) _2024-09-28 · Oblog_ ## [Wireplumber 0.5 disable alsa devices and pro-audio](https://ospi.fi/blog/wireplumber-0-5-disable-alsa-devices-and-pro-audio.html) _2024-09-03 · Oblog_ ## [Ultra-Quiet Business Mini (Sponsored)](https://crawlproof.com/a/42oyg4TsNS1g) _2024-09-03 · **Sponsored**_ Compact business mini, ultra-quiet for focused work. ## [Galera nodes and GTID drifting](https://ospi.fi/blog/galera-nodes-and-gtid-drifting.html) _2024-09-03 · Oblog_