Ho hlahisitsoe DBMS rqlite 6.0 e ajoang, e sebelisang SQLite joalo ka enjene ea polokelo mme e u lumella ho hlophisa mosebetsi oa sehlopha ho tsoa ho li-storages tse hokahaneng. E 'ngoe ea likarolo tsa rqlite ke boiketlo ba ho kenya, ho tsamaisa le ho boloka polokelo e ajoang e mamellang liphoso, e batlang e tšoana le etcd le Consul, empa ho sebelisa mohlala oa data oa kamano ho e-na le mokhoa oa bohlokoa / oa boleng. Khoutu ea projeke e ngotsoe ho Go mme e ajoa tlasa laesense ea MIT.
Ho boloka li-node tsohle li le boemong bo lumellanang, ho sebelisoa algorithm ea Raft consensus. Rqlite e sebelisa laebrari ea mantlha ea SQLite le mokhanni ea tloaelehileng oa go-sqlite3, eo ka holim'a eona ho qalisoang lera le sebetsanang le likopo tsa bareki, e etsa phetisetso ho li-node tse ling le ho lekola katleho ea tumellano mabapi le khetho ea node e etellang pele.
Liphetoho ho database li ka etsoa feela ke node e khethiloeng e le moetapele, empa likhokahano le ts'ebetso ea ho ngola li ka boela tsa romelloa ho li-node tse ling sehlopheng, se tla khutlisetsa aterese ea moetapele ho pheta kopo (phetolelong e latelang ba ts'episa ho eketsa phetisetso ea likopo ho moetapele). Ntho e ka sehloohong e hatisoang ke ho mamellana ha liphoso, kahoo DBMS e lekanya feela ka ts'ebetso ea ho bala, 'me ho ngola ts'ebetso ke bothata. Hoa khoneha ho tsamaisa sehlopha sa rqlite ho tloha node e le 'ngoe' me tharollo ena e ka sebelisoa ho fana ka phihlelo ea SQLite holim'a HTTP ntle le ho fana ka mamello ea phoso.
Lintlha tsa SQLite sebakeng se seng le se seng ha se bolokoe faeleng, empa mohopolong. Boemong ba lera ka ts'ebetsong ea protocol ea Raft, ho bolokoa lethathamo la litaelo tsohle tsa SQLite tse lebisang liphetohong tsa database. Lenane lena le sebelisoa nakong ea ho pheta-pheta (ho pheta-pheta boemong ba ho hlahisa likopo ho li-node tse ling), ho qala node e ncha, kapa ho hlaphoheloa ho lahleheloa ke khokahanyo. Ho fokotsa boholo ba logi, ho sebelisoa liphutheloana tsa othomathike, tse qalang ka mor'a hore ho be le liphetoho tse itseng 'me li lebisa ho snapshot e behiloeng holim'a disk, mabapi le hore na ho qala ho bolokoa log e ncha (boemo ba database) e ts'oana le snapshot + lenane la liphetoho tse bokelletsoeng).
Likarolo tsa rqlite:
- Ho bonolo ho kenya sehlopha, ntle le tlhoko ea ho kenya SQLite ka thoko.
- Bokhoni ba ho fumana sebaka sa polokelo ea SQL kapele.
- E loketse ho sebelisoa mererong ea ho sebetsa (Production-grade).
- Ho ba teng ha HTTP(S) API e u lumellang hore u ntlafatse data ka mokhoa oa batch le ho fumana node e ka sehloohong ea sehlopha. E boetse e fana ka sebopeho sa mola oa taelo le bokhoni ba ho sebelisa lilaebrari tse fapaneng tsa bareki tse hahiloeng bakeng sa SQLite.
- Ho fumaneha ha ts'ebeletso bakeng sa ho khetholla li-node tse ling, ho u lumella ho theha lihlopha ka matla.
- Ts'ehetso ea ho encrypting phapanyetsano ea data lipakeng tsa node.
- Bokhoni ba ho hlophisa boemo ba ho lekola bohlokoa le ho tsitsa ha data ha u bala.
- Bokhoni ba boikhethelo ba ho hokahanya li-node ka mokhoa oa ho bala feela, tse sa nkeng karolo ho khethollang tumellano mme li sebelisetsoa ho eketsa sekhahla sa sehlopha bakeng sa ts'ebetso ea ho bala.
- Ts'ehetso bakeng sa mofuta oa hau oa khoebo o ipapisitseng le ho kopanya litaelo ka kopo e le 'ngoe (litšebelisano tse thehiloeng ho BEGIN, COMMIT, ROLLBACK, SAVEPOINT le RELEASE ha li tšehetsoe).
- Tšehetso ea ho theha li-backups tse chesang.
Tokollo e ncha e hlahisa liphetoho tse kholo tsa meralo tse reretsoeng ho eketsa ts'epo ea sehlopha ka ho ntlafatsa ts'ebetso ea ho tsamaisa likopo tsa ho bala le ho ngola ho li-cluster node tse nepahetseng. Li-node tsa rqlite joale li ka khona ho kopanya likhokahano tse ngata tse hlakileng har'a tsona li sebelisa likhokahano tsa TCP tse thehiloeng lipakeng tsa node ke protocol ea Raft. Haeba kopo e hloka bolaoli ba moetapele empa e romelloa ho node ea bobeli, node ea bobeli e ka tseba aterese ea moetapele 'me ea e fetisetsa ho mofani ntle le ho etsa lipalo tsa tumellano ea Raft.
Phetoho e boetse e felisitse tlhokahalo ea karolo e arohaneng ea khokahano ea metadata mme e felisitse ts'ebetso e arohaneng ea boemo ba Raft le metadata. Li-node tsa bobeli hona joale li romela likopo ho node ea moetapele feela ha ho hlokahala, ha ba hloka ho fumana aterese ea node ea moetapele. API e fana ka bokhoni ba ho fumana tlhahisoleseling mabapi le boemo ba li-node tse ling sehlopheng. Taelo ea ".sysdump" e kentsoe ho khokahanyo ea mola oa taelo.
Source: opennet.ru