Shulou(Shulou.com)06/01 Report--

Next, let's learn about the mysql relational database that follows the ACID rules. I believe you will benefit a lot after reading it. The text is not much in the essence. I hope the mysql relational database that follows the ACID rules is what you want.

Relational databases follow ACID rules

Transaction is transaction in English, which is similar to real-world transaction. It has the following four features:

1. A (Atomicity) atomicity

Atomicity is easy to understand, that is, all operations in the transaction are either completed or not done. The condition for the success of a transaction is that all operations in the transaction are successful. As long as one operation fails, the whole transaction fails and needs to be rolled back.

For example, a bank transfer of 100 yuan from An account to B account is divided into two steps: 1) withdraw 100 yuan from An account; 2) deposit 100 yuan to B account. These two steps are either completed together or not together. If only the first step is completed and the second step fails, the money will be inexplicably less than 100 yuan.

2. C (Consistency) consistency

Consistency is also easy to understand, that is, the database should be in a consistent state all the time, and the operation of the transaction will not change the original consistency constraints of the database.

For example, the existing integrity constraint a+b=10, if a transaction changes a, then b must be changed so that the transaction still satisfies a+b=10 after the transaction ends, otherwise the transaction fails.

3. I (Isolation) independence

The so-called independence means that concurrent transactions will not affect each other. If the data accessed by one transaction is being modified by another transaction, as long as another transaction is not committed, the data accessed by it will not be affected by the uncommitted transaction.

For example, there is a transaction that transfers 100 yuan from An account to B account. In the case that the transaction has not been completed, if B inquires about his own account at this time, he will not see the new 100 yuan.

4. D (Durability) persistence

Persistence means that once a transaction is committed, its changes will be permanently stored on the database and will not be lost even if there is an outage.

After reading this article on mysql relational database that follows ACID rules, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.