MySQL Cluster

The MySQL Cluster - High Availability Solution course will teach the experienced MySQL database administration system how to properly create and configure MySQL Cluster to ensure high availability and maximum performance. Participants will learn to use and add individual nodes to the cluster and at the same time better understand the internal functioning and price of the entire cluster on the MySQL platform

Level

advanced

Course length

3 days

Language

Course code

KT21010283

Order

Category:

Database MySQL

Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term

Language

Place

Form

Price without VAT

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010283-0004

Price without VAT

20 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010283-0005

Price without VAT

20 000 Kč

Order

Required knowledge

Knowledge and experience with the administration of the MySQL database system.

Course content

Introduction to MySQL cluster architecture - what is a cluster, architecture, nodes, Node Groups
Cluster installation and creation - initialization, start of management node, connection of other nodes, cluster restart, HA test
Cluster configuration - cluster configuration, node management, data nodes, SQL nodes
NDB Storage Engine - data storage, indexes, transaction options
Cluster design and planning - system requirements and balance
Working with data in a cluster - Cluster Disk Data, importing data into a cluster, deleting tables
MySQL cluster management options - Clusters Management Console, backup, recovery, troubleshooting
Security - security architecture
Cluster performance - query execution, data size / space used, configuration
Cluster replication - replication, single channel, redundant channel, cluster replication for backup
Troubleshooting

Materials

Materials are in electronic form.

Do you want this tailor-made course for your company?

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news