You are here


All operations related stuff.

FromDual Ops Center for MySQL and MariaDB 0.3 has been released

FromDual has the pleasure to announce the release of the new version 0.3 of the FromDual Ops Center for MySQL and MariaDB.

The FromDual Ops Center for MySQL and MariaDB (focmm) is an application for DBA's and system administrators to manage MySQL and MariaDB database farms.

The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks.

Download FromDual Ops Center for MySQL and MariaDB (focmm)


FromDual Ops Center for MySQL and MariaDB (focmm)

The FromDual Ops Center for MySQL, Galera Cluster, MariaDB and Percona Server helps you to operate your complex MySQL database set-ups with and easy to use Web-GUI. Master/Slave, Master/Master, VIP fail-over, etc. is possible.

FromDual: Tools for MySQL and Galera - Backup - Monitoring - Operations

Taxonomy upgrade extras: 

FromDual tools provide valuable additional functionality which facilitate and optimize daily operations of your MySQL databases. Since our last newsletter a lot of things have changed in the FromDual tools.

FromDual: Werkzeuge für MySQL und Galera - Backup - Überwachung - Betrieb

FromDual Tools bieten wertvolle ergänzende Funktionen, die den täglichen Betrieb von MySQL Datenbanken erleichtern und optimieren. Seit unserem letzten Newsletter hat sich einiges getan bei den FromDual Tools.

FromDual Ops Center for MySQL and MariaDB (focmm)


The FromDual Ops Center for MySQL/MariaDB is a browser-based solution to operate your MySQL or MariaDB database server.

Important: For FromDual Ops Center for MySQL and MariaDB 0.3 an newer please look here.

Schulungstermine für MySQL Kurse 2013 in Deutschland

FromDual bietet auch im Jahr 2013 wieder intensive MySQL Schulungen für fortgeschrittene MySQL Anwender an.

Folgende deutschsprachigen Kurse sind geplant:

FromDual Remote-DBA Dienstleistungen


Was Sie erhalten

Mit unserer Remote-DBA Dienstleistung werden ihre regulären DBA-Arbeiten erledigt.

Remote-DBA Services for MySQL and MariaDB


What you get

With our remote-DBA Service you get your regular DBA work done.

What's going on when MySQL does operations on Partitions


Following question came up recently: What happens if you drop or add a partition of an existing already partitioned table with ALTER TABLE? Will it be copied or will just the single partition be dropped and added? How are the index(es) rebuild after such a drop/add?

In the MySQL documentation were not to many details mentioned:

Typical automated MySQL maintenance jobs, query cache

The following maintenance jobs are typically run against a MySQL database:

  • Backup
  • Clean-up binary logs
  • Optimize tables
  • Purge query cache
  • Rotate binary logs


A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.

Subscribe to RSS - Operations