{"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\/sq\/blog\/novosti-interneta\/vypusk-rqlite-7-0-raspredelyonnoj-otkazoustojchivoj-subd-na-osnove-sqlite","title":{"rendered":"L\u00ebshimi rqlite 7.0, nj\u00eb DBMS e shp\u00ebrndar\u00eb dhe e q\u00ebndrueshme e bazuar n\u00eb SQLite","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Lansohet rqlite 7.0, nj\u00eb sistem i shp\u00ebrndar\u00eb i menaxhimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave q\u00eb p\u00ebrdor SQLite si motor ruajtjeje dhe lejon organizimin e nj\u00eb klasteri me depo t\u00eb sinkronizuara mes tyre. Nj\u00eb nga karakteristikat e rqlite \u00ebsht\u00eb thjesht\u00ebsia e instalimit, shp\u00ebrndarjes dhe mb\u00ebshtetjes s\u00eb nj\u00eb depoje t\u00eb shp\u00ebrndar\u00eb me q\u00ebndrueshm\u00ebri, nj\u00ebsoj si etcd dhe Consul, por q\u00eb p\u00ebrdor modelin relacional p\u00ebr pun\u00ebn me t\u00eb dh\u00ebnat n\u00eb vend t\u00eb formatit \u00e7el\u00ebs\/vler\u00eb. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT. <\/p>\n
P\u00ebr t\u00eb mbajtur t\u00eb gjitha nyjat n\u00eb nj\u00eb gjendje t\u00eb sinkronizuar, p\u00ebrdoret algoritmi i arrijes s\u00eb konsensusit Raft. Rqlite p\u00ebrdor bibliotek\u00ebn origjinale SQLite dhe driverin go-sqlite3, mbi t\u00eb cilat shkarkohet nj\u00eb nd\u00ebrfaqe q\u00eb trajton k\u00ebrkesat e klient\u00ebve, kryen replikimin n\u00eb nyjat e tjera dhe ndjek arritjen e konsensusit p\u00ebr zgjedhjen e nyj\u00ebs lidere. <\/p>\n
Ndryshimet n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave mund t\u00eb kryhen vet\u00ebm nga nyja e cila \u00ebsht\u00eb zgjedhur si lider, por lidhjet me operacionet e shkrimit mund t\u00eb drejtohen edhe te nyjat e tjera t\u00eb klasterit, t\u00eb cilat do t\u00eb kthejn\u00eb adres\u00ebn e liderit p\u00ebr p\u00ebrs\u00ebritjen e k\u00ebrkes\u00ebs (n\u00eb versionin e ardhsh\u00ebm premtohet se do t\u00eb shtohet automatikisht redirektimi i k\u00ebrkesave te lideri). Theksi i madh vihet mbi q\u00ebndrueshm\u00ebrin\u00eb, ndaj DBMS zgjerohet vet\u00ebm sipas operacioneve t\u00eb leximit, nd\u00ebrsa operacionet e shkrimit jan\u00eb pika e ngusht\u00eb. \u00cbsht\u00eb e mundur t\u00eb startohet nj\u00eb klaster rqlite nga nj\u00eb nyje e vetme, dhe ky zgjidhje mund t\u00eb p\u00ebrdoret p\u00ebr t\u00eb organizuar aksesin n\u00eb SQLite sipas HTTP pa ofruar q\u00ebndrueshm\u00ebri. <\/p>\n
T\u00eb dh\u00ebnat SQLite n\u00eb \u00e7do nyje ruhen jo n\u00eb skedar, por n\u00eb kujtes\u00eb. N\u00eb nivelin e shtres\u00ebs me implementimin e protokollit Raft b\u00ebhet nj\u00eb regjist\u00ebr i t\u00eb gjitha komandave SQLite q\u00eb \u00e7ojn\u00eb n\u00eb ndryshimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Ky regjist\u00ebr p\u00ebrdoret gjat\u00eb replikimit (replikimi n\u00eb nivelin e riprodhimit t\u00eb k\u00ebrkesave n\u00eb nyje t\u00eb tjera), kur aktivizohet nj\u00eb nyje e re ose p\u00ebr rikuperimin pas humbjes s\u00eb lidhshm\u00ebris\u00eb. P\u00ebr t\u00eb reduktuar madh\u00ebsin\u00eb e regjistrit aplikohet paketimi automatik, i cili aktivizohet pas nj\u00eb numri t\u00eb caktuar ndryshimesh dhe \u00e7on n\u00eb regjistrimin e nj\u00eb snapshot-i, n\u00eb lidhje me t\u00eb cilin fillon t\u00eb mbahet nj\u00eb regjist\u00ebr i ri (gjendja e baz\u00ebs n\u00eb kujtes\u00eb \u00ebsht\u00eb identike me snapshot-in + regjistrin e ndryshimeve t\u00eb grumbulluara). <\/p>\n
Karakteristikat e rqlite: <\/p>\n
\n
Thjesht\u00ebsia e shp\u00ebrndarjes s\u00eb klasterit, pa nevoj\u00ebn e instalimit t\u00eb ve\u00e7ant\u00eb t\u00eb SQLite. <\/li>\n
Gati p\u00ebr t'u p\u00ebrdorur n\u00eb projekte pune (produksion). <\/li>\n
Prania e nj\u00eb API HTTP(S) q\u00eb lejon p\u00ebrdit\u00ebsimin e t\u00eb dh\u00ebnave n\u00eb modalitetin e paket\u00ebs dhe p\u00ebrcaktimin e nyj\u00ebs udh\u00ebheq\u00ebse t\u00eb klasterit. Gjithashtu, ofrohet nj\u00eb nd\u00ebrfaqe e linj\u00ebs s\u00eb komand\u00ebs dhe libra klienti p\u00ebr gjuh\u00eb t\u00eb ndryshme programimi. <\/li>\n
Disponibiliteti i sh\u00ebrbimit p\u00ebr t\u00eb identifikuar node t\u00eb tjera, duke lejuar krijimin dinamik t\u00eb klaster\u00ebve. <\/li>\n
Mb\u00ebshtetje p\u00ebr enkriptimin e komunikimit t\u00eb t\u00eb dh\u00ebnave midis node-ve. <\/li>\n
Mund\u00ebsia p\u00ebr t\u00eb konfigurur nivelin e verifikimit t\u00eb \u0430\u043a\u0442\u0443\u0430\u043bitetit dhe koherenc\u00ebs s\u00eb t\u00eb dh\u00ebnave gjat\u00eb leximit. <\/li>\n
Mund\u00ebsi opsionale p\u00ebr t\u00eb lidhur node n\u00eb m\u00ebnyr\u00eb vet\u00ebm p\u00ebr lexim, t\u00eb cilat nuk marrin pjes\u00eb n\u00eb p\u00ebrcaktimin e konsensusit dhe p\u00ebrdoren p\u00ebr t\u00eb rritur shkall\u00ebzueshm\u00ebrin\u00eb e klasterit p\u00ebr operacionet e leximit. <\/li>\n
Mb\u00ebshtetje p\u00ebr forma t\u00eb veta t\u00eb transaksioneve t\u00eb bazuara n\u00eb bashkimin e komandave n\u00eb nj\u00eb k\u00ebrkes\u00eb (transaksionet e bazuara n\u00eb BEGIN, COMMIT, ROLLBACK, SAVEPOINT dhe RELEASE nuk mb\u00ebshteten). <\/li>\n
Mb\u00ebshtetje p\u00ebr krijimin e kopjeve rezerv\u00eb t\u00eb nxehta. <\/ul>\n