Siideynta nooca cusub ee TimescaleDB 1.7 ayaa lagu dhawaaqay, nooca ku jira ku darey taageerada PostgreSQL 12 waa la muujiyey, iyo sidoo kale wax ka beddelka shaqooyinka qaarkood. Kuwo aan aqoon WakhtigaDB, waa inay ogaadaan taas waa xog ururin loogu talagalay in lagu kaydiyo laguna socodsiiyo xogta qaab taxane ah (qaybaha qiyamka cabbirka ee muddooyinka la siiyay, diiwaanka ayaa sameeya waqtiga iyo qiimeyaal u dhigma waqtigan).
Qaabkan keydinta waa mid ku habboon codsiyada sida nidaamyada kormeerka, goobaha ganacsiga, nidaamyada lagu ururiyo xaaladda dareenka iyo cabirrada.
Ku saabsan TimescaleDB
Mashruuca TimescaleDB waxaa loo hirgaliyay kordhin PostgreSQL ah waxaana loo qaybiyaa liisanka Apache 2.0. Qaar ka mid ah koodhka leh astaamaha horumarsan waxaa lagu bixiyaa shati gaar ah oo gaar loo leeyahay oo loo yaqaan 'Timescale licence' (TSL), kaas oo aan oggolaanaynin isbeddelada, mamnuucaya adeegsiga koodhka alaabada dhinac saddexaad, mana oggolaanayo in si bilaash ah loogu isticmaalo keydka xogta (daruuriga sida adeegga ).
Qaybta xiisaha leh ee TimescaleDB, waa taas wuxuu kuu ogolaanayaa inaad adeegsato weydiimaha SQL oo buuxa si aad u falanqeyso xogta la ururiyey, isku darka sahlanaanta adeegsiga asalka u ah DBMS isku xirnaanta iyo iskudhafka iyo awoodaha ay kujirto nidaamyada gaarka ah ee NoSQL.
Qaab dhismeedka keydinta waxaa loo habeeyay si loo bixiyo sicirka isu geynta xogta. Waxay taageertaa noocyada xog uruurinta ee dufcadda, iyadoo la adeegsanayo tusmooyinka ku keydsan RAM, si gadaal-u-socod ah ugu raraya qeybaha taariikhiga ah, adeegsiga macaamillada
Muuqaalka ugu muhiimsan ee TimescaleDB waa taageerada qaybinta otomaatiga ahqayb (qayb) ka mid ah soo diyaarinta xogta. Xogta soo socota ee soo socota ayaa si otomaatig ah loogu qaybiyaa miisaska kala qaybsan.
Qeybaha waxaa loo abuuray iyada oo ku saleysan waqtiga (qeyb kasta waxay keydineysaa xogta muddo cayiman) ama waxay ku xiran tahay fure aan macquul ahayn (tusaale, qalabka aqoonsiga, goobta, iwm.). Miisaska qaybsan ayaa lagu kala qaadi karaa wadayaal kala duwan si loo hagaajiyo waxqabadka.
Weydiimaha, keydka macluumaadka lakala qaybiyay wuxuu umuuqdaa miis weyn, oo loo yaqaan 'hypertable'. Dhiirrigelintu waa matalaad muuqaal ah oo miisas badan oo kala duwan oo xogta soo socota lagu uruurinayo.
Maxaa ku cusub TimescaleDB 1.7?
Qaabkan cusub taageerada loogu talagalay dhexgalka PostgreSQL 12 DBMS, halka taageerada PostgreSQL 9.6.x iyo 10.x hoos loo dhigay, inkasta oo Timescale 2.0 kaliya taageerada PostgreSQL 11 + ay baaqi tahay.
Waxaa kaloo la iftiimiyay ku beddelay habdhaqanka weydiimaha iyadoo si joogto ah loo fulinayo shaqooyinka isu geynta (isu geynta xogta joogtada ah ee soo socota waqtiga dhabta ah).
Weydiimaha noocan oo kale ah ayaa hadda isku daraya aragtiyada la helay iyo xogta dhowaan timid ee aan weli hirgelin (horey, isu-geynta kaliya ayaa la daboolay xogta horey loo soo saaray). Dabeecadda cusub waxaa loo adeegsadaa isu-geynta joogtada ah ee cusub ee la abuuray.
Dhinaca kale, qaar ka mid ah aaladaha casriga ah ee maaraynta nolol-socodka xogta ayaa loo raray nooca bulshada ee daabacaadda ganacsiga, oo ay kujirto awoodda dib-u-ururinta xogta iyo siyaasadaha geeddi-socodka si looga takhaluso xogta duugoobay (waxay kuu oggolaaneysaa inaad kaydiso keliya xogta hadda jirta isla markaana aad si toos ah u tirtirto, ku darto, ama aad u kaydiso diiwaanada duugoobay).
Sidee loo rakibaa TimescaleDB Linux?
Kuwa daneynaya si aad u awoodo inaad ku rakibto TimescaleDB nidaamkaagaWaxay ku samayn karaan iyagoo raacaya tilmaamaha aan hoos ku wadaagno.
Marka laga hadlayo kuwa Isticmaalayaasha Ubuntu:
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
Marka laga hadlayo 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
Hadda waxaan dooneynaa inaan ku keydisano keydka macluumaadka:
sudo timescaledb-tune
Halkan qaabeynta kala duwan ayaa la samayn karaa, oo aad kala tashan karto Xiriirka soo socda.
Dhamaadka, kaliya dib u bilaw adeegga:
sudo service postgresql restart