Planet MariaDB

Geo-Distributed MySQL Clusters for the Enterprise Oracle MySQL InnoDB Cluster provides high availability and scalability for MySQL. An InnoDB Cluster consists of 3 or more MySQL instances in a local network with group replication enabled, MySQL Shell which is used for management of the cluster, and optionally MySQL Router to provide basic routing from applications to the cluster. While this provides high availability in a local region or site, it does not provide any provisions for disaster recovery (DR) or any multi-site deployment in general, so let’s explore how we could extend the functionality of InnoDB Cluster to deploy at… Read more

Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we consider a poor definition of a Primary Key in InnoDB […]… Read more

MariaDB has been using a pluggable storage engine architecture for a long time and whilst this means great flexibility in choosing and managing the right storage engines for specific use cases, it also means they are easier to develop and therefore there’s an expectation that more engines will be created. … Continue reading "10.7 preview feature: Compression Provider Plugins" The post 10.7 preview feature: Compression Provider Plugins appeared first on MariaDB.org…. Read more

The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level variables (one of the most requested features!), 2) we developed a better […]… Read more

If you are using MariaDB for some time now you may have heard about adaptive flushing. “Adaptive” refers to a behavior where-in the algorithm auto-tunes itself based on certain parameters. In the new-generation world, it is called an “AI-based algorithm”. The same concept is now being applied to purge. Purge is a critical and resource-consuming operation so scheduling of purge along with user workload needs to be balanced. This is what exactly adaptive purge would do…. Read more

Natural sort order is the ordering of strings in alphabetical order, while numbers are treated as numbers. This understanding of sorting is closer to human comprehension than to a machine. … Continue reading "10.7 preview feature: Natural sort" The post 10.7 preview feature: Natural sort appeared first on MariaDB.org…. Read more

UUIDs have a common place in computing already. A 128-bit value with a text representational value and the prescription of a number of version types to ensure a uniqueness makes it an ideal data type. … Continue reading "10.7 preview feature: UUID Data Type" The post 10.7 preview feature: UUID Data Type appeared first on MariaDB.org…. Read more

Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day tasks like making the backups, renewing certificates, and so on.  If a few years […]… Read more

Now is the time to try out the new candidate features of MariaDB Server 10.7, the next release series of MariaDB! This blog describes how the new preview releases work, and where we need your help as a MariaDB user. … Continue reading "10.7.0 Comes As Preview Releases" The post 10.7.0 Comes As Preview Releases appeared first on MariaDB.org…. Read more

MariaDB Enterprise Server 10.5, 10.4, 10.3 and 10.2 receive important backported features for customers including ARM support & enhanced semi-sync replication…. Read more

If we could divide our QA into layers, at the bottom layer there are tests of specific features and scenarios. These consist of steps, how to reproduce a certain feature, and how to validate that feature. Individual tests of features and scenarios can be grouped together according to similar characteristics, for example: tests for features/scenarios grouped by topology, tests for TPM, connector tests, API tests…let’s name these groups of tests: “test suites.” At the very beginning of our CI/CD pipeline, source code and test suites are handed over to our Bamboo server. Bamboo is a continuous integration tool from Atlassian… Read more

When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C to be a replica of B, i.e: You […]… Read more

Update your calendars: The MariaDB ServerFest has moved to be two weeks later, Tue-Wed 5.-6. October 2021. We hope the new dates fit your calendar! Technical reasons The postponement is due to what is usually called “technical reasons”, which is an expression intended to obscure any underlying facts. … Continue reading "ServerFest Two Weeks Later" The post ServerFest Two Weeks Later appeared first on MariaDB.org…. Read more

Have a burning question about MongoDB? Database experts will be leading an open forum discussion based on attendees’ interests. Are you ahead of the curve? Just trying to keep up? Get the best of MongoDB. Live Stream: October 13 at 11:30 am CT (30 min) Watch this upcoming Open Mic on Open Source to learn […]… Read more

Summary The Short Version There are many ways to watch your resources, and Prometheus is one of the more popular. Due to customer demand, Continuent has embedded the Prometheus exporter functionality into our core products (Manager, Replicator and Connector) starting with version 7.0.0, which is due out shortly. This blog post covers: Getting metrics from each component Various metrics available Using the bundled command-line tool `tmonitor` Customizing the exporter configuration How to enable the exporters Documentation & Resources Getting Metrics From Each Component It is even easier to gather metrics from the enabled Prometheus exporters – just use the curl… Read more