{"id":121799,"date":"2025-02-10T15:46:10","date_gmt":"2025-02-10T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/opublikovana-raspredelyonnaya-subd-citus-13-0"},"modified":"2025-02-10T15:46:10","modified_gmt":"2025-02-10T13:46:10","slug":"opublikovana-raspredelyonnaya-subd-citus-13-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/opublikovana-raspredelyonnaya-subd-citus-13-0","title":{"rendered":"U publikua sistemi i menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb shp\u00ebrndara Citus 13.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Kompania Citus Data, e cila i p\u00ebrket Microsoft, publikoi DBMS t\u00eb shp\u00ebrndar\u00eb Citus 13.0, e cila \u00ebsht\u00eb realizuar si nj\u00eb zgjerim p\u00ebr PostgreSQL 17. Citus ofron shkall\u00ebzim horizontal t\u00eb PostgreSQL n\u00eb nj\u00eb grup t\u00eb bazuar n\u00eb pajisje standarde dhe lejon shp\u00ebrndarjen e t\u00eb dh\u00ebnave n\u00eb nodet p\u00ebrmes sharding me konfigurimin e ndarjes n\u00eb nivel kolone dhe skem\u00ebs s\u00eb ruajtjes. P\u00ebr aplikacionet, grupi Citus duket si nj\u00eb server i madh PostgreSQL, i cili bashkon burimet e nodave t\u00eb tij. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn AGPLv3. <\/p>\n

Sharding lejon organizimin e ruajtjes s\u00eb nj\u00eb sasia shum\u00eb t\u00eb madhe t\u00eb dh\u00ebnash, e cila tejkalon ndjesh\u00ebm kapacitetin lokal t\u00eb secilit nga nodet e grupit. Tabelat e ve\u00e7anta mund t\u00eb republikohet p\u00ebr t\u00eb shpejtuar operacionet e bashkimit dhe pun\u00ebn me \u00e7el\u00ebsa t\u00eb jasht\u00ebm. P\u00ebr t\u00eb kursyer hap\u00ebsir\u00eb t\u00eb diskut, t\u00eb dh\u00ebnat e shp\u00ebrndara n\u00eb nodet e ndryshme mund t\u00eb ruhen n\u00eb form\u00eb t\u00eb kompresuar. <\/p>\n

K\u00ebrkesat e shp\u00ebrndara mund t\u00eb d\u00ebrgohen n\u00eb secilin nga nodet e grupit, por menaxhimi dhe ndryshimi i skem\u00ebs s\u00eb t\u00eb dh\u00ebnave duhet t\u00eb b\u00ebhet vet\u00ebm p\u00ebrmes nodit q\u00eb koordinon pun\u00ebn e grupit. K\u00ebrkesat q\u00eb vijn\u00eb nga klient\u00ebt shp\u00ebrndahen n\u00eb nodet p\u00ebrkat\u00ebse dhe, n\u00ebse ato p\u00ebrfshijn\u00eb disa node, p\u00ebrpunimi i tyre ndahen n\u00eb m\u00ebnyr\u00eb paralele. Grupi mund t\u00eb zgjerohet me rritjen e sasis\u00eb s\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura, duke shtuar nodet shtes\u00eb dhe duke iniciuar riparimin. <\/p>\n

Si shembuj tipik\u00eb t\u00eb p\u00ebrdorimit t\u00eb Citus p\u00ebrmendet realizimi i k\u00ebrkesave analitike dhe procesimi i sasis\u00eb t\u00eb madhe t\u00eb t\u00eb dh\u00ebnave n\u00eb form\u00ebn e serive temporale (p.sh., loge ose pyetje p\u00ebr gjendjen e sensor\u00ebve). Citus \u00ebsht\u00eb gjithashtu i p\u00ebrshtatsh\u00ebm p\u00ebr modernizimin e infrastruktur\u00ebs ekzistuese t\u00eb bazuar n\u00eb nj\u00eb PostgreSQL, performanca e t\u00eb cilit ka pushuar t\u00eb jet\u00eb e mjaftueshme p\u00ebr shkak t\u00eb rritjes s\u00eb ngarkes\u00ebs ose v\u00ebllimit t\u00eb t\u00eb dh\u00ebnave q\u00eb po vijn\u00eb. serverit<\/a> Me ndihm\u00ebn e mjetit Patroni, mund t\u00eb krijohen konfiguracione t\u00eb q\u00ebndrueshme me node rezerv\u00eb t\u00eb replikuara, t\u00eb cilat jan\u00eb n\u00eb gjendje t\u00eb z\u00ebn\u00eb vendin e nodeve kryesore n\u00eb rast t\u00eb d\u00ebshtimit. <\/p>\n

Ndryshimet n\u00eb versionin Citus 13.0: <\/p>\n