Everybody is good, now have a electricity market scene,
A, the current status:
Every single order 2-40000, single point mysql database (or through the cloud services, separation, speaking, reading and writing), single table 50 million +, when orders for more than 50000, can produce performance bottlenecks, need to upgrade the architecture
Second, future expected:
The future is expected to 200000 + per day, or more, best can linear increase
Need to be solved:
Going to do on the architecture of distributed database,
The current step:
Step 1: depots table, this understandable)
1, (according to the function of vertical depots)
2, (according to the time level segmentation)
Step 2: set up their own distributed mysql machine configuration
The technology has the following research in these days:
1, Mycat
2, mysql - proxy
3, canal + otter
Ask everybody, is relatively stable, electricity commonly used mysql cluster architecture is how to set up??????? Another small demand: partial data update, can through the log into to the ES,