Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-33528

Read preference mode to allow intra-shard parallelism

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Replication, Sharding
    • None
    • Query Execution

    Description

      Let's say that I have a replica set with 3 members.

      On that replica set I have part of a sharded collection and on that replica set it has 9 data chunks. All of the current read preference modes will pick a winner from the replica set and query all 9 data chunks on that server for a particular read operation.

      It would be nice if an additional read preference mode existed that could see that it had 3 nodes and tell each node to run my read query, but constrain that query on each replica set member by a subset of the data chunks on that member.

      Run query but constrain by chunks:
      member1: chunk1, chunk2, chunk3
      member2: chunk4, chunk5, chunk6
      member3: chunk7, chunk8, chunk9

      For some read use cases this could greatly improve read round trip performance by using all replica set members concurrently.

      Attachments

        Activity

          People

            backlog-query-execution Backlog - Query Execution
            mkruse@adobe.com Matthew Kruse
            Votes:
            0 Vote for this issue
            Watchers:
            16 Start watching this issue

            Dates

              Created:
              Updated: