es: it will automatically split 1 table into multiple ones and save them in different nodes, and queries will be merged automatically (all the tables of 1 microservice are in thedistribute evenlyto the node)
mysql: manual table splitting is required, tables are saved in 1 node after splitting, queries need to be merged manually (all tables of 1 microservice are on the same database)
Personal idea: use mysql split table to record data, use mq queue to synchronize mysqlspreadsheetdata to es, if you know which table to check directly using mysql query, if you need to full table query directly check es