What is the best way to implement databases on different servers?

Question

Database

It is necessary to separate the databases for storage on different servers, by the number from 2 to 20 servers.
I would like to know what dances with a tambourine are coming, what to look at first and how best to implement it?

Answer 1

You didn't give a reason. If the server does not cope with one thing, if the volumes are something else. In general, look at partitioning, all modern engines have it. In addition, look in the direction of replication, this will allow you to offload the server for requests with a balancer either built into the database or at the code level. In general, write in Russian where the problem is with all the details