Split database per pool
If somebody looking something for solve the similare issue look for by the side of  

MySQL NTILE()  


You can split database on equal part based on a column value.
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html#function_ntile