Home
Tags Projects About
Locking Mechanisms in High-Load Systems

Locking Mechanisms in High-Load Systems

In the world of concurrent systems, especially when we're dealing with high-load distributed environments, finding a balance between data consistency and system performance is a constant headache. The main catch here is synchronization mechanisms, especially locks. These guys ensure that processes don't step on each other's toes when sharing resources. In this blog post, let's break down what locks are, how they impact system performance and reliability, and why you should care as an engineer.

Understanding Locking

Picture this: it's a happy hour, and the bar is packed. Everyone’s trying to catch the bartender's attention to order their drinks. This is pretty similar to how concurrent systems function, with multiple users or processes trying to access the same resources concurrently. In this setup, "locking" is like the bouncer — the enforcer — making sure everyone gets their turn. Only here, it's not about drink orders; it's about controlling access to things like database rows or tables. Without this kind of management, you’d see issues like data corruption as quickly as a drink might spill in that crowded bar.

Locks generally come in two flavors: optimistic and pessimistic, each with distinct strategies for handling access to shared resources. We will focus more on the shared data access.

Pessimistic Locking

Pessimistic locking is like playing it safe, assuming conflicts over data access are likely to happen. So, it locks down the resource ahead of time, keeping exclusive access for the duration of the transaction or critical operation. This means nobody else gets to touch that resource until it's done.

Booking all taxis

Think of it like booking every taxi in town on a rainy day — not because you need them all, but just to make sure you get a ride whenever you need one.

In database terms, this looks like locking the rows or tables the moment a transaction starts and not letting them go until it's done.

Here's a taste of what pessimistic locking might look like in SQL:

BEGIN TRANSACTION;
SELECT * FROM table_name WITH (XLOCK, ROWLOCK);
-- Perform operations...
COMMIT TRANSACTION;

By locking data objects throughout a transaction, pessimistic locking ensures no other transactions can mess with the data until the lock is released.

While this approach minimizes risks associated with concurrent access, it can also lead to decreased system performance and scalability due to long-held locks that prevent other transactions from proceeding (depending on how expensive conflict resolution is).

Pessimistic locking is best for situations where conflicts are frequent or the potential damage from data loss or corruption are high, like in banking systems where you really want to avoid any issues with concurrent access.

Pros and cons

➕ Ensures data consistency and integrity by preventing concurrent modifications.

➕ Simple and straightforward approach to managing data access.

➕ Can actually boost performance in conflict-heavy environments, avoiding expensive conflict resolution.

➖ Increased potential for lock contention and longer wait times.

➖ Reduced system performance and scalability due to extended lock duration.

Optimistic Locking

Optimistic locking, on the other hand, assumes conflicts are the exception, not the rule. It doesn’t lock data during the transaction but checks for trouble only when committing the transaction.

Conflicts during boarding

Imagine this: You’ve got a confirmed seat on an overbooked flight. While you stroll around the terminal grabbing snacks, you’re thinking you’re all set. But when you finally get to the gate — bam! — your seat’s double-booked. Now, they might have to bump you to a later flight or sweeten the deal with some upgrades or vouchers (or jail sometimes). This mess is exactly how optimistic locking works. Systems cruise along, assuming things are fine, and only deal with conflicts if they arise at the finish line.

Optimistic locking typically relies on versions or timestamps. A transaction remembers the version of the data when it starts. If the data’s version has changed by the time it commits, the transaction rolls back, and you might need to retry.

Here’s a typical way to implement optimistic locking:

BEGIN TRANSACTION;
-- Record the version number
SELECT version FROM table_name WHERE id = 1;
-- Perform operations...
-- Recheck the version before committing
IF version = original_version THEN
    COMMIT TRANSACTION;
ELSE
    ROLLBACK TRANSACTION;
END IF;

Or, in a more familiar context for developers, using version control like Git:

# Get the latest version and record the version number
git pull --rebase
# Execute changes...
git commit -m "Commit message"
# Recheck the version before committing
git push

This approach works great in environments with lots of activity but low chances of conflict, like web applications where simultaneous edits are rare. Optimistic locking delivers high performance without the hassle of frequent locking.

Pros and cons

➕ Higher throughput and reduced lock contention.

➕ Minimized overhead due to less frequent locking.

➖ More complex to manage conflicts when they do occur.

➖ Possible increase in transaction retries, impacting user experience.

Conclusion

The choice between optimistic and pessimistic locking boils down to the specific needs of your app and its workload. Pessimistic locking is your go-to for systems where conflicts are common, and data integrity is non-negotiable. On the flip side, optimistic locking can significantly enhance performance in systems where conflicts are few and far between.

Integrating these locking strategies into your architecture requires a deep understanding of your system's characteristics. If done right, they can drastically improve the reliability and efficiency of your applications, keeping data intact in the chaos of database transactions.

Additional materials



Buy me a coffee

More? Well, there you go:

Concurrency and Parallelism are two different things

Asynchronous Programming. Threads and Processes

Concurrency vs Parallelism