The core concept

  1. Engine (type)
    • Database engine, table engine
    • Different engines determine the characteristics and location of the data store
    • Determines whether data can be indexed
    • Whether data can be modified
    • Whether the data allows concurrent operations
    • Data Backup Or Not
    • Determine the query method

    Table specification engine in CH: table characteristics, operation behavior, data characteristics

  2. shard
    • Which server does the data fall on
  3. partition
    • Specify partitions where data is stored as a unit
    • In aggregate
    • In sorting
  4. A copy of the