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.
Signup for our newsletter, for the latest news and product updates