Comments - SHARE PERFORMANCE ACROSS 2 SERVERS
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The only ways to share data between two servers are: - Using MySQL cluster - Using the federated storage engine
However, in both cases things will get slower when you do joins across data that is in two machines.
The ways to solve your problem depends on what storage engine you are using, the size of the buffers and how big your table_open_cache and table_definition_cache is.
With some storage engines, like MyISAM, you can put different tables in different key caches which ensures that using one big table doesn't flush out the others.