I-Citus Data ephethwe yi-Microsoft ikhiphe i-Citus 13.0, i-DBMS esabalalisiwe eyisandiso ku-PostgreSQL 17. I-Citus inika amandla ukukalwa okuvundlile kwe-PostgreSQL kuqoqo lezingxenyekazi zekhompuyutha futhi ivumela idatha ukuthi isatshalaliswe kuzo zonke izindawo kusetshenziswa i-sharding, ngokuhlukaniswa okusekelwe kuhlelo lokulondoloza. Kuzinhlelo zokusebenza, iqoqo le-Citus livela njengeseva eyodwa enkulu ye-PostgreSQL, ihlanganisa izinsiza zamanodi ayenzayo. Ikhodi ibhalwe ngo-C futhi isatshalaliswa ngaphansi kwelayisensi ye-AGPLv3.
I-Shading ikuvumela ukuthi uhlele ukugcinwa komthamo omkhulu kakhulu wedatha, ubukhulu bayo obuphelele budlula ngokuphawulekayo isitoreji sendawo se-cluster nodes ngayinye. Amathebula angawodwana angaphoqeleka ukuthi aphindaphinde kuwo wonke ama-node ukuze kusheshiswe imisebenzi yokuhlanganisa kanye nemisebenzi yokhiye bangaphandle. Ukuze wonge isikhala sediski, idatha esabalaliswa ezindaweni ezihlukahlukene ingagcinwa ngendlela ecindezelweyo.
Imibuzo esabalalisiwe ingathunyelwa kunoma iyiphi indawo ku-cluster, kodwa ukuphathwa nokuguqulwa kwe-schema sedatha kufanele kwenziwe kuphela nge-node exhumanisa iqoqo. Izicelo ezitholwe kumakhasimende zisakazwa phakathi kwama-node adingekayo futhi, uma zifaka ama-node amaningana, ukucubungula kwawo kuyahambisana. Iqoqo linganwetshwa njengoba usayizi wedatha egciniwe ukhula ngokungeza amanodi engeziwe nokuqalisa ukulinganisa kabusha.
Amacala ajwayelekile okusetshenziswa kwe-Citus afaka phakathi ukusebenzisa imibuzo yokuhlaziya nokucubungula idatha eningi yochungechunge lwesikhathi (isb., amalogi noma ukuvota kwesimo senzwa). I-Citus ifaneleka futhi ekuthuthukiseni ingqalasizinda ekhona ngokusekelwe ku-eyodwa iseva I-PostgreSQL, lapho ukusebenza kanye nomthamo wokugcina sekunganele ngenxa yokwanda komsebenzi noma ivolumu yedatha engenayo. Usebenzisa amathuluzi e-Patroni, ungakha ukucushwa okubekezelela amaphutha ngama-node okusekelayo aphindaphindwayo angathatha ama-node ayinhloko uma kwenzeka ukwehluleka.
Izinguquko ekukhishweni kwe-Citus 13.0:
- Ukushintshela egatsheni le-PostgreSQL 17.
- Ikhono lokusebenzisa umsebenzi we-JSON_TABLE() emibuzweni esabalalisiwe ukuze kuguqulwe idatha isuka kufomethi ye-JSON iye ekumeleleni okuhlobene okungase kusetshenzwa ngakho njengamathebula e-PostgreSQL avamile.
- Ukusekela kokuthi "HLANGANISA ... LAPHO INGAFANANISWE NOMTHOMBO".
- Ikhono lokuchaza indlela yokufinyelela yamathebula ahlukanisiwe kusetshenziswa isitatimende esithi "DALA ITHEBULA … USING", kanye nokushintsha indlela yokufinyelela usebenzisa "ALTER TABLE ... SETHA INDLELA YOKUFINYELELA".
- Ukwesekwa okwengeziwe kokucacisa amakholomu obunikazi akhiqizwa ngokuzenzakalelayo kumathebula ahlukene ahlukene.
- Kuvunyelwe ukusebenzisa imikhawulo yokukhipha kumathebula ahlukene ahlukene.
- Izinkinga zokuvumelanisa izindima phakathi kwama-node zixazululiwe.
- Ukusatshalaliswa kwedatha okuthuthukisiwe kokwabiwa lapho wengeza amanodi amasha kuqoqo.
- Izinketho ze-"MEMORY" kanye "SERIALIZE" zengezwe emyalweni othi "CHAZA", ongasetshenziswa ukunquma inani lememori esetshenzisiwe kanye nesikhathi esichithwe ukuguqula idatha ukuze idluliselwe kunethiwekhi.
Source: opennet.ru
