TimescaleDB, yakavhurwa sosi dhatabhesi yekuchengetedza nguva dzakateedzana data

Kuburitswa kweshanduro nyowani yeTimescaleDB 1.7 yakaziviswa, shanduro mairi yakawedzera rutsigiro rwePostgreSQL 12 yakasimbiswa, pamwe nekushandurwa kwemamwe mabasa. Kune avo vasingazive nezve TimescaleDB, vanofanira kuziva izvozvo dhatabhesi rakagadzirirwa kuchengetedza nekugadzirisa dhata nenzira yenguva dzakateedzana (zvikamu zve paramende kukosha panguva dzakapihwa nguva, rejista inoumba iyo nguva uye seti yemitengo inoenderana nenguva ino).

Iyi fomu yekuchengetedza yakakwana yezvikumbiro senge masystem ekutarisa, mapuratifomu ekutengesa masystem ekuunganidza metric uye sensor mamiriro.

Nezve TimescaleDB

Iyo TimescaleDB chirongwa inoitwa seyekuwedzera kwePostgreSQL uye inogoverwa pasi peiyo Apache 2.0 rezinesi. Imwe yekodhi ine epamberi maficha inounzwa pasi peyako yakaparadzaniswa yeTimescale rezinesi (TSL), iyo isingatenderi shanduko, inorambidza kushandiswa kwekodhi mune yechitatu-bato zvigadzirwa, uye haitenderi kushandiswa kwemahara mune dhatabhesi eruzhinji (dhatabhesi senge sevhisi ).

Chikamu chinonakidza cheTimescaleDB, ndicho icho inokutendera iwe kushandisa yakazara SQL mibvunzo kuongorora iyo yakaunganidzwa data, kusanganisa iko kusununguka kwekushandisa kunoenderana nehukama DBMS nekukwanisa uye kugona kunowanikwa mune yakasarudzika NoSQL masisitimu.

Chimiro chekuchengetedza yakagadziridzwa kuti ipe yakakwira dhata yekubatanidza mwero. Inotsigira batch kuunganidzwa kwedatha seti, ichishandisa indices yakachengetwa mu RAM, ichidzora zvine mutsindo zvikamu zvekare, kuisa zviitiko.

Chinhu chakakosha cheTimescaleDB ndiyo Tsigiro yekuparadzanisa otomatiki(chikamu) chedata rondedzero. Iyo irinouya data rwizi inogoverwa otomatiki pakati pematafura akapatsanurwa.

Zvikamu zvinogadzirwa zvinoenderana nenguva (chikamu chega chega chinochengeta dhata yeimwe nguva yenguva) kana inoenderana nekiyi yekumanikidza (semuenzaniso chinongedzo chemidziyo, nzvimbo, nezvimwewo). Matafura akapatsanurwa anogona kutambanudzwa pamadhiraivha akasiyana kuti agadzirise mashandiro.

Pamibvunzo, dhatabhesi yakakamurwa inoita kunge tafura hombe, inonzi ine hypertable. Hypertable inomiririra chaiyo matafura akapatsanurwa mune data rinouya.

Chii chitsva muTimescaleDB 1.7?

Mune iyi vhezheni nyowani rutsigiro rweiyo kusangana pamwe nePostgreSQL 12 DBMS, nepo kutsigirwa kwePostgreSQL 9.6.x uye 10.x kwakadzikiswa, kunyangwe kune Timescale 2.0 chete kutsigirwa kwePostgreSQL 11+ kuchasara.

Izvo zvakare zvinoratidzika kuti akachinja hunhu hwemibvunzo nekuenderera mberi achiitwa akaunganidzwa mabasa (kuunganidzwa kweinoramba ichipinda data munguva chaiyo).

Mibvunzo yakadaro ikozvino inosanganisa maonero akavezwa nedata richangosvika iro risati raitwa (kare, kuunganidzwa kwaingovhara data rakatogadzirwa). Hunhu hutsva hunoshandiswa kune ichangobva kugadzirwa kuenderera kuunganidzwa.

Ukuwo, mamwe epamberi data data ehupenyu hwekutonga maturusi akaendeswa kune yeruzhinji vhezheni yemagazini yekutengesa, kusanganisira kugona kuumbiridza dhata uye marongero emitemo kufambisa data rekare (rinokutendera kuti uchengete chete data razvino uye kudzima otomatiki, kuwedzera, kana kuchengetedza zvinyorwa zvekare).

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