Hi,

In #56 it seems built in support for database sharding was added to solid_queue.

In my team we were unsuccessful in testing this feature. Maybe we are not setting things up correctly. What we did we set up in the config config.solid_queue.connects_to to point to two shards as in:

config.solid_queue.connects_to = {
    shards: {
      shard_one: { writing: :db5, reading: :db5_readers },
      shard_two: { writing: :db5_shard, reading: :db5_shard_readers }
    }
  }

We tried the configuration above, but the workers and the dispatchers only connected to the first shard. We managed to get the adapter enqueue in both shards with some tweaking, but it did not support it out of the box.

If the sharding is supported out of the box, would you be so kind to point us to a example of DB sharding working out of the box (configuration for adapter, dispatcher and worker)? Or, if the sharding is not fully supported yet, is there any plan to enhance solid queue with full sharding support ?

Many thanks!

Regards,
Andrei