can we use KingShard for the MinReplication Load Balancing

[pm-kartik-sura]

Use case:
The kingshard will connect to multiple slaves, the requests will go to the node with the minimum replication lag.

Also one question: does the proxy speak Mysql protocol? That is can I connect to the proxy like any other mysql server (from C program)?

If the functionality is not there, I would like to contribute. (Please provide the documentation in English)

[flike]

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

[pm-kartik-sura]

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?

[flike]

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

[pm-kartik-sura]

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

[flike]

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

[pm-kartik-sura]

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.

[flike]

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. :)

[pm-kartik-sura]

:)