What are your strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM is not an option anymore? Do you deploy ProxySQL to start splitting the traffic according to some rule to two different hosts? What would the rule be, and how would you split the data? 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?

Has anyone successfully deployed WordPress with TiDB in a production environment? Are there known compatibility issues (e.g., unsupported SQL syntax like SQL_CALC_FOUND_ROWS) that should be accounted for? There is no mention of TiDB at https://wordpress.org/about/stats/#mysql_versions nor at https://wordpress.org/about/requirements/ , and various websites/blogs seem like one-off tests.