MSET and MGET for bulk operations in Redis - Mini Project: Build & Apply

Using MSET and MGET for Bulk Operations in Redis

📖 Scenario: You are managing a small online store's Redis database. You want to store and retrieve multiple product prices quickly using Redis commands.

🎯 Goal: Learn how to use MSET to set multiple keys and values at once, and MGET to retrieve multiple values in one command.

📋 What You'll Learn

Create multiple key-value pairs for product prices using MSET

Set a variable with the list of product keys

Retrieve the prices of multiple products using MGET

Complete the Redis commands to perform bulk set and get operations

💡 Why This Matters

🌍 Real World

Bulk setting and getting of data is common in caching, session storage, and real-time analytics where performance matters.

💼 Career

Knowing how to use MSET and MGET efficiently helps backend developers and database administrators optimize Redis usage in production systems.

1

Create multiple product price entries using MSET

Write a Redis MSET command to set the following product prices exactly: "product:apple" to 1.20, "product:banana" to 0.50, and "product:orange" to 0.80.

Redis

# Use MSET to set prices for product:apple, product:banana, and product:orange
# Your code here

Hint

Use the MSET command followed by key-value pairs separated by spaces.

2

Create a list of product keys to retrieve

Create a Redis variable called product_keys that holds the list of keys: "product:apple", "product:banana", and "product:orange".

Redis

MSET product:apple 1.20 product:banana 0.50 product:orange 0.80
# Create a variable product_keys with the list of product keys
# Your code here

Hint

Use a list syntax to store the keys in product_keys.

3

Retrieve multiple product prices using MGET

Write a Redis MGET command to get the prices of the products stored in the product_keys list.

Redis

MSET product:apple 1.20 product:banana 0.50 product:orange 0.80
product_keys = ["product:apple", "product:banana", "product:orange"]
# Use MGET with product_keys to get all prices
# Your code here

Hint

Use MGET followed by the keys separated by spaces to get multiple values.

4

Complete the bulk operation with a Redis pipeline

Write a Redis pipeline command that uses MSET to set the product prices and then MGET to retrieve them in one batch operation.

Redis

MSET product:apple 1.20 product:banana 0.50 product:orange 0.80
product_keys = ["product:apple", "product:banana", "product:orange"]
MGET product:apple product:banana product:orange
# Use a Redis pipeline to run MSET and MGET together
# Your code here

Hint

Create a pipeline object, add mset and mget commands, then execute the pipeline.

Practice

1.

What does the Redis command MSET do?

easy

A. Increments multiple numeric keys

B. Stores multiple key-value pairs in one command

C. Deletes multiple keys at once

D. Retrieves multiple values for given keys

Solution

1. Step 1: Understand MSET purpose

   The MSET command is used to save many keys and their values in one go, making it efficient for bulk storage.

2. Step 2: Compare with other commands

   MGET retrieves values, DEL deletes keys, and INCR increments numeric keys, so these are not what MSET does.

3. Final Answer:

   Stores multiple key-value pairs in one command -> Option B

4. Quick Check:

   MSET stores many keys at once = D [OK]

Hint: MSET saves many keys and values together [OK]

Common Mistakes:

• Confusing MSET with MGET
• Thinking MSET deletes keys
• Assuming MSET increments values

2.

Which of the following is the correct syntax to set multiple keys key1 and key2 with values val1 and val2 using MSET?

?

easy

A. MSET {key1: val1, key2: val2}

B. MSET (key1, val1), (key2, val2)

C. MSET key1 val1 key2 val2

D. MSET [key1, val1, key2, val2]

Solution

1. Step 1: Recall MSET syntax

   The correct syntax for MSET is to list keys and values in sequence separated by spaces: MSET key1 val1 key2 val2.

2. Step 2: Identify incorrect formats

   Parentheses, braces, or brackets are not used in Redis commands for MSET. So options B, C, and D are invalid syntax.

3. Final Answer:

   MSET key1 val1 key2 val2 -> Option C

4. Quick Check:

   MSET uses space-separated key value pairs = A [OK]

Hint: MSET uses space-separated key value pairs [OK]

Common Mistakes:

• Using parentheses or braces in command
• Separating pairs with commas
• Trying to pass a dictionary or list

3.

Given the commands below, what will be the output of the MGET command?

MSET name Alice age 30 city Paris
MGET name age city

medium

A. ["Alice", "30", "Paris"]

B. ["name", "age", "city"]

C. ["Alice", 30, "Paris"]

D. ["Alice", null, "Paris"]

Solution

1. Step 1: Understand MSET effect

   The MSET command sets keys name, age, and city with values "Alice", "30", and "Paris" respectively as strings.

2. Step 2: Predict MGET output

   MGET name age city returns the values for these keys in order as strings: ["Alice", "30", "Paris"].

3. Final Answer:

   ["Alice", "30", "Paris"] -> Option A

4. Quick Check:

   MGET returns values in order = B [OK]

Hint: MGET returns values as strings in key order [OK]

Common Mistakes:

• Expecting numeric 30 instead of string "30"
• Confusing keys with values in output
• Assuming missing keys return null

4.

What is wrong with this Redis command sequence?

MSET key1 val1 key2
MGET key1 key2

medium

A. MSET is missing a value for key2, causing an error

B. MGET syntax is incorrect, keys must be comma-separated

C. MSET keys must be quoted strings

D. MGET cannot retrieve multiple keys

Solution

1. Step 1: Check MSET command completeness

   The MSET command requires pairs of keys and values. Here, key2 has no value, so the command is incomplete and causes an error.

2. Step 2: Verify MGET syntax

   MGET accepts space-separated keys, so the syntax is correct. Quoting keys is not required in Redis commands.

3. Final Answer:

   MSET is missing a value for key2, causing an error -> Option A

4. Quick Check:

   MSET needs key-value pairs = A [OK]

Hint: MSET needs pairs: key then value [OK]

Common Mistakes:

• Leaving out a value for a key in MSET
• Using commas in MGET keys
• Quoting keys unnecessarily

5.

You want to store user data for three users with keys user:1, user:2, and user:3 and their names Alice, Bob, and Carol. Which command correctly sets all three users at once and then fetches their names?

hard

A. SET user:1 Alice
SET user:2 Bob
SET user:3 Carol
GET user:1 user:2 user:3

B. MSET {user:1: Alice, user:2: Bob, user:3: Carol}
MGET [user:1, user:2, user:3]

C. MSET user:1=Alice user:2=Bob user:3=Carol
MGET user:1 user:2 user:3

D. MSET user:1 Alice user:2 Bob user:3 Carol
MGET user:1 user:2 user:3

Solution

1. Step 1: Use correct MSET syntax for multiple keys

   The MSET command requires keys and values listed in sequence separated by spaces, like MSET user:1 Alice user:2 Bob user:3 Carol.

2. Step 2: Use MGET with space-separated keys

   MGET fetches values for multiple keys separated by spaces, so MGET user:1 user:2 user:3 is correct.

3. Step 3: Identify incorrect options

   Options B and D use invalid syntax with braces or equals signs. SET user:1 Alice SET user:2 Bob SET user:3 Carol GET user:1 user:2 user:3 uses multiple SET commands and an invalid GET with multiple keys, which is not supported.

4. Final Answer:

   MSET user:1 Alice user:2 Bob user:3 Carol MGET user:1 user:2 user:3 -> Option D

5. Quick Check:

   MSET and MGET use space-separated keys and values = C [OK]

Hint: MSET and MGET use space-separated keys and values [OK]

Common Mistakes:

• Using braces or equals signs in MSET
• Trying to GET multiple keys at once
• Using multiple SET commands instead of MSET