TimescaleDB 2.0 inouya nerutsigiro rwevashandisi-vanotsanangurwa zviito, shanduko kune TSL rezinesi uye nezvimwe

Iyo DBMS TimescaleDB 2.0 kuburitswa kwakaburitswa, shanduro mairi shanduko dzakawedzerwa kune rezinesi reTSL kupa vashandisi kodzero zhinji uye tendera kushandiswa kwemahara kweese maficha eiyo bhizinesi vhezheni, kusanganisira kumanikidza, kuchengetedza kugovera pamatanho mazhinji uye kuenderera kuunganidzwa. Rezinesi rakabvisa zvirambidzo pachiyero chegungano renharaunda, rakapihwa mvumo yekugadzirisa nekuchinja, kubvisa mabhanhire akabhadharwa (maficha ese akambopihwa muTimescaleDB Enterprise akaendeswa kuCommunity edition).

Kune avo vasingazive nezve TimescaleDB, iwe unofanirwa kuziva izvo inoitwa seyekuwedzera kwePostgreSQLyakagadzirirwa kuchengetedza nekugadzirisa dhata muchimiro chenguva dzakateedzana (zvikamu zvemiparamende kukosha panguva dzakatarwa, zvinyorwa zvinoumba nguva uye seti yemitengo inoenderana nenguva ino).

Iyi fomu yekuchengetedza yakakwana yezvikumbiro senge masystem ekutarisa, mapuratifomu ekutengesa, masisitimu ekuunganidza metric uye sensor inoti. Nzira dzekubatanidza pamwe neGrafana uye Prometheus chirongwa chinopihwa.

Chinhu chakakosha cheTimescaleDB ndiko kutsigira kwayo otomatiki kupatsanura dhata riya, pamwe nekuyerera kwedata yekuisa inongogoverwa pakati pematafura akapatsanurwa uye kuti zvikamu zvinogadzirwa zvinoenderana nenguva (chikamu chimwe nechimwe chinochengeta dhata kwenguva yakati rebei) kana zvine chekuita nekiyi yekumanikidza.

Main makuru maficha muTimescaleDB 2.0

Mune iyi vhezheni itsva kumisikidzwa kutsva kwekuenderera mberi kuchiitwa mabasa kunoitwa Vanokutendera iwe kuramba uchingowedzera data rinouya munguva chaiyo (ivo vakafanana neakashongedzwa PostgreSQL maonero, asi akasiyana mukuti ivo vanopa otomatiki kuverenga kweye mhinduro yemubvunzo kumashure sezvo data rinosvika kana shanduko).

Kuitwa kutsva inosimbiswa neshanduko muAPI, iyo yava kupatsanura zvakajeka mabasa nemitemo yekubatanidza, ichikubvumidza iwe kuti ushandise maficha senge ekumisikidza nemaoko imwe nhanho mune yakaunganidzwa maonero (semuenzaniso, iwe unogona otomatiki kuverengera data nyowani, asi siya dzekare dhata renhoroondo yekumisikidza manyore). Shanduko idzi dzichaitawo kuti zvikwanise kuitika mune ramangwana kuita rutsigiro rwemabasa akagoverwa kana uchinge uchishanda nemazhinji node.

Imwe shanduko yakakosha ndeye tsigiro yezviitiko zvinotsanangurwa nemushandisi (UDA, Mushandisi Anotsanangurwa Chiito) kuita mashandiro nemaitiro pane chirongwa yakanyorwa nemitauro inopokana. Chinhu chitsva chakakodzera kuita nguva nenguva mabasa asina kufukidzwa neanenge aripo masimba ekubatanidza marongero (stale data kuchenesa, kumanikidza, uye kuenderera kuunganidzwa).

Yakawedzerwa rutsigiro rwekuparadzirwa hypertext, ichibvumira kuchengetedza kuti ipararire munzvimbo dzakawanda ne TimescaleDB. Iyo TimescaleDB-yakavakirwa sango yekugadziriswa inosanganisira imwe yekuwana node uye akawanda ekuchengetedza node. Zvese zvikumbiro kune zvakagoverwa hypertext zvinonongedzwa kune yekuwana node uye zvobva zvagoverwa pakati penhamba dzekuchengetedza.
Tsigiro yemawonero matsva eruzivo yakawedzerwa, ichikubvumidza iwe kuti uwane ruzivo nezve hypertext, masango masumbu, tambo, marongero, uye chirongwa chekutanga basa.

Maitiro ekuisa TimescaleDB paLinux?

Kune avo vanofarira kukwanisa kuisa TimescaleDB pane yako systemIvo vanogona kuzviita nekutevera rairo dzatinogovana pazasi.

Panyaya yeavo vari Vashandisi veUbuntu:

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

Munyaya ye 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

Iye zvino isu tichaenda kunogadzira dhatabhesi ne:

sudo timescaledb-tune

Pano akasiyana masisitimu anogona kuitwa, iyo yaunogona kubvunza Mune inotevera chinongedzo. 

Pakupera, ingotangazve sevhisi:

sudo service postgresql restart

 


Izvo zviri muchinyorwa zvinoomerera pamisimboti yedu ye tsika dzekunyora. Kuti utaure chikanganiso tinya pano.

Iva wekutanga kutaura

Siya yako yekutaura

Your kero e havazobvumirwi ichibudiswa.

*

*

  1. Inotarisira data: AB Internet Networks 2008 SL
  2. Chinangwa cheiyo data: Kudzora SPAM, manejimendi manejimendi.
  3. Legitimation: Kubvuma kwako
  4. Kutaurirana kwedata
  5. Dhata yekuchengetedza: Dhatabhesi inobatwa neOccentus Networks (EU)
  6. Kodzero: Panguva ipi neipi iwe unogona kudzora, kupora uye kudzima ruzivo rwako