Horizontal scaling of relational subds?

Question

SQL

How is it possible to organize horizontal scaling of relational subds while maintaining the possibility of table links (relations, joins)?

Answer 1

The main question is the purpose of this event? Increase the number of simultaneously processed requests? Increase a speed? Eliminate lack of space?
Provide resiliency? Each base has its own solutions to these issues.