You are here

Operations

All operations related stuff.

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.

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

German

Was Sie erhalten

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

Remote-DBA Services

English

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

English

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

Backup

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