FromDual TechFeed (de)

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.

Im ersten Webinar dieser Reihe werden wir uns mit den neuen Funktionen von Galera Cluster mit MySQL …

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

Dieser Performance Monitor ermöglicht es DBAs und Systemadministratoren einen tiefen Einblick in das Innenleben der Datenbank und des Servers, auf dem sich die Datenbank befindet, zu erhalten.

Die neue Version steht hier zum Download bereit.

Falls Sie sich die Mühe sparen wollen, eine eigene Monitoring-Infrastruktur aufzubauen, nutzen Sie doch einfach unsere kostengünstige …

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:

39004:2015-02-23 09:59:36.365 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
39004:2015-02-23 09:59:37.770 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
39089:2015-02-23 09:59:46.458 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
39089:2015-02-23 09:59:47.865 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
39181:2015-02-23 09:59:56.510 - INFO: FromDual …

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.

• Then: How much did you or your company pay for MariaDB subscription? A part of the subscription fee flows into documentation to make it better. If you have a subscription with a support provider you also can ask such questions there.

• MariaDB claims to …

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.

Requirements

You are already familiar with the SQL language and have already some experience with MySQL or any other relational SQL database system.

Audience

• Future MySQL application developer
• MySQL and MariaDB database …

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.

Requirements

You are ideally already familiar with the SQL language and know-how to use Linux or Windows systems.

Audience

• Future MySQL application developer
• MySQL and MariaDB database administrators
• System administrators with MySQL database responsibility

Contents

• Installation of MySQL
• Configuration of MySQL
• Starting and stopping of MySQL
• 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.

Requirements

You are an experienced user of Linux or Windows systems and you ideally have already learned another programming language.

Audience

• Future MySQL application developer
• Future MySQL and MariaDB database administrators
• System administrators with MySQL database responsibility
• Business analysts

Contents

• SQL, relations and relational databases
• Connecting to …

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).

If you prefer a MySQL or MariaDB in-house training at your location and if you provide the infrastructure we are happy to train you on-site either in German or English as well.

Further dates or dates …

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

SQL for Beginners (3 days)

This training is made for all who want to learn the basics of the SQL language. Future DBAs, database developers and data analysts.

MySQL and MariaDB for Beginners (2 days)

This MySQL and MariaDB training is made for those who want to learn the basics of the MySQL database system. Future MySQL DBAs and MySQL database developers.

MySQL …

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.

How can we see the original SQL statements again?

Regards,
Oli

Problem

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

binlog-ignore-db = mysql, information_schema, test

What is wrong with this filter it somehow does not work: :-(

Solution

there are different things to mention:

• The dash (-) notation is for command line options (--binlog-ignore-db) the underscore (_) is for the MySQL configuration file (binlog_ignore_db = ...). The configuration accepts both but is is not good style.
• Then because MySQL database names can contain special …

Problem

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!

Solution

I assume this is a known problem related to MySQL Row Based Replication with tables on the Slave without Primary Keys.

Please check:

• If Replication is Row Based (SHOW GLOBAL VARIABLES LIKE ‘binlog_format’; )
• If there are some tables …

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.

Get the Latest release.

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.

Get the Latest release.

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.

Get the Latest release.

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.

Get the Latest release.

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).

Get the Latest release.

Problem

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

Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem, or a bug in the …

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