DB Shards support
@rosa is already working on this.
Since Sep 17, 2024.
Assessment
This issue has not been assessed yet.
Description
Hi,
In https://github.com/rails/solid_queue/pull/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
- Dominant language
- Ruby
- Stars
- 2.5k
- Forks
- 250
- Avg merge
- 8h 31m
- Merged PRs (30d)
- 5
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from rails/solid_queue
-
Difficulty 3/5 1-2 days Newbie friendliness 52/100
rails/solid_queue#804 · 1 comment ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
rails/solid_queue#802 ·
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
rails/solid_queue#797 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
rails/solid_queue#792 · 1 reaction ·
-
Difficulty 4/5 3-5 days Newbie friendliness 52/100
rails/solid_queue#780 ·
All issues in rails/solid_queue
Similar issues
-
user-reported
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
Kong/developer.konghq.com#7316 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
TheOdinProject/curriculum#31408 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
notch8/utk_knapsack#148 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 78/100
Homebrew/homebrew-cask#288729 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100