In MySQL Cluster training course, you will learn the important details of clustering that will help to get started with MySQL Cluster. You will also learn on how to properly configure and manage the cluster nodes to ensure high availability.
By attending MySQL Cluster workshop, delegates will learn to:
- Explain the concepts of MySQL Cluster in detail
- Describe the different nodes in MySQL Cluster and their purposes
- Explain how the data is distributed and replicated in the MySQL Cluster
- Install all the different nodes used in the MySQL Cluster
- Start and stop the different nodes as needed
- Understand how the different configuration files work and be able to configure all possible types of clusters
- Put the cluster in single user mode, and understand when this is necessary
- Know how to upgrade cluster components and configuration settings
- Explain how node failure is detected and handled in the cluster
- Describe how node restart works internally
- Explain how system restart works and when this type of restart is needed
- Take backups and restore the data from backups
- Describe the internal parts of the data nodes
- Explain how the different types of data scans are performed
- Explain the difference between the different index types
- Configure the cluster for optimal performance
- Have previously worked with a MySQL Server instance and database
- Be able to install MySQL
- Have working knowledge of MySQL architecture
- Basic knowledge of database concepts and SQL