What are your preferred strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM or using regular replication is not an option anymore? Do you deploy ProxySQL to start splitting the traffic according to some rule to two different hosts?
Has anyone migrated to TiDB? In that case, what was the strategy to detect if the SQL your app uses is fully compatible with TiDB?
Have you actually analyzed what your real bottleneck is?
I am asking for general strategies, not for a solution to a specific case.
Well general strategies are going to depend on where the bottleneck is, so the main general strategy is simply to find the bottleneck. From there, there may be other general strategies one would use for those, but there’s so many possible starting places, it’s hard to give any specifics as they all depend on what the bottleneck actually is.
