can we use KingShard for the MinReplication Load Balancing about kingshard HOT 8 CLOSED

yes, you can use kingshard as a mysql server. It speak Mysql protocol.

from kingshard.

Thanks a lot flike!
What about the distribution policies?
Can we do Min Replication load balancing? Also is it a statement level load balancing or connection level load balancing?

from kingshard.

You can use multi nodes(one master and multi slaves) to hold the data.
kingshard is statement level load balancing.
For example:
you can set the 'slave' item in config file like this: slave : 192.168.0.11@2,192.168.0.12@3.
kingshard will send two read sqls to 192.168.0.11, and send three read sqls to 192.168.0.12

from kingshard.

Can we add a functionality where the slave is selected which has the min replication lag? I can contribute too.

from kingshard.

yeah, welcome to contribute kingshard. But I think this function will make the load balancing disabled.

from kingshard.

Yes you are correct. But its a real life usecase in production. We could have a policy that says:
Select the nodes with min replication lag. If there are multiple nodes, then load balance evenly/load factor.

from kingshard.

en, I understand what you say. maybe this is another load banlancing policy of kingshard. You can contribute it in you branch, if many other users consider this function is very useful, I will merge it in the master branch. :)

from kingshard.

:)

from kingshard.