Shinguz's blog

In MariaDB master/slave replication there is a feature called attribute promotion/demotion.

FromDual has the pleasure to announce the release of the new version 2.3.2 of its popular Backup and Recovery Manager for MariaDB and MySQL (brman).

In our MariaDB advanced training courses, which we hold approximately every two months, we use machines that are directly exposed to the Internet with a public IP address. Warning: You should NEVER expose a database directly to the Internet without protection! Typically, it takes less than 72 hours (3 days) before we are exposed to the first external access attempts.

Since 10.11 it would be good to use –dump-history if MariaDB System-Versioned Tables are used!

Recently I had the opportunity to have a lot of Linux systems (VMs with Rocky Linux 9) from one of our regular Galera Cluster trainings all to myself for a week. And MariaDB 11.4.4 with Galera Cluster was already installed on the machines.

We have improved our model (see v2) so the results are a bit better/more accurate now.

Artificial intelligence (AI) and vector databases are on everyone’s lips these days. Since MariaDB will soon be coming onto the market with vector database functionality, as a database consultant I thought it was about time I got to grips with the subject so that I have at least a hint of what it’s all about…

FromDual has the pleasure to announce the release of the new version 2.3.1 of its popular Backup and Recovery Manager for MariaDB and MySQL (brman).

What is it about?

When describing backup and restore scenarios, a full backup and a full restore of the database instance (mariadbd/mysqld) are usually assumed. This means that the entire database instance, including all databases (schemas), is backed up and restored.

FromDual has the pleasure to announce the release of the new version 2.3.0 of its popular Backup and Recovery Manager for MariaDB and MySQL (brman).

One feature that really excited me in the new MariaDB 11.4 LTS release is the shrinking of the system tablespace (ibdata1). I have been eagerly waiting for this feature since around 2006 and now it has finally arrived with MariaDB 11.4. Actually, this feature has been available since MariaDB 11.2 IR (June 2023).

https://jira.mariadb.org/browse/MDEV-34412

Hi dcz01

No it is not solved… It is closed and “not a bug”… I try to intervene

Hello dcz01

I would say, this is probably a bug. I can reproduce it on my system (MySQL 5.7 Master and MariaDB 10.6 Galera Cluster).

On this page we have summarised information about downgrading a MariaDB/MySQL database. We do not cover migrating from MySQL to MariaDB or vice versa. For migrations (sidegrade) please look here: MySQL - MariaDB migration and here: Migration between MySQL/Percona Server and MariaDB.

FromDual is pleased to announce the release of the new version 1.2.2 of the popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases.

• Ops Center 1.2.2 Release Notes: FromDual Ops Center 1.2.2 for MariaDB, MySQL and compatible databases has been released (2024-04-25)
• Ops Center 1.2.1 Release Notes: FromDual Ops Center 1.2.1 for MariaDB, MySQL and compatible databases has been released (2023-02-07)
• Ops Center 1.2.0 Release Notes: FromDual Ops Center 1.2.0 for MariaDB, MySQL and compatible databases has been released (2023-01-17)
• Ops Center 1.1.0 Release Notes: FromDual Ops Center for MariaDB, MySQL and compatible databases 1.1.0 has been released (2021-05-07)
• Ops Center 1.0.0 Release Notes: FromDual Ops Center for MySQL and compatible databases 1.0.0 has been released (2020-05-07)
• Ops Center 0.9.3 Release Notes: FromDual Ops Center for MariaDB and MySQL 0.9.3 has been released (2020-02-18)
• Ops Center 0.9.2 Release Notes: FromDual Ops Center for MariaDB and MySQL 0.9.2 has been released (2019-08-13)
• Ops Center 0.9.1 Release Notes: FromDual Ops Center for MariaDB and MySQL 0.9.1 has been released (2019-05-07)
• Ops Center 0.9.0 Release Notes: FromDual Ops Center for MariaDB and MySQL 0.9 has been released (2019-04-16)
• Ops Center 0.3.0 Release Notes: FromDual Ops Center for MySQL and MariaDB 0.3 has been released (2016-01-13)
• Ops Center 0.2.0 Release Notes: FromDual Ops Center for MySQL and MariaDB 0.2.0 has been released (2014-05-29)
• Ops Center 0.1.0 Release Notes: FromDual Ops Center for MySQL and MariaDB 0.1.0 has been released (2014-01-02)
• Ops Center 0.0.1 Release Notes: FromDual Ops Center for MySQL and MariaDB 0.0.1 has been released (2014-01-01)

Table of contents

• Review
• One month later
• Size of the tables
• Process list
• Global variables
• Metadata Lock and InnoDB Transaction Lock
• Global status

Review

After we introduced dbstat for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food).

Due to an application error, our replication stopped for 5 days (over Easter). After the problem was solved, the replication was supposed to catch up, which turned out to be very slow. All the usual tricks (innodb_flush_log_at_trx_commit, sync_binlog, etc.) had already been exhausted. So we tried our hand at parallel replication of the MariaDB server.

Recently I had to test a new MariaDB feature that was developed at our request (MDEV-33782). To test this feature I had to build the MariaDB server myself from source, which I have not done for a long time. So a new challenge, especially with CMake…