[Spock Proxy Devel] Feature Requests

[Graham F. <gr...@si...>]

First of all, thanks for the development that has gone into this, as it looks to be just what I was looking for. I have a couple of suggestions which I think would be useful additions

1. I want to create shards based on a character database key. E.g. All users from 'a' to 'b' are stored in shard1. The current implementation only allows the sharding key to be an integer value. I can easily 'hack' this in by mapping the first character of the key to an integer value, but it would be nicer to have this properly supported. Are there any plans to do this?

2. I am looking to use SpockProxy in conjunction with the MySQL Master Master Replication Monitor, where all the Shards are Master/Master Active/Passive MySQL servers (MMM). MMM can define a writerRole, to write to the currently active MySQL server, and two readerRoles to allow reads to be done on both MySQL servers. SpockProxy supports this out of the box if you configure the host_name to be the MMM writerRole. However, this means that the Passive MySQL server sits fairly idle, which is a waste of resources in my mind. Therefore, a useful extention, I think, to SpockProxy would be to allow the readerRoles to be configured, and have SpockProxy round robin any "read" requests between the Active and Passive MySQL servers to balance the load a little when both servers are active.

I am willing to help with any implementation/testing of these features, but would want to make sure that the design of these features would be acceptable before I proceed.

Graham