Planet MariaDB Server

ClusterControl 2.5.0 is here, and it marks a milestone for the platform: ClickHouse joins the family of supported database engines — and with it, a capability no analytics vendor’s cloud can offer you. Wherever you run ClusterControl — on-premises, in any cloud, or hybrid — you can now deploy ClickHouse either as a standalone OLAP […] The post ClusterControl 2.5.0 brings ClickHouse support to on-prem, cloud and hybrid environments appeared first on Severalnines…. Read more

I have known for some times that there is an interesting improvement in MySQL 8.0.17 regarding GTID Crash Safety, but I have not had the time nor the need to look into it before.  When writing my last post (Understanding MySQL Replication "fatal error 1236": […]), I saw something interesting related to this, and it is now time to cover this on my blog. From my point of view, this change is… Read more

Every organization now operates in a world where data doesn’t just need to be secure – it needs to be […]… Read more

Be it known: MariaDB Server now has a clearer, publicly documented governance framework covering technical roles, subsystem ownership, decision-making, response expectations and continuity. Open source begins with access to the code. … Continue reading "Hear Ye, Hear Ye: A Guide to MariaDB’s Governance Model" Hear Ye, Hear Ye: A Guide to MariaDB’s Governance Model appeared first on MariaDB.org… Read more

This MySQL replication error — fatal error 1236 / Replica has more GTIDs than the source has, using the source's SERVER_UUID — shows the importance of thinking before acting. I am glad a non-DBA Colleague asked me about this error, because if he would just have restarted replication, it would have caused a much bigger mess. Often, we are tempted — or pushed — to just… Read more

We are pleased to welcome Wirekite as a new Silver Sponsor of MariaDB Foundation. Wirekite is an enterprise data movement platform focused on high-performance extract, load, migration, and replication workflows. … Continue reading "Wirekite becomes Silver Sponsor of MariaDB Foundation" The post Wirekite becomes Silver Sponsor of MariaDB Foundation appeared first on MariaDB.org…. Read more

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 Procedures memory consumption in Percona Server for MySQL appeared first on Percona…. Read more

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 Available appeared first on Percona…. Read more

Today, I was reminded of a MySQL Best Practice, probably generalizable to all databases : using simple types, not complex types.  Such complex types to avoid include the date and time data types (including TIMESTAMP) and ENUM.  Let's see why. A little history about this, Baron Schwartz, a MySQL Legend who is not involved in the community anymore, compared using the TIMESTAMP type to… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/J 3.5.10, 3.4.4, 3.3.6, and 2.7.15 releases. Release Notes […]… Read more

A production bottleneck at Headout led to a new MariaDB Server improvement. This is the story of how engineers, maintainers and AI-assisted development turned a real-world problem into an upstream open-source contribution. The post From a Production Problem to MariaDB: Headout’s Open-Source Contribution Journey appeared first on MariaDB.org…. Read more

Achieving Fast Vector Search in MariaDB MariaDB Server 12.3 makes vector search faster where it matters most: the high-recall levels […]… Read more

We recently tested the PostgreSQL backup tool pg_basebackup and were very impressed with its remote backup functionality, which allows for both physical local and physical remote backups. This led us to wonder whether a physical remote backup is also possible using the “new” MySQL Server Clone feature, which was introduced in MySQL 8.0.17 (July 2019). The MySQL Clone operation can be used to create both a local and a remote copy of the database. The original idea behind this feature was likely to automatically create nodes in an InnoDB Cluster (similar to Percona XtraDB Cluster SST). Terminology used in the… Read more

Adobe Commerce is making MariaDB its default and recommended database platform. The post Adobe Commerce Chooses MariaDB as Its Default Database Platform appeared first on MariaDB.org…. Read more

Global cloud hosting provider supports the continued development and adoption of open-source MariaDB MariaDB Foundation is pleased to welcome ScalaHosting as a Gold Sponsor, strengthening the relationship between the MariaDB community and one of the hosting industry’s established cloud infrastructure providers. … Continue reading "ScalaHosting Becomes a Gold Sponsor of MariaDB Foundation" The post ScalaHosting Becomes a Gold Sponsor of MariaDB Foundation appeared first on MariaDB.org…. Read more