oli's blog

Sie haben sicher schon davon gehört, dass MySQL 5.7 im Oktober 2023 das End of Life (EOL) erreicht hat. In diesem Webinar zeigen wir Ihnen, dass die Migration von MySQL 5.7 Galera Cluster nicht schwierig ist. MySQL 8.0 ist seit 5 Jahren allgemein verfügbar, und das Galera Cluster für MySQL 8.0 hat sich seit über 3 Jahren im Markt bewährt. Es ist also wirklich an der Zeit, sich auf die Migration vorzubereiten.

FromDual hat die Version 1.1.0 des Performance Monitors für MariaDB, MySQL und Galera Cluster (fpmmm) freigegeben.

Yesterday we did a first real life test of the formulas and the predictions of all 3 methods where quite congruent… So I personally trust them!

MySQL Performance Monitor agent gets a TERM signal from time to time:

Hello DBStarter

First of all a few things:

• About MariaDB documentation: I would say the MariaDB documentation is not too bad compared to other open source project documentation or even enterprise software documentation. But its far from being brilliant.

You are already a database application developer or on the way there. Now you would like to learn more about, what MySQL and MariaDB features are available which you can use later to build even better applications, to develop more efficiently applications and shorten your time to market.

You are new in the field of relational SQL databases and have the task to get familiar with MySQL oder MariaDB. This training teaches you the basics of MySQL.

You are new in the field of relational SQL databases and have the task to learn the SQL language. This training teaches you the SQL basics.

We offer our MySQL and MariaDB trainings together with well-respected training organizations: The Linuxhotel in Essen (Germany), the Heinlein Academy in Berlin (Germany) and GFU Cyrus AG in Cologne (Germany). Our own MySQL and MariaDB training classes are hold in the building of the HSO in Zürich (Switzerland).

FromDual offers different MySQL, Galera Cluster and MariaDB training modules. For training dates see our MySQL and MariaDB training class schedule.

Hello all

We use the following binary log filter for filtering out some schemata.

Hello all

we use MySQL binary logging with binlog_format = row. With mysqlbinlog -v binary-log.000001 we can see proximately how the original query looked like. But this is a transformation from row events into pseudo SQL statements.

Hello Forum My MySQL Replication Slave is lagging more and more and I have no clue why. This happens since last weekends application change. I see that one Core is running at 100% user time but the I/O system is nearly completely idle. Any help is appreciated! Regards, Oli

MyEnv (MySQL/MariaDB BasEnv)

The MyEnv (MySQL/MariaDB BasEnv) is a solution to operate easily MySQL multi-instance set-ups or MySQL installations installed with binary tar-balls. No more problems with packages, easy upgrade, you have everything under control.

Nagios/Icinga plugins for MySQL and MariaDB

Nagios and Icinga compatible plugins to monitor MySQL, Galera Cluster, MariaDB and Percona Server. If you use Nagios or Icinga these are the MySQL monitoring plugins you must have.

FromDual Ops Center for MariaDB and MySQL (focmm)

The FromDual Ops Center for MariaDB, MySQL and Galera Cluster helps you to operate your complex MariaDB/MySQL database set-ups with and easy to use Graphical User Interface (Web-GUI). Master/Slave- and Master/Master-Replication, Galera Cluster and VIP failover, etc. is possible.

FromDual Performance Monitor for MySQL and MariaDB including MaaS

The FromDual Performance Monitor for MySQL, Galera Cluster, MariaDB and Percona Server is a Monitoring solution based on Zabbix. Its various alerts, advisors and graphs help you to monitor and operate your MySQL databases. This solution is also available as Monitoring as a Service solution if you want to avoid the hassle of installing your own monitoring solution.

FromDual Backup and Recovery Manager (brman) for MariaDB and MySQL

The FromDual Backup and Recovery Manager (brman) for MariaDB and MySQL is an easy to use software to do Backup, Restore and Point-in-Time-Recovery for MySQL, Galera Cluster, MariaDB and Percona Server. It integrates the utilities mysqldump, mysql, mariabackup, xtrabackup and mysqlbackup (MySQL Enterprise Backup).

Hello all,

MySQL Replication Slave stuck because its disk run full. After restarting the Slave MySQL replication was broken with the following error:

You find many different possibilities how to do a MariaDB/MySQL backup with mariadb-dump/mysqldump. But which one is the correct one?