What indeed. Having that many tables in a database is just asking for trouble. My gut feeling for a database of this size is to suggest sharding. While I don

What indeed. Having that many tables in a database is just asking for trouble. My gut feeling for a database of this size is to suggest sharding. While I don't claim to be an expert in this sort of thing, here's how Pintrest approached a similar problem: https://engineering.pinterest.com/blog/sharding-pinterest-how-we-scaled-our-mysql-fleet/ https://engineering.pinterest.com/blog/sharding-pinterest-ho...