Expansion Overview

For distributed databases with massive storage requirements, table data volumes inevitably grow over time. This growth often leads to insufficient cluster capacity and computing power (CPU). In such cases, efficient and reliable cluster expansion becomes essential. While it is ideal to plan for future growth during initial system design, it is usually impractical to over-invest in resources too early. Therefore, we recommend that you regularly plan and perform database expansion operations.

In YMatrix, you can choose between GUI-based expansion or command-line online expansion. We recommend using the GUI for its simplicity and ease of use. Currently, YMatrix supports online smooth expansion (read and write operations are unaffected during expansion) and flexible configuration of table data distribution.

FAQ

  1. Are the catalogs consistent between old and new nodes during expansion?

    • Yes, the catalogs are always consistent. Even if no data has been loaded yet, the catalog exists on each new node.
  2. What is the impact on other queries during expansion?

    • Since expansion is performed online, all running queries continue uninterrupted. However, when adding new nodes, the catalog must be locked temporarily. During this period, DDL operations are not supported. The catalog lock is released immediately after the new nodes are added.
    • During data redistribution, the highest-level lock is held, which blocks read operations.