Show all
Log in
0
Basket
0,00 €
Log in
0
Basket
0,00 €
Pumpedu Database MySQL MySQL Cluster

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
Designed for participants with advanced knowledge and experience
advanced
Course length
3 days
Language
cz eu
Course code
KT21010283
MySQL
Category:
Database MySQL
Do you want this tailor-made course to your company? Contact us

Courses on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
15. - 17. 7. 2024
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: KT21010283-0019
Price without VAT
20 000 Kč
Order
26. - 28. 8. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010283-0022
Price without VAT
20 000 Kč
Order
11. - 13. 12. 2024
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: KT21010283-0020
Price without VAT
20 000 Kč
Order
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010283-0004
Price without VAT
20 000 Kč
Order
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
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.

Lecturers

David Solnař
David Solnař

Freelance Consultant and Trainer Oracle, SQL Server, MySQL, .NET, WPF, ASP.NET

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

Contact us

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

Contact us

Why with us

Online training, classroom courses, e-Learning, webinars, etc.
We create custom courses that you won't buy anywhere else
Experienced team of experts
Course and staff management tool