Ukukhutshwa kwe-DBMS TimescaleDB 2.0 kupapashiwe, uguqulelo apho utshintsho longezwa kwilayisensi ye-TSL ukunika abasebenzisi amalungelo angaphezulu kwaye vumela ukusetyenziswa simahla kwawo onke amanqaku ohlobo lweshishini, kubandakanya uxinzelelo, ukuhanjiswa kokuhanjiswa kwiindawo ezininzi kunye nokudityaniswa okuqhubekayo. Ilayisenisi isuse izithintelo kubungakanani bendibano yoluntu, inikwe ilungelo lokwenza uphuculo kunye notshintsho, isuse izibophelelo ezihlawulelweyo (zonke izinto ebezinikezelwa ngaphambili kwiTimescaleDB Enterprise ziye zadluliselwa kuhlelo loLuntu).
Kulabo abangaqhelekanga ngeTimescaleDB, kuya kufuneka uyazi loo nto iphunyezwa njengolwandiso lwePostgreSQLyenzelwe ukugcina nokucwangcisa idatha ngohlobo lwamaxesha exesha (iinxalenye zamaxabiso eparameter ngamaxesha athile achaziweyo, irekhodi lakha ixesha kunye neseti yamaxabiso ahambelana neli xesha).
Le fom yokugcina zintle kwizicelo ezinje ngeenkqubo zokubeka iliso, amaqonga orhwebo, iinkqubo zokuqokelela iimethrikhi kunye nenzwa ithi. Iindlela zokudibanisa neprojekthi yeGrafana kunye nePrometheus zibonelelwe.
Eyona nto iphambili kwi-TimescaleDB yinkxaso yokwahlulahlula ngokuzenzekelayo uluhlu lwedatha, Kunye nokuhamba kwedatha yegalelo kuhanjiswa ngokuzenzekelayo phakathi kweetafile ezahluliweyo kunye nokuba amacandelo ayenziwe ngokwexesha (icandelo ngalinye ligcina idatha yexesha elithile) okanye ngokunxulumene nesitshixo sokuchasana.
Iimpawu ezintsha eziphambili kwiTimescaleDB 2.0
Kule nguqulo intsha ukuphunyezwa okutsha kwemisebenzi eyenziwa ngokuqhubekayo kuyacetyiswa Bayakuvumela ukuba uqhubeke ukongeza idatha engenayo ngexesha lokwenyani (bayafana nezinto ezibonakalayo zePostgreSQL, kodwa bahlukile kuba banikezela ukubalwa ngokuzenzekelayo kweziphumo zombuzo ngasemva njengoko idatha ifika okanye itshintsha).
Ukuphunyezwa okutsha ibonakaliswe ngotshintsho kwi-API, ngoku eyahlula ngokucacileyo imisebenzi kunye nemigaqo yokuhlanganisa, ekuvumela ukuba uphumeze izinto ezinje ngokuhlaziya ngesandla uluhlu oluthile kumbono ohlanganisiweyo (umzekelo, unokuzenzekelayo ngokuzenzekelayo idatha entsha, kodwa ushiye idatha yakudala yembali yokuhlaziya ngesandla). Utshintsho luya kwenza ukuba kunokwenzeka kwixesha elizayo ukuphumeza inkxaso kwimisebenzi ehanjisiweyo xa usebenza ngeendlela ezininzi.
Olunye utshintsho olubalulekileyo yile Inkxaso yezenzo ezichazwe ngumsebenzisi (UDA, Isenzo esichaziweyo somsebenzisi) ukwenza imisebenzi kunye neenkqubo kwishedyuli ibhalwe ngeelwimi ezingalawulekiyo. Inqaku elitsha lilungele ukwenza imisebenzi yamaxesha athile engagutyungelwanga yimigaqo-nkqubo yoqhagamshelo ekhoyo (ukucocwa kwedatha, uxinzelelo kunye nokudityaniswa okuqhubekayo).
Yongezwe Inkxaso yokuhanjiswa komxholo, Ukuvumela ukugcinwa kusasazeke kwiindawo ezininzi ngeTimescaleDB. Uqwalaselo lweqela olusekwe kwi-TimescaleDB lubandakanya indawo yokufikelela kunye neendawo zokugcina ezininzi. Zonke izicelo kwi-hypertext esasaziweyo zijolise kwindawo yolwazi kwaye emva koko zisasazwe kwiindawo zokugcina.
Inkxaso eyongeziweyo yemibono emitsha yolwazi, ekuvumela ukuba ufumane ulwazi malunga ne-hypertext, ii-cluster node, imitya, imigaqo-nkqubo, kunye neshedyuli yokuqalisa umsebenzi.
Uyifaka njani i-TimescaleDB kwiLinux?
Kwabo banomdla ukuze ukwazi ukufaka i-TimescaleDB kwinkqubo yakhoBanokwenza oko ngokulandela imiyalelo esabelana ngayo ngezantsi.
Kwimeko yabo bangabo Abasebenzisi boBuntu:
sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c -s)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add – sudo add-apt-repository ppa:timescale/timescaledb-ppa sudo apt-get update sudo apt install timescaledb-postgresql-11
Kwimeko I-Debian:
sudo sh -c "echo 'deb https://packagecloud.io/timescale/timescaledb/debian/ `lsb_release -c -s` main' > /etc/apt/sources.list.d/timescaledb.list" wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - sudo apt-get update sudo apt-get install timescaledb-postgresql-11
RHEL / CentOS:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo tee /etc/yum.repos.d/timescale_timescaledb.repo <<EOL [timescale_timescaledb] name=timescale_timescaledb baseurl=https://packagecloud.io/timescale/timescaledb/el/7/\$basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey sslverify=1 sslcacert=/etc/pki/tls/certs/ca-bundle.crt metadata_expire=300 EOL
sudo yum update -y sudo yum install -y timescaledb-postgresql-11
Ngoku Siza kuqwalasela isiseko sedatha nge:
sudo timescaledb-tune
Apha iinkqubo ezahlukeneyo zinokwenziwa, onokuthi udibane nayo Kule khonkco ilandelayo.
Ekugqibeleni, qala inkonzo kwakhona:
sudo service postgresql restart