MySQL-Cluster

Performance and High Availability with MySQL Cluster

MySQL is used more and more often in business critical applications. If you have to process a huge amount of data in short time and High Availability is a requirement a simple Master/Slave replication is not sufficient anymore.

To close this gap, MySQL Cluster is made for unless you do it right. But this high performance tool has also its rough edges. In this course you will get an overview about the different High Availability solutions of MySQL. And you will learn, how a MySQL Cluster is set-up and operated correctly and what he does not like very much.

The whole is first covered in theory and then we exercise the most important steps together in practice.

Voraussetzungen

The participants should be used in using the Linux console and cope with the most important UNIX commands.

Further the participants should be already familiar with MySQL and the SQL language. For this please have a look at the contents of the courses MySQL and SQL.

Inhalt

Short overview over MySQL architectures

  • Replication
  • Active/passive fail-over Cluster
  • MySQL Cluster
  • 3rd Party solutions

MySQL Cluster basics

  • MySQL Cluster background
  • General cluster concepts
  • MySQL Storage Engines
  • MySQL Cluster Architecture
  • Replication and data distribution in MySQL Cluster

Installation and Configuration

  • Installation of the MySQL Clusters
  • Configuration
  • Starting the MySQL Cluster

Operating a MySQL Cluster

  • The Management Client
  • The Event Logs
  • Single User Mode
  • Typical MySQL Cluster configurations
  • Upgrade of a MySQL Clusters

Disaster Handling

  • Failure Detection
  • The Network Partitioning Protocol
  • Node Recovery
  • System Recovery
  • Partial start of a Clusters
  • Backup and Restore

MySQL Cluster Internals

  • Two Phase Commit
  • Indexing with MySQL Cluster
  • The Directory Structure

Advanced MySQL Cluster techniques

  • MySQL Cluster Tuning
  • Upgradeable Options
  • Limitations of MySQL Cluster
  • MySQL Cluster/Cluster Replication

MySQL Cluster New Features 7.2

  • Distribution of MySQL users and privileges in the Cluster
  • Distributed Push-down Joins
  • Memcache-API for MySQL Cluster

Kurszeiten

Wer möchte, reist bis 22 Uhr am Vortag an und nutzt den Abend bereits zum Fachsimpeln am Kamin oder im Park.

An den Kurstagen dann von 9-18 Uhr (mit 2 Kaffee- und 1 Mittagspause) etwa 60% Schulungen und 40% Übungen. Selbstverständlich arbeitet jeder Teilnehmer am von uns gestellten Notebook oft parallel zum Referenten mit.

Anschließend Abendessen und Angebote für Fachsimpeln, Ausflüge uvm. Wir schaffen eine Atmosphäre, in der Fachleute sich ungezwungen austauschen. Wer das nicht will, wird zu nichts gezwungen und findet auch jederzeit Ruhe.

dieser Kurs auf deutsch

Termine und Anmeldung

Es steht noch kein Termin für diesen Kurs fest.

Haben Sie einen Wunschtermin?

Verwandte Seminare ...

... aus der Kategorie Datenbanken