In the previous chapter, replication in MySQL 8 was explained. This included detailed explanations of replication, configuration, and implementation. The chapter also explained group replication versus clustering, and covered the replication approach as a solution.
In this chapter, we will do partitioning in MySQL 8. Partitioning is the concept of managing and maintaining data with specific operations with several operators, and defining rules to control over partitioning. Basically, it provides a configuration hook for managing the underlying data files in a specified way.
We will cover the following topics on partitioning:
- Overview of partitioning
- Types of partitioning
- Partition management
- Partition selection
- Partition pruning
- Restriction and limitation in partitioning
