Read Replication but not round robin.

Open
#1,232 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
25/100
Issue type
Feature
Clarity
Needs clarification
Activity status
Stale
Tech stack
javascript
Domain
databases

Research direction

The issue does not name any files, tests, or entry points. First inspect the CLI's read-replication configuration and query-routing behavior, then determine whether selective routing by query or replica timeout can be specified; done means the supported behavior is documented and covered by tests.

Written by the indexing model from the issue text.

Description

So the read replica we use have a time out of 2 seconds, and for one of the search queries where we send like = %xyz% the indexes of the table doesn't work and the query gives a timeout.

I need to direct these request to a different replica which have a larger time-out time.

As even if we have what current support we have of putting more replicas in the the file, requests will be served in a round robin fashion, and we won't be able to send these specific requests to that replica.

If a feature like this exist, please help.
Thankyou.

Dominant language
JavaScript
Stars
2.6k
Forks
524
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from sequelize/cli

All issues in sequelize/cli

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.