🗓️ 09042024 0948
Partitioning Strategies
IMPORTANT
Affects ordering / rate at which messages are consumed
Single Topic, Single Partition
- 😀 Guarantees ordering
 - 🙁 Not good write performance
 
Multiple topics, each single partition
- 😀 Guarantees ordering
 - 🙁Not recommended for hot (tables with high write frequency) tables
 
Single / multiple topics, each multiple partitions (PK key)
- Partition based on a specified key
 
canal.mq.partitionHash=mytest.person:id,mytest.role:id
- 😀 Ordering within each partition guaranteed
 - 😀 Good write performance
 - 🙁 Carefully consider how to use PKEY ()