2 URL for BSL->GPL
source | link

I think the answer to both of your question could be MaxScale. MariaDB MaxScale is a database proxy which supports connection pooling, load balancing, automatic failover, query routing, read-write splitting and more. The query routing feature is used to achieve sharding. For a tutorial, try e.g. this one.

An alternative solution could be ProxySQL, which is a competing database proxy product with some of the same features, including sharding. TheOne advantage of ProxySQL over MaxScale is the license (GPLv3GPLv3 vs BSL), although BSL software becomes GPL after a certain amount of time. MaxScale 2.1 became GPL on 1. July 2019.

I think the answer to both of your question could be MaxScale. MariaDB MaxScale is a database proxy which supports connection pooling, load balancing, automatic failover, query routing, read-write splitting and more. The query routing feature is used to achieve sharding. For a tutorial, try e.g. this one.

An alternative solution could be ProxySQL, which is a competing database proxy product with some of the same features, including sharding. The advantage of ProxySQL over MaxScale is the license (GPLv3 vs BSL).

I think the answer to both of your question could be MaxScale. MariaDB MaxScale is a database proxy which supports connection pooling, load balancing, automatic failover, query routing, read-write splitting and more. The query routing feature is used to achieve sharding. For a tutorial, try e.g. this one.

An alternative solution could be ProxySQL, which is a competing database proxy product with some of the same features, including sharding. One advantage of ProxySQL over MaxScale is the license GPLv3 vs BSL, although BSL software becomes GPL after a certain amount of time. MaxScale 2.1 became GPL on 1. July 2019.

1
source | link

I think the answer to both of your question could be MaxScale. MariaDB MaxScale is a database proxy which supports connection pooling, load balancing, automatic failover, query routing, read-write splitting and more. The query routing feature is used to achieve sharding. For a tutorial, try e.g. this one.

An alternative solution could be ProxySQL, which is a competing database proxy product with some of the same features, including sharding. The advantage of ProxySQL over MaxScale is the license (GPLv3 vs BSL).