Ukukhutshwa kwenguqulelo entsha yeTimescaleDB 1.7 kwabhengezwa, uguqulelo apho Inkxaso eyongeziweyo yePostgreSQL 12 icacisiwe, kunye nokulungiswa kweminye imisebenzi. Kwabo bangaziyo Ixesha leDVD, bafanele bayazi loo nto yindawo yogcino lwedatha eyilelwe ukugcina nokucwangcisa idatha ngohlobo lwamaxesha (amacandelo amaxabiso eparameter ngamaxesha anikiweyo, irejista yenza ixesha kunye neseti yamaxabiso ahambelana neli xesha).
Le fom yokugcina ilungile kwizicelo ezinje ngeenkqubo zokujonga, amaqonga orhwebo, iinkqubo zokuqokelela ubume benzwa kunye neemethrikhi.
Malunga ne-TimescaleDB
Iprojekthi yeTimescaleDB iphunyezwa njengolwandiso lwePostgreSQL kwaye isasazwa phantsi kwelayisensi ye-Apache 2.0. Enye ikhowudi eneempawu eziphambili ihanjiswa phantsi kwelayisenisi eyahlukeneyo ye-Timescale (TSL), engavumeli utshintsho, ethintela ukusetyenziswa kwekhowudi kwiimveliso zomntu wesithathu, kwaye engavumeli ukusetyenziswa simahla kulwazi lwedatha (indawo yogcino-nkonzo njengenkonzo ).
Inxalenye enomdla yeTimescaleDB, yiyo loo nto ikuvumela ukuba usebenzise imibuzo epheleleyo ye-SQL ukuhlalutya idatha eqokelelweyo, Ukudibanisa ukusebenziseka okukhoyo kwi-DBMS yobudlelwane kunye nokuma kunye nobuchule obukwiinkqubo ezikhethekileyo ze-NoSQL.
Isakhiwo sokugcina ilungiselelwe ukubonelela ngenqanaba lokudibanisa idatha ephezulu. Ixhasa iiseti zedatha yokuhlanganisa, zisebenzisa ii-indices ezigcinwe kwi-RAM, zilayishe ngokukhawuleza iziqendu zembali, zisebenzisa imicimbi.
Into ephambili yeTimescaleDB yile Inkxaso yokwahlula ngokuzenzekelayo(isahlulelo) kuludwe lweedatha. Umsinga wedatha ongenayo uhanjiswa ngokuzenzekelayo phakathi kweetafile ezahluliweyo.
Amacandelo ayilwe ngokusekwe kwixesha (icandelo ngalinye ligcina idatha yexesha elithile) okanye linxulumene nesitshixo sokuchasana (umz. Isixhobo sokuchonga, indawo, njl.njl.). Iitafile ezahluliweyo zinokusasazeka kwiidrive ezahlukeneyo ukulungiselela ukusebenza.
Kwimibuzo, indawo yedatha ekwahluliweyo ijongeka njengetafile enkulu, ebizwa ngokuba yi-hypertable. Uxinzelelo kukumelwa okubonakalayo kweetafile ezininzi ezahlukileyo ekuqokelelwa kuzo idatha engenayo.
Yintoni entsha kwiTimescaleDB 1.7?
Kule nguqulo intsha inkxaso ye ukudityaniswa kwePostgreSQL 12 DBMS, ngelixa inkxaso yePostgreSQL 9.6.x kunye ne-10.x isusiwe, nangona i-Timescale 2.0 kuphela inkxaso yePostgreSQL 11+ iya kuhlala.
Ikwavelele ukuba utshintshe isimilo semibuzo ngokuqhubeka nokwenziwa kwemisebenzi ehlanganisiweyo (Umdibaniso wedatha engenayo eqhubekayo ngexesha lokwenyani).
Imibuzo enjalo ngoku idibanisa iimbono ezibonakalayo kunye nedatha esandula ukufika engekenzeki (ngaphambili, ukudityaniswa kuphela kugubungele idatha esele yenziwe). Ukuziphatha okutsha kusetyenziselwa ulungelelwaniso olusandula ukwenziwa.
Ngakolunye uhlangothi, ezinye izixhobo zedata eziphambili zolawulo lobomi zihanjiswe kuhlobo loluntu yoshicilelo lwentengiso, kubandakanya ukubanakho ukuphinda uqokelele idatha kunye nenkqubo yemigaqo-nkqubo yokuhambisa idatha eseleyo (ikuvumela ukuba ugcine kuphela idatha yangoku kwaye ucime ngokuzenzekelayo, yongeze, okanye ugcine irekhodi elidala).
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