Distribute records on different MySQL databases - MySQL Proxy alternative
You can take a look into MySQL Fabric (Official Doc) but it requires more db server 

I have tried this tool only in R&amp;D env for testing a basic HA

It supports some sharding scenarios

Here some high level pros and cons

Pros:


setup 
sharding 
write/read 
basic HA


Cons:


fabric node is the SPOF
no multi master
rewrite software in order to use the fabric driver