December 2015
Intermediate to advanced
232 pages
5h 8m
English
SQL databases such as MySQL are more mature than NoSQL when it comes to concurrency and ACID compliance. All the solutions we just covered in Concurrency with MongoDB Explained also apply to MySQL. Only the database query syntax is different.
However, MySQL also has transactions,[42] which means that you can do ACID-compliant operations over multiple tables. This means you can solve the problem of updating multiple tables atomically in SQL databases.
Let’s continue with our previous warehouse and wallet example. We won’t construct a full example because that would introduce too much overhead. Instead we’ll just highlight the way you would check the product out of the warehouse and into the shopping cart as ...
Read now
Unlock full access