Kutulutsidwa kwa rqlite 7.0, DBMS yogawidwa, yolekerera zolakwika kutengera SQLite

Kutulutsidwa kwa DBMS rqlite 7.0 yogawidwa kunachitika, yomwe imagwiritsa ntchito SQLite ngati injini yosungiramo zinthu ndipo imakulolani kuti mukonzekere ntchito yamagulu kuchokera ku storages yolumikizidwa wina ndi mzake. Chimodzi mwazinthu za rqlite ndichosavuta kukhazikitsa, kutumiza ndi kukonza malo osungidwa osalolera zolakwika, ofanana ndi etcd ndi Consul, koma kugwiritsa ntchito mtundu wa data waubale m'malo mwa kiyi / mtundu wamtengo. Khodi ya projekiti idalembedwa mu Go ndikugawidwa pansi pa layisensi ya MIT.

Kuti ma node onse akhale olumikizana, algorithm ya Raft consensus imagwiritsidwa ntchito. Rqlite amagwiritsa ntchito laibulale yoyambirira ya SQLite ndi dalaivala wa go-sqlite3, pamwamba pake pomwe gawo limakhazikitsidwa lomwe limayang'anira zopempha zamakasitomala, kubwereza kuzinthu zina, ndikuyang'anira kukwaniritsidwa kwa mgwirizano pakusankha kotsogola.

Zosintha pa database zitha kupangidwa ndi node yomwe yasankhidwa kukhala mtsogoleri, koma kulumikizana ndi ntchito zolembera kumatha kutumizidwanso ku ma node ena mgululi, zomwe zidzabweza adilesi ya mtsogoleriyo kuti abwereze pempho (mu mtundu wotsatira iwo). lonjezani kuwonjezera kutumiza zopempha kwa mtsogoleri). Kugogomezera kwakukulu ndikulekerera zolakwika, kotero mamba a DBMS amangogwira ntchito zowerengera, ndipo ntchito zolembera ndizomwe zimalepheretsa. Ndizotheka kuyendetsa gulu la rqlite kuchokera ku node imodzi ndipo yankholi lingagwiritsidwe ntchito kupereka mwayi wa SQLite pa HTTP popanda kupereka kulekerera zolakwika.

Deta ya SQLite pa node iliyonse siyisungidwa mu fayilo, koma kukumbukira. Pa mlingo wosanjikiza ndi kukhazikitsidwa kwa Raft protocol, chipika cha malamulo onse a SQLite omwe amatsogolera kusintha kwa database amasungidwa. chipikachi chimagwiritsidwa ntchito pobwerezabwereza (kubwerezanso pamlingo wa zopempha zobwereza pa mfundo zina), poyambitsa node yatsopano, kapena kubwezeretsanso kutayika kwa kugwirizanitsa. Kuti muchepetse kukula kwa chipikacho, kulongedza kwachindunji kumagwiritsidwa ntchito, komwe kumayamba pambuyo pa kusintha kwa chiwerengero chodziwika ndipo kumabweretsa kukonzanso chithunzithunzi, pokhudzana ndi momwe chipika chatsopano chimayamba kusungidwa (malo a database mu kukumbukira ndi zofanana ndi chithunzithunzi + chipika chosinthira chosonkhanitsidwa).

Makhalidwe a rqlite:

  • Zosavuta kuyika gulu, popanda kufunikira koyika kosiyana kwa SQLite.
  • Kutha kupeza mwachangu SQL yosungirako.
  • Okonzeka kugwiritsidwa ntchito pamapulojekiti opanga (gulu lopanga).
  • Kukhalapo kwa HTTP(S) API yomwe imakulolani kuti musinthe deta mumtundu wa batch ndikuzindikira node yotsogolera ya gululo. Mawonekedwe a mzere wamalamulo ndi malaibulale amakasitomala azilankhulo zosiyanasiyana zamapulogalamu amaperekedwanso.
  • Kupezeka kwa ntchito yozindikiritsa ma node ena, kukulolani kuti mupange magulu mwamphamvu.
  • Kuthandizira kubisa kusinthana kwa data pakati pa node.
  • Kutha kukonza mulingo wowona kufunikira ndi kusasinthika kwa data powerenga.
  • Kuthekera kosankha kulumikiza ma node mumayendedwe owerengera okha, omwe satenga nawo gawo pakuzindikira kuvomerezana ndipo amagwiritsidwa ntchito kuonjezera scalability wa gulu kuti awerenge ntchito.
  • Thandizo pamayendedwe anu otengera kuphatikizira malamulo mu pempho limodzi (zochitika zochokera pa BEGIN, COMMIT, ROLLBACK, SAVEPOINT ndi RELEASE sizikuthandizidwa).
  • Thandizo popanga ma backups otentha.

M'kutulutsa kwatsopano:

  • Thandizo lowonjezera la ma rqlite clustering pogwiritsa ntchito njira yatsopano yodziwira node yomwe ingagwire ntchito pamaziko a Consul ndi etcd zosungidwa zogawidwa. Ntchitoyi imalola ma rqlite node kuti adzipezana okha - woyang'anira amangofunika kukhazikitsa ma node angapo pama seva osiyanasiyana, kutchula adilesi wamba ya Consul kapena etcd cluster (mwachitsanzo, "example.com:8500"), ndipo ma node azikhala okha. phatikizana kukhala gulu. Node yotsogola nthawi ndi nthawi imasintha zambiri za adilesi yake mu Consul kapena etcd yosungirako, zomwe zimakulolani kuti musinthe mtsogoleri popanda kufunikira kukonzanso ma node ena, komanso kuwonjezera ma node atsopano ngakhale mutasintha mtsogoleri. Ntchito ya cholowa cha Discovery mode yomwe ikuyenda pa AWS Lambda yathetsedwa.
  • Mawonekedwe a CLI amalola kufotokoza makamu angapo nthawi imodzi - ngati node yoyamba siyikupezeka, omvera otsatirawa adzalumikizidwa.
  • Khodi yofotokozera mfundo za mzere wa rqlited yakonzedwanso.
  • Phukusi la protobuf lomwe latsitsidwa lathetsedwa.
  • Zosungirako za BoltDB zomwe zimagwiritsidwa ntchito poyambitsa Raft protocol zasinthidwa ndi bbolt, mphanda kuchokera ku etcd project.

Source: opennet.ru

Kuwonjezera ndemanga