Read preference for replica sets in MongoDB

Introduction

Read preference tells MongoDB where to get data from in a group of servers. It helps balance speed and data freshness.

When you want to read data from the main server only to get the latest updates.

When you want to read data from backup servers to reduce load on the main server.

When you want to read from the nearest server to get faster responses.

When you want to allow reading from any available server to maximize availability.

When you want to control how fresh the data should be when reading from backups.

Syntax

MongoDB

db.collection.find().readPref('mode')

// or when connecting:
MongoClient(uri, { readPreference: 'mode' })

'mode' can be primary, secondary, primaryPreferred, secondaryPreferred, or nearest.

Read preference can be set per query or for the whole connection.

Examples

Reads only from the primary server to get the most up-to-date data.

MongoDB

db.orders.find().readPref('primary')

Reads only from secondary servers to reduce load on the primary.

MongoDB

db.orders.find().readPref('secondary')

Reads from the closest server, primary or secondary, for faster response.

MongoDB

db.orders.find().readPref('nearest')

Sample Program

This example shows how to read from primary and secondary servers in a replica set.

MongoDB

use shop

// Read from primary
printjson(db.products.find().readPref('primary').limit(2).toArray())

// Read from secondary
printjson(db.products.find().readPref('secondary').limit(2).toArray())

Important Notes

Reading from secondaries may return slightly older data because of replication delay.

Use 'primaryPreferred' or 'secondaryPreferred' to allow fallback if preferred servers are unavailable.

Setting read preference helps distribute read load and improve performance.

Summary

Read preference controls which replica set member to read from.

It helps balance between data freshness and read performance.

You can set it per query or for the whole connection.

Practice

1. What does the readPreference setting control in a MongoDB replica set?

easy

A. The size of the replica set

B. Which member to write data to

C. How often data is backed up

D. Which replica set member to read data from

Solution

1. Step 1: Understand the role of readPreference

   The readPreference setting tells MongoDB which replica set member to use for read operations.

2. Step 2: Differentiate read and write roles

   Writes always go to the primary, but reads can be directed to primary or secondary members based on readPreference.

3. Final Answer:

   Which replica set member to read data from -> Option D

4. Quick Check:

   Read preference = controls read source [OK]

Hint: Read preference decides read source, not write or backup [OK]

Common Mistakes:

• Confusing readPreference with write concern
• Thinking it controls backups
• Assuming it changes replica set size

2. Which of the following is the correct syntax to set read preference to secondaryPreferred in a MongoDB connection string?

easy

A. mongodb://host1,host2/?readPreference=secondaryPreferred

B. mongodb://host1,host2/?readPreference=primaryOnly

C. mongodb://host1,host2/?readPref=secondaryPreferred

D. mongodb://host1,host2/?readPreference=secondaryOnly

Solution

1. Step 1: Identify correct parameter name

   The correct parameter to set read preference in the connection string is readPreference.

2. Step 2: Match correct value

   secondaryPreferred is a valid read preference mode; others like primaryOnly or secondaryOnly are invalid or incorrect.

3. Final Answer:

   mongodb://host1,host2/?readPreference=secondaryPreferred -> Option A

4. Quick Check:

   Use readPreference with valid mode [OK]

Hint: Use exact parameter name 'readPreference' and valid mode [OK]

Common Mistakes:

• Using 'readPref' instead of 'readPreference'
• Using invalid modes like 'primaryOnly'
• Misspelling 'secondaryPreferred'

3. Given the following MongoDB query with read preference set to secondary:

db.collection.find({ status: "active" }).readPref("secondary")

What will happen if all secondary members are down?

medium

A. The query will read from the primary member

B. The query will fail with an error

C. The query will wait until a secondary is available

D. The query will return empty results

Solution

1. Step 1: Understand 'secondary' read preference behavior

   When read preference is set to secondary, reads must come from secondary members only.

2. Step 2: Consider all secondaries down scenario

   If no secondary is available, the query cannot read from primary or fallback; it results in an error.

3. Final Answer:

   The query will fail with an error -> Option B

4. Quick Check:

   Strict 'secondary' fails if no secondary [OK]

Hint: Strict 'secondary' read fails if no secondary available [OK]

Common Mistakes:

• Assuming fallback to primary happens automatically
• Thinking query waits indefinitely
• Expecting empty results instead of error

4. You wrote this code to read from a secondary member:

db.collection.find().readPref('secondaryPreferred')

But it still reads from the primary. What is the likely cause?

medium

A. The query must specify a filter to use read preference

B. The syntax for setting read preference is incorrect

C. No secondary members are available, so it falls back to primary

D. Read preference only works for writes

Solution

1. Step 1: Understand 'secondaryPreferred' behavior

   This mode reads from secondary if available; otherwise, it falls back to primary.

2. Step 2: Reason why primary is used

   If no secondary is available or reachable, the driver reads from primary as fallback.

3. Final Answer:

   No secondary members are available, so it falls back to primary -> Option C

4. Quick Check:

   'secondaryPreferred' falls back to primary if no secondary [OK]

Hint: 'secondaryPreferred' falls back to primary if no secondary [OK]

Common Mistakes:

• Thinking syntax is wrong when it is correct
• Believing read preference needs a filter
• Confusing read preference with write behavior

5. You want to optimize read performance by reading from secondaries but ensure data is fresh enough. Which read preference mode should you choose?

hard

A. secondaryPreferred

B. nearest

C. primary

D. secondary

Solution

1. Step 1: Understand read preference modes

   primary reads only from primary (fresh but may be slower), secondary reads only from secondaries (may be stale), secondaryPreferred reads secondaries or falls back to primary, nearest reads from the closest member regardless of type.

2. Step 2: Balance freshness and performance

   secondaryPreferred prefers secondaries for read performance optimization but falls back to the primary to ensure data freshness and availability.

3. Final Answer:

   secondaryPreferred -> Option A

4. Quick Check:

   secondaryPreferred prefers secondary perf + primary freshness fallback [OK]

Hint: 'secondaryPreferred' for secondary perf with primary fallback [OK]

Common Mistakes:

• Choosing 'secondary' which may return stale data
• Choosing 'primary' which may be slower
• Confusing 'secondaryPreferred' with 'nearest'