(perhaps hundreds of thousands of users, but also growing), each user may have multiple stores, the database is designed to each user to a database, or all users in a database, and then within each table distinguish which is which user store? Use SQL server to get before this model, each user has a database, a little trouble to management, especially the upgrade very troublesome, so he had to write a special upgrade database application, advantage is that a user database problems, will not affect other users, not familiar with mysql data tables, don't know in that mode is good,

CodePudding user response:

A database, there is no problem, the different shops, put in different partitions,

CodePudding user response:

Thanks, checked, table partitioning the limitation of 1024?