{"id":103120,"date":"2022-01-28T15:37:51","date_gmt":"2022-01-28T13:37:51","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-rqlite-7-0-raspredelyonnoj-otkazoustojchivoj-subd-na-osnove-sqlite"},"modified":"2022-01-28T15:37:51","modified_gmt":"2022-01-28T13:37:51","slug":"vypusk-rqlite-7-0-raspredelyonnoj-otkazoustojchivoj-subd-na-osnove-sqlite","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sv\/blog\/news\/vypusk-rqlite-7-0-raspredelyonnoj-otkazoustojchivoj-subd-na-osnove-sqlite","title":{"rendered":"Utg\u00e5van av rqlite 7.0, en distribuerad felresistent databas baserad p\u00e5 SQLite","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Release of the distributed database rqlite 7.0 has taken place, which uses SQLite as its storage engine and allows the operation of a cluster of synchronized storage systems. rqlite is noted for its ease of installation, deployment, and maintenance of a distributed fault-tolerant storage solution, somewhat similar to etcd and Consul, but utilizing a relational data model instead of a key\/value format. The project's code is written in Go and is distributed under the MIT license. <\/p>\n
To maintain all nodes in a synchronized state, the Raft consensus algorithm is used. Rqlite utilizes the original SQLite library and the go-sqlite3 driver, above which sits a layer that processes client requests, performs replication to other nodes, and monitors the achievement of consensus for selecting a leader node. <\/p>\n
Changes to the database can only be made by the node selected as the leader, but connections for write operations can also be directed to other nodes in the cluster, which will return the leader's address to retry the request (an automatic redirection to the leader is promised in the next version). The main focus is on fault tolerance, so the database is only scalable for read operations, while write operations are a bottleneck. It is possible to launch an rqlite cluster from a single node, and this solution can be used to provide access to SQLite over HTTP without offering fault tolerance. <\/p>\n
SQLite data on each node is stored not in a file but in memory. At the layer implementing the Raft protocol, a log of all SQLite commands that lead to changes in the database is maintained. This log is used during replication (replication at the request playback level on other nodes), when launching a new node, or for recovery after a loss of connectivity. For reducing the log size, automatic packing is applied, which is initiated after a specified number of changes and results in a snapshot being recorded, relative to which a new log begins (the state of the database in memory is identical to the snapshot plus the accumulated change log). <\/p>\n
Features of rqlite: <\/p>\n
\n
Ease of deploying the cluster without needing a separate SQLite installation. <\/li>\n
M\u00f6jlighet att snabbt f\u00e5 ett replikerat SQL-lager. <\/li>\n
Redo f\u00f6r anv\u00e4ndning i produktionsprojekt. <\/li>\n
Tillg\u00e5ng till HTTP(S) API som m\u00f6jligg\u00f6r batchuppdatering av data och best\u00e4mning av ledande nod i klustret. Ett kommandoradsgr\u00e4nssnitt och klientbibliotek f\u00f6r olika programmeringsspr\u00e5k tillhandah\u00e5lls ocks\u00e5. <\/li>\n
Tillg\u00e5ng till en tj\u00e4nst f\u00f6r att identifiera andra noder, vilket m\u00f6jligg\u00f6r dynamisk skapande av kluster. <\/li>\n
St\u00f6d f\u00f6r kryptering av datakommunikation mellan noder. <\/li>\n
M\u00f6jlighet att konfigurera niv\u00e5n av giltighets- och konsistenskontroll vid l\u00e4sning. <\/li>\n
Valfri m\u00f6jlighet att koppla noder i skrivskyddat l\u00e4ge, som inte deltar i konsensusbest\u00e4mningen och anv\u00e4nds f\u00f6r att \u00f6ka klustrets skalbarhet vid l\u00e4soperationer. <\/li>\n
St\u00f6d f\u00f6r egendefinierade transaktionsformer baserade p\u00e5 sammanslagning av kommandon i en f\u00f6rfr\u00e5gan (transaktioner baserade p\u00e5 BEGIN, COMMIT, ROLLBACK, SAVEPOINT och RELEASE st\u00f6ds inte). <\/li>\n
St\u00f6d f\u00f6r skapande av heta s\u00e4kerhetskopior. <\/ul>\n