Planet MariaDB Server

Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting their similarities […]… Read more

This post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare MariaDB and MySQL and see whether they get better or worse over time. The results here are from the newest small servers in my test cluster — an ASUS PN53.This work was done by Small Datum LLC and sponsored by the MariaDB Foundation.The workload here has low concurrency (1 or 4 clients) and the database is cached. The results might be different when the workload is IO-bound or has more concurrency. Results were recently shared from tests run on an older small server. tl;drModern MariaDB (11.4.1)… Read more

A healthy ecosystem around MariaDB Server involves an active community. Lots of happy code contributors cause fast development of new functionality, as well as increased adoption by users. … Continue reading "Towards a healthy ecosystem" The post Towards a healthy ecosystem appeared first on MariaDB.org…. Read more

Large language models (LLMs) have taken the world by storm, wowing us with their ability to generate remarkably human-like text. But for all their prowess, these AI marvels still face major roadblocks – especially when it comes to knowledge-intensive tasks requiring up-to-date, factual information. While LLMs excel at generating human-like text based on the patterns […] The post Improving LLM Fidelity with Retrieval Augmented Generation using pgvector appeared first on Severalnines…. Read more

Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]… Read more

The DATE_BUCKET function is a powerful tool in PostgreSQL for handling time-series data, particularly useful for aggregating records into fixed intervals. This function isn’t available in all versions of PostgreSQL or might require specific extensions […] The post Mastering Time-Series Analysis in PostgreSQL with the DATE_BUCKET Function appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

We say: Put your AI vectors into your RDBMS … Relational databases are where AI data belongs. Users need their vectors along with the rest of their data, in a standard database which offers performance, scalability, and all the other traditional virtues, such as ACID compliance. … Continue reading "MariaDB is soon a vector database, too" The post MariaDB is soon a vector database, too appeared first on MariaDB.org…. Read more

Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […]… Read more

PostgreSQL Performance Troubleshooting Whitepaper – Using eBPF to Troubleshoot Process Contention in PostgreSQL To use eBPF for troubleshooting process contention in PostgreSQL, we focus on understanding how processes are interacting with each other, particularly in […] The post Using eBPF to Troubleshoot Process Contention in PostgreSQL: A Guide to Monitoring Locks, CPU, and I/O Performance appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Significance of MySQL support and consulting services for efficient database management, particularly focusing on optimizing performance, ensuring security, and handling scalability challenges. Rising demand for professional MySQL consulting due to the complexity of managing expanding databases and the scarcity of MySQL expertise. Details of various optimization techniques, capacity planning strategies, and comprehensive DBA services offered by MySQL consultants. Importance of monitoring, alerting, and security measures such as access control and encryption. Discussion of emergency support channels and the benefits of managed services for MySQL databases, including cost savings and proactive maintenance. Exploration of project-based consulting and the advantages of establishing… Read more

Welcome Valkey to the Percona family! We are excited to have you join our team of MySQL, PostgreSQL, and MongoDB database experts.Hang on. What is Valkey? In short, Valkey is a fork of Redis which maintains the original open source BSD license[1]. If you’re new to Redis/Valkey, then this ‘getting started’ post is just for […]… Read more

mysql_proto_collation html { color: #1a1a1a; background-color: #fdfdfd; } body { margin: 0 auto; max-width: 36em; padding-left: 50px; padding-right: 50px; padding-top: 50px; padding-bottom: 50px; hyphens: auto; overflow-wrap: break-word; text-rendering: optimizeLegibility; font-kerning: normal; } @media (max-width: 600px) { body { font-size: 0.9em; padding: 12px; } h1 { font-size: 1.8em; } } @media print { html { background-color: white; } body { background-color: transparent; color: black; font-size: 12pt; } p, h2, h3 { orphans: 3; widows: 3; } h2, h3, h4 { page-break-after: avoid; } } p { margin: 1em 0; } a { color: #1a1a1a; } a:visited { color: #1a1a1a; } img… Read more

When deciding between Amazon Aurora and Amazon RDS (Relational Database Service), it’s crucial to understand the distinct capabilities and advantages each offers for managing relational databases on AWS. Both services are designed to simplify database […] The post Choosing Between Amazon RDS and Aurora: A Comprehensive Guide to AWS Database Solutions appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36-26.18 (release notes, download). There is no change to the Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous […]… Read more

Let’s explore how temporary tables work in MariaDB. First, we have to connect to the server…. Read more