Author Archives: Shinguz

Max_used_connections per user/account

How many connections can be opened concurrently against my MySQL or MariaDB database can be configured and checked with the following command: SHOW GLOBAL VARIABLES LIKE ‚max_connections‘; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | max_connections | 505 | +—————–+——-+ … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

FromDual Backup Manager for MySQL 1.2.2 has been released

FromDual has the pleasure to announce the release of the new version 1.2.2 of the popular Backup Manager for MySQL and MariaDB (fromdual_bman). You can download the FromDual Backup Manager from here. In the inconceivable case that you find a … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Wir suchen Dich: MySQL/MariaDB DBA für FromDual Support

Wer sind wir? FromDual ist das führende unabhängige Beratungs- und Dienstleistungsunternehmen für MySQL, Galera Cluster, MariaDB und Percona Server in Europa mit Hauptsitz in der Schweiz. Unsere Kunden stammen hauptsächlich aus Europa und reichen vom kleinen Start-Up bis zur europäischen … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Controlling worldwide manufacturing plants with MySQL

A MySQL customer of FromDual has different manufacturing plants spread across the globe. They are operated by local companies. FromDuals customer wants to maintain the manufacturing receipts centralized in a MySQL database in the Head Quarter in Europe. Each manufacturing … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Logging Galera Cluster conflicts

We typically suggest our customers to use our MySQL/Galera Cluster my.cnf configuration template to avoid MySQL configuration and performance problems. And we are paranoid as well. Thus we enable all useful logging: wsrep_log_conflicts = 1 But this has also some … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Galera Cluster last inactive check and VMware snapshots

From time to time we see at Galera Cluster customer engagements the following, for me scary, warning in the MySQL error log: [Warning] WSREP: last inactive check more than PT1.5S ago (PT7.06159S), skipping check We mostly see this in VMware … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Rename MySQL Partition

Before I forget it and have to search again here a short note about how to rename a MySQL Partition: My dream: ALTER TABLE history RENAME PARTITION p2015_kw10 INTO p2015_kw09; In reality: ALTER TABLE history REORGANIZE PARTITION p2015_kw10 INTO ( … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

MySQL Enterprise Incremental Backup simplified

MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it… Unfortunately the original MySQL documentation is much too complicated for my simple … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Creating Event Handlers with MySQL Enterprise Monitor

MySQL Enterprise Monitor (MEM) has by default no Event Handlers created and activated. These Event Handlers you have to define yourself according to your needs. In this article we discuss how to create MySQL Enterprise Monitor Event Handlers with MEM … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment

Nagios and Icinga plug-ins for MySQL 1.0.0 have been released

FromDual has the pleasure to announce the release of the new version 1.0.0 of its widely used Nagios and Icinga plug-ins for MySQL, Galera Cluster, MariaDB and Percona Server. All plug-ins are basically renewed and should now work all correctly. … Continue reading

Posted in Aktualisierung, Datenbanken, mySQL, SQL | Leave a comment