Planet MariaDB Server

New maintenance releases for MariaDB Enterprise Server 10.6.20-16 and 10.5.27-21 are now available. These releases include new backported features. Download … Continued… Read more

In this post, we demonstrate improvements in planned failover downtime of Multi-AZ instance deployment with Amazon RDS Proxy, a result of several optimizations made by RDS. In the event of a failure, Amazon RDS automatically switches the roles of the primary and standby instances and updates the IP address associated with the database’s DNS (hostname). This allows client applications to maintain their connection settings during failover. This process, known as DNS propagation, can take up to 35 seconds to complete. RDS Proxy eliminates the 35 seconds of DNS propagation delay by continuously monitoring both instances, allowing it to bypass DNS… Read more

Still running after Stonebraker’s prediction about database engine convergenceWhat is OQGRAPH?OQGRAPH, or the Open Query GRAPH engine, is a specialized storage engine designed for handling hierarchical and complex graph data within relational database management systems (RDBMS) like MariaDB. It allows users to access and manipulate data as graphs, which is particularly useful for storing and querying relationships, such as social networks, routes, or any data with complex connectionsKey Features of OQGRAPHGraph Data Structure: OQGRAPH supports various types of graphs, including directed, undirected, weighted, unweighted, bipartite, and hypergraphs. It uses a B+ Tree to store its data structures, enabling efficient access to graph dataIntegration… Read more

Clustercontrol (CC) v2.3.0 is now live, featuring new enterprise binaries support for Percona Server Pro clusters and support for MySQL v8.4, Elasticsearch v8.15, and Valkey v8.0. Let’s dive into these key updates and discover what’s new! New enterprise binaries with compatibility for Percona Server Pro We have upgraded our enterprise binaries with Percona Server Pro […] The post Clustercontrol adds Percona Server Pro, and support for MySQL v8.4, Elasticsearch v8.15, Valkey v8.0 in latest release appeared first on Severalnines…. Read more

MariaDB MaxScale is an excellent solution for making your MariaDB Server database deployments highly available… but how do you make … Continued… Read more

Nowadays, there is a common misconceptions that we don’t need to optimise the technologies we use, because we can just scale out or scale up. Whereas scaling out means to add one or more instances of a technology, and scaling up means to run the technology on better servers. Both these options are made easy by the cloud. The drawbacks This approach has several problems: The “scale instead of optimising” is an exaggeration of the DevOps approach, which is a great methodology, but it works best for stateless technologies. This means that the drawbacks of this approach are bigger when… Read more

You like LEGOs ? so do Ialso that why i like MariadB so much !Lego has long been celebrated as a powerful tool for creativity and imagination, allowing builders of all ages to construct anything they can envision within the constraints set by the building blocks. Each Lego piece serves as a fundamental component, offering a unique shape, color, and function that can be combined in countless ways. The beauty of Lego lies in its ability to foster innovation within boundaries. Builders learn to navigate these limitations, using their imagination to create structures that are not only functional but also artistic. By engaging… Read more

TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it (i.e., executed using INPLACE algorithm) and concurrent DML or purge activity on the table can occasionally lead to two significant problems: ALTER/OPTIMIZE TABLE failing with an unnecessary duplicate key error (even though there are no […]… Read more

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote five posts on the subject, they are listed below.  In this post, I use the knowledge we gained in the previous two posts to show the interest of tuning InnoDB Tablespace Duplicate Check Threads, making startup 30% in one case (2:28 vs. 3:33) and 5% in… 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.40-26.21 (release notes, download), with Galera replication library 4.21 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3-26.21 (release notes, download), our […]… Read more

MySQL 8.4 and newer have extended the Global Transaction ID (GTID) functionality with a new “tag” option. Refresher on GTID A GTID is a unique ID that is assigned to a transaction. This is used if gtid_mode is set to ON. The benefit of this is that a transaction can be uniquely identified in a MySQL replication setup with multiple levels. Among others this makes it easier to refactor a replication tree as a MySQL replica knows which transactions it has seen and can use this to find the right position to start replicating from a new source. The format… Read more

I am writing this quick post to share what I think is a problematic new behavior of Offline Mode in MySQL 9.  Basically, the new default behavior in MySQL 9 is to write the username of the user which set offline_mode to ON.  I think this behavior has not been considered from a security point of view because it leaks a root username in the error message presented to the users. My… Read more

Percona Monitoring and Management 3.0.0 Beta – Tech Preview We’re excited to announce the Tech Preview (Beta) release of Percona Monitoring and Management (PMM) 3.0.0-Beta. This release is intended for testing environments only, as it’s not yet production-ready. The GA (General Availability) release will be available through standard channels in the upcoming months. Release notes To see the full list of changes, check out the 3.0.0-Beta – Tech Preview Release Notes… Read more

This post show that RocksDB has gotten much faster over time for the read-heavy benchmarks that I use. I recently shared results from a large server to show the speedup from the hyperclock block cache implementation for different concurrency levels with RocksDB 9.6. Here I share results from the same server and different (old and new) RocksDB releases.Results are amazing on a large (48 cores) server with 40 client threads~2X more QPS for range queries with hyperclock~3X more QPS for point queries with hyperclockSoftwareI used RocksDB versions 6.0.2, 6.29.5, 7.0.4, 7.6.0, 7.7.8, 8.5.4, 8.6.7, 9.0.1, 9.1.2, 9.3.2, 9.5.2, 9.7.4 and… Read more

The day has come that you have been waiting for since the ChatGPT hype began: You can now build creative AI apps using your own data in MariaDB Server! … Continue reading "Try RAG with MariaDB Vector on your own MariaDB data!" The post Try RAG with MariaDB Vector on your own MariaDB data! appeared first on MariaDB.org…. Read more