Potential: Update BuildQueueWorker to utilize new Sidekiq readonly database replicas
With the ability to Allow Sidekiq jobs to use readonly database replicas in place, the next step will be to enable this capability for this worker.
Proposal
Use data_consistency :sticky
because it's the best trade-off. A data consistency delayed
could cause the job to be rescheduled if the replica hasn't caught up, but the worker is set to run with urgency :high
so we want to avoid that. A sticky
mode still allows us to use replica as much as possible.
Edited by Fabio Pitino