You are here

Operations

All operations related stuff.

Remote-DBA Dienstleistungen für MariaDB und MySQL

Unsere remote-DBA Dienstleistungen sind so flexibel, wie unsere Kunden unterschiedlich sind. Wir übernehmen Ihre Aufträge, sofern diese etwas mit MariaDB, MySQL oder Galera Cluster zu tun haben. Auch im datenbanknahen Umfeld (Linux, Load Balancer, Hochverfügbarkeit) können wir Sie unterstützen. Sie erwerben 10-Stunden Dienstleistungs-Pakete und setzten diese nach Bedarf während eines Jahres ein.

Wie unsere Kunden ihre remote-DBA Dienstleistung nutzen

Unsere Kunden nutzen ihre remote-DBA Dienstleistungspakete auf vielfältige Art und Weise:

German

Remote-DBA Services for MariaDB and MySQL

Our remote-DBA services are as flexible as our customers are different. We care about your mandates if they are related to MariaDB, MySQL or Galera Cluster. We also can support you in the database surroundings (Linux, Load Balancer, High-Availability). You purchase a 10 hour Service package and you can use it on demand during one year.

How our customers use their FromDual remote-DBA services

Our customers use their FromDual remote-DBA services in many different ways:

English

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:

English

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.

Pages

Subscribe to RSS - Operations