Planet MariaDB Server

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived.Let us consider our architecture below with async replication from PXC to Percona Server for […]… Read more

Remember our open letter, Looking for MySQL 5.7 or 8.0 guinea pigs? We caught a nice German guinea pig! We caught a nice guinea pig, a German one, from Hannover. … Continue reading "Looking for more migration guinea pigs" The post Looking for more migration guinea pigs appeared first on MariaDB.org…. Read more

In MySQL, configuring the number of background InnoDB I/O threads is crucial for performance optimization, especially on servers with multiple cores and high I/O capacity. InnoDB uses background threads for tasks like flushing dirty pages, […] The post How to configure the Number of Background InnoDB I/O Threads in MySQL 8 for performance? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Parallel redo logging in InnoDB, introduced in MySQL 8.0, is a significant enhancement aimed at improving the performance of write-heavy workloads. It enhances the efficiency of redo log operations, particularly on systems with multiple CPU […] The post How Parallel Redo Logs works in InnoDB works in MySQL 8? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Configuring SKIP_DATABASE_STATS and ONLY_DATABASE_STATS in PostgreSQL requires careful consideration to ensure optimal performance: Impact on Restore Time and Performance: Omitting database-wide statistics with SKIP_DATABASE_STATS can speed up the dump process and reduce its size. However, […] The post Optimize PostgreSQL Performance: Strategic Use of SKIP_DATABASE_STATS and ONLY_DATABASE_STATS appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment.When combined with the versatility of Docker containers, […]… Read more

In many scenarios, the standard alert notification template in Percona Monitoring and Management (PMM), while comprehensive, may not align perfectly with specific operational needs. This often leads to an excess of details in the notification’s “Subject” and “Body”, cluttering your inbox with information that may not be immediately relevant. The focus today is on tailoring […]… Read more

“Generative AI is a can of worms that has to be opened”. That was the laconic comment from a senior industry influencer, when I shared MariaDB Foundation’s plans for successively making MariaDB Server a platform for AI solutions. … Continue reading "Generative AI and MariaDB Server" The post Generative AI and MariaDB Server appeared first on MariaDB.org…. Read more

In PostgreSQL 16, pg_dump has become faster due to the introduction of new compression methods: LZ4 and ZSTD. LZ4 Compression: LZ4 is known for its high-speed compression and decompression. While it may result in slightly […] The post Speed Up Your PostgreSQL 16 Backups with Improved pg_dump appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

pgvector is an open-source extension for PostgreSQL designed to efficiently handle vector data within the database. It's particularly useful for machine learning and similar applications where working with vector data is common. To install and […] The post Installing and Configuring pgvector in PostgreSQL: A Step-by-Step Guide appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

During an interview or while having general discussions, I have found some funny responses that can be easily classified as “Wrong Answers,” but at times, they’re thought-provoking or involve a deep meaning within. This blog is regarding some of the usual MySQL database conversations and responses, which can appear “wrong” or “funny,” but there’s actually […]… Read more

In this post, I will present a new Percona tool: Percona Monitoring and Management (PMM) Dump. The PMM Dump performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server securely […]… Read more

Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot, exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. It was a fascinating read, shedding light on leveraging AWS snapshots’ capabilities to avoid initial data copy within the […]… Read more

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.1.20 and 3.2.1 RC, Connector/C 3.3.8 and 3.1.23, and … Continued… Read more

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups showcase the latest Percona software updates, tools, […]… Read more