Planet MariaDB Server

If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]… Read more

The 27th is fast approaching but you can still signup to our live webinar where we will be exploring the benefits of time series data using MariaDB ColumnStore…. Read more

We’re excited to announce SkySQL has joined the MariaDB Foundation as a Silver sponsor. SkySQL is the first and only database service designed, built and optimised specifically for MariaDB Server. … Continue reading "SkySQL is our new Silver sponsor!" The post SkySQL is our new Silver sponsor! appeared first on MariaDB.org…. Read more

We are pleased to announce the general availability (GA) of MariaDB Connector/J 3.4. MariaDB Connector/J 3.4 is the newest version … Continued… Read more

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.8, MariaDB 10.6.18, MariaDB 10.5.25 and MariaDB 10.4.34, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.4, MariaDB 11.1.5 and MariaDB 11.0.6, the latest stable releases in their respective short-term series (maintained for one year). … Continue reading "MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available" The post MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available appeared first on MariaDB.org…. Read more

Both MariaDB and MySQL have been around a long time now, and there is always a difficult balance between maintaining compatibility whilst also solving security issues that arise. … Continue reading "MariaDB Dump File Compatibility Change" The post MariaDB Dump File Compatibility Change appeared first on MariaDB.org…. Read more

Many applications have dozens and sometimes even thousands of CRUD screens (Create, Read, Update, and Delete)…. Read more

AI was everywhere at Intel Vision this week in London. Nearly every keynote and breakout presentation was centred around AI. I had the honour of being interviewed by Intel’s jovial Chief Commercial Officer Christoph Schell, who is just about as stereotypically German as his former neighbour from Stuttgart Jürgen Klopp (whom he referenced on-stage), namely: not at all. … Continue reading "MariaDB Vector at Intel Vision – AI Everywhere" The post MariaDB Vector at Intel Vision – AI Everywhere appeared first on MariaDB.org…. Read more

MariaDB Performance Schema is a powerful tool designed to monitor and analyze the performance of your MariaDB server. It provides … Continued… Read more

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