Shulou(Shulou.com)05/31 Report--

This article focuses on "how to set the transaction isolation level supported by SequoiaDB". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "the setting method of transaction isolation level supported by SequoiaDB".

[solution]

1. The transaction isolation levels supported by the current version of SequoiaDB (v3.0.1) are read committed (Read Committed) and read uncommitted (Read Uncommitted).

two。 Currently (v3.0.1), the transaction of SequoiaDB is controlled by the following two startup parameters: 1) transactionon: indicates whether to open the transaction. The default is false.

2) transisolation: sets the isolation level of the transaction. By default, available values are: 0:RU, read unsubmitted; 1:RC, read submitted.

3. You can modify the above two startup parameters of all nodes in the SequoiaDB cluster by using the following command:

> db=new Sdb ('localhost',11810)

> db.updateConf ({transactionon:true}) / / set to start the transaction

> db.updateConf ({transisolation=1}) / / set transaction isolation level to RC read committed

4. After setting the above two startup parameters, you need to restart all nodes in the cluster for the transaction function to take effect. Assuming the installation directory is / opt/sequoiadb, you can run the following command on each machine:

/ opt/sequoiadb/bin/sdbstop-t all

/ opt/sequoiadb/bin/sdbstart-t all

At this point, I believe that you have a deeper understanding of "the setting method of transaction isolation level supported by SequoiaDB". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.