1. Understanding of the three (geometry)
- Mysql: equivalent to a rectangle
- MongoDB: equivalent to a wire ball
- Elasticsearch: Is equivalent to a sphere
2. The design of the three
- Mysql: X-axis is constant, Y-axis is infinite. It’s like spreading out all the data.
- MongoDB: equivalent to a line from 0 to Z. Points on the line are placed in a tree of data, each of which is also arranged in a linear fashion.
- Elasticsearch: The cluster is used as the center of the sphere, which pulls multiple child nodes. Each child node can pull multiple child nodes. Each node is distributed in a sphere, but all revolve around the cluster.
Elasticsearch > Mysql > MongoDB
- Mysql: depends on the length of the Y-axis
- MongoDB: Depends on the total length of the line
- Elasticsearch: Depends on the radius of the sphere