MySQL Cluster for High Availability - Seminare

Seminarziel

At completion of this course, you will have gained insight into the clustering technology used by MySQL, MySQL partners and others. You will also have learned how to install, configure and use MySQL Cluster.

Zielgruppe

Experienced database developers who want an in-depth understanding of MySQL Cluster.

Voraussetzungen

• Basic knowledge of database concepts and SQL
• Basic proficiency in programming C++
• Previous experience with MySQL is recommended, but is not necessary

Inhalt

 

Clustered Database Technology in general

• Shared-nothing versus shared-disk database systems
• Three different types of database clustering, Physical (disk-based) clustering, Storage level clustering, Database server clustering
• Network partitioning protocols to handle split-brain situations
• Component recovery (checkpointing, logs or redundant components)
• Cluster membership handling
• Messaging services
• Introduction to replication technology
• Cluster frameworks

 

 

The concepts of MySQL Cluster

• The benefits of MySQL Cluster
• Typical usage scenarios of MySQL Cluster
• Nodes (storage nodes, management servers, applications)
• Data distribution and replication within MySQL Cluster storage engine
• The distributed transaction model
• The storage engine file system
• MySQL Cluster components (Transporters, Blocks, Signals)
• Node recovery protocol
• System recovery protocol
• System logging (REDO log, Local and Global Checkpoints, UNDO log)

Installing and configuring MySQL Cluster

• Install MySQL Cluster on a set of computers
• Compiling MySQL Cluster from the source code distribution
• Configure MySQL Cluster using the configuration files
• Configuring MySQL servers
• How to configure the topology of MySQL Cluster

Administrating and using MySQL Cluster

• Get system status and viewing the cluster log
• Start and stop storage nodes, management servers
• Using the management client
• Using several tools programs like flexBench, show_tables, select_all
• Example MySQL Cluster setup
• Executing queries on multiple MySQL servers
• Using non-clustered MyISAM and InnoDB tables in MySQL Cluster

 

High Performance features of MySQL Cluster

• Scan and lookup of data
• Parallel scanning
• Data filtering techniques
• Description of join query execution

 

High Availability features of MySQL Cluster

• Replication (configuration, administration, replication servers)
• Hot Backup and Restore (restoring meta data, restoring data)
• Node recovery
• System recovery

Literatur

nach Absprache

Verwandte Seminare

MySQL 5.0 für Datenbankadministratoren

MySQL 5.0 für Entwickler

MySQL Anwendungsentwicklung (PHP - Perl)

 

[ Zurück ]