Sending multiple commands in pipeline in Redis - Mini Project: Build & Apply

Sending Multiple Commands in Pipeline with Redis

📖 Scenario: You are managing a small online store's Redis database. You want to add multiple products with their prices quickly using Redis commands.

🎯 Goal: Build a Redis pipeline that sends multiple SET commands to store product prices efficiently.

📋 What You'll Learn

Create a Redis pipeline object called pipe.

Add three SET commands to the pipeline for products: "apple", "banana", and "cherry" with prices 100, 200, and 300 respectively.

Execute the pipeline with the execute() method.

💡 Why This Matters

🌍 Real World

Using Redis pipelines helps speed up multiple commands by sending them together, which is useful in real-time applications like online stores or caching systems.

💼 Career

Knowing how to use Redis pipelines is valuable for backend developers and database administrators to optimize performance and reduce network overhead.

1

Create a Redis pipeline object

Create a Redis pipeline object called pipe using r.pipeline().

Redis

import redis
r = redis.Redis()
# Create a Redis pipeline object called pipe
# Your code here

Hint

Use pipe = r.pipeline() to create the pipeline object.

2

Add SET commands to the pipeline

Add three SET commands to the pipeline pipe for keys "apple", "banana", and "cherry" with values 100, 200, and 300 respectively using pipe.set().

Redis

import redis
r = redis.Redis()
pipe = r.pipeline()
# Add SET commands for apple, banana, and cherry with prices 100, 200, 300
# Your code here

Hint

Use pipe.set(key, value) to add each command to the pipeline.

3

Execute the pipeline

Execute the pipeline pipe using the execute() method to send all commands to Redis at once.

Redis

import redis
r = redis.Redis()
pipe = r.pipeline()
pipe.set("apple", 100)
pipe.set("banana", 200)
pipe.set("cherry", 300)
# Execute the pipeline
# Your code here

Hint

Call pipe.execute() to send all commands together.

4

Verify the stored values

Retrieve the values for "apple", "banana", and "cherry" from Redis using r.get() and store them in variables apple_price, banana_price, and cherry_price respectively.

Redis

import redis
r = redis.Redis()
pipe = r.pipeline()
pipe.set("apple", 100)
pipe.set("banana", 200)
pipe.set("cherry", 300)
pipe.execute()
# Retrieve values for apple, banana, and cherry
# Your code here

Hint

Use r.get(key) to get the stored values.

Practice

1. What is the main benefit of sending multiple commands in a Redis pipeline?

easy

A. It compresses the data before sending.

B. It reduces network round trips and speeds up command execution.

C. It automatically backs up the data.

D. It encrypts the commands for security.

Solution

1. Step 1: Understand what pipelining does

   Pipelining sends many commands at once without waiting for each reply, reducing network delays.

2. Step 2: Identify the main benefit

   This reduces the number of network round trips, making command execution faster.

3. Final Answer:

   It reduces network round trips and speeds up command execution. -> Option B

4. Quick Check:

   Pipelining = faster execution [OK]

Hint: Pipelining batches commands to save network time [OK]

Common Mistakes:

• Thinking pipelining encrypts commands
• Assuming pipelining compresses data
• Believing pipelining backs up data automatically

2. Which of the following is the correct way to start a Redis transaction pipeline?

easy

A. MULTI

B. PIPELINE

C. EXEC

D. BEGIN

Solution

1. Step 1: Recall Redis transaction commands

   Redis transactions start with the command MULTI to begin queuing commands.

2. Step 2: Confirm the correct command

   EXEC is used to execute queued commands, not to start the pipeline.

3. Final Answer:

   MULTI -> Option A

4. Quick Check:

   Start pipeline with MULTI [OK]

Hint: Start with MULTI, end with EXEC [OK]

Common Mistakes:

• Using EXEC to start instead of end
• Using PIPELINE which is not a Redis command
• Using BEGIN which is not valid in Redis

3. Consider the following Redis pipeline commands:

MULTI
SET key1 value1
SET key2 value2
EXEC

What will be the output of the EXEC command?

medium

A. [1, 1]

B. ["value1", "value2"]

C. Error: EXEC without MULTI

D. ["OK", "OK"]

Solution

1. Step 1: Understand MULTI/EXEC behavior

   Commands between MULTI and EXEC are queued and executed atomically when EXEC runs.

2. Step 2: Analyze the commands SET key1 value1 and SET key2 value2

   Each SET command returns "OK" on success.

3. Final Answer:

   ["OK", "OK"] -> Option D

4. Quick Check:

   SET commands return OK in EXEC output [OK]

Hint: SET returns OK, EXEC returns array of results [OK]

Common Mistakes:

• Expecting EXEC to return values set
• Confusing EXEC output with command errors
• Thinking EXEC returns numeric success codes

4. You wrote this Redis pipeline code:

MULTI
SET key1 value1
GET key1
EXEC

But the GET command returns nil instead of 'value1'. What is the likely cause?

medium

A. GET command is not supported inside MULTI/EXEC.

B. You forgot to call DISCARD after MULTI.

C. GET command runs before SET in the pipeline, so key1 is not set yet.

D. The key1 was deleted before EXEC.

Solution

1. Step 1: Understand command queuing in MULTI/EXEC

   Commands are queued and executed atomically, but GET inside MULTI returns nil because it reads before SET is applied.

2. Step 2: Explain why GET returns nil

   GET does not see the queued SET command's effect until after EXEC finishes.

3. Final Answer:

   GET command runs before SET in the pipeline, so key1 is not set yet. -> Option C

4. Quick Check:

   GET inside MULTI sees old data [OK]

Hint: GET inside MULTI reads old data, use EXEC results [OK]

Common Mistakes:

• Assuming GET works immediately inside MULTI
• Thinking DISCARD is needed here
• Believing GET is unsupported in transactions

5. You want to increment two counters atomically using Redis pipeline. Which sequence correctly uses MULTI/EXEC to do this?

hard

A. MULTI
INCR counter1
INCR counter2
EXEC

B. INCR counter1
INCR counter2

C. MULTI
INCR counter1
EXEC
INCR counter2
EXEC

D. PIPELINE
INCR counter1
INCR counter2
EXEC

Solution

1. Step 1: Identify atomic increment commands

   INCR commands increase counters by 1; to run atomically, they must be inside MULTI/EXEC.

2. Step 2: Check each option for correct pipeline usage

   MULTI
   INCR counter1
   INCR counter2
   EXEC

   queues both INCR commands inside MULTI and executes them together with EXEC.

3. Step 3: Explain why others are incorrect

   INCR counter1
   INCR counter2

   runs commands separately, not atomically.

   MULTI
   INCR counter1
   EXEC
   INCR counter2
   EXEC

   splits increments into two transactions.

   PIPELINE
   INCR counter1
   INCR counter2
   EXEC

   uses invalid PIPELINE command.

4. Final Answer:

   MULTI INCR counter1 INCR counter2 EXEC -> Option A

5. Quick Check:

   Atomic increments need MULTI/EXEC [OK]

Hint: Use MULTI before commands, EXEC after to run atomically [OK]

Common Mistakes:

• Running commands outside MULTI/EXEC for atomicity
• Using invalid PIPELINE command
• Splitting increments into separate transactions