Ukukhishwa kwe-DBMS TimescaleDB 2.0 kushicilelwe, inguqulo lapho izinguquko zengezwe kwilayisense ye-TSL yokunikeza abasebenzisi amalungelo amaningi futhi vumela ukusetshenziswa kwamahhala kwazo zonke izici zenguqulo yebhizinisi, kufaka phakathi ukuminyaniswa, ukusatshalaliswa kwesitoreji kuwo wonke ama-node amaningi nokuhlanganiswa okuqhubekayo. Ilayisensi isuse imikhawulo ebangeni lomhlangano womphakathi, inikezwe ilungelo lokwenza ngcono nezinguquko, isuse izibopho ezikhokhelwayo (zonke izici ezazinikezwa phambilini kuTimescaleDB Enterprise zidluliselwe kuhlelo lomphakathi).
Kulabo abangajwayelene neTimescaleDB, kufanele ukwazi lokho isetshenziswa njengesandiso sePostgreSQLyakhelwe ukugcina nokucubungula idatha ngendlela yochungechunge lwesikhathi (izingxenye zamanani wepharamitha ngezikhathi ezithile, irekhodi lakha isikhathi neqoqo lamanani ahambelana nalesi sikhathi).
Leli fomu lokugcina ilungele izinhlelo zokusebenza ezinjengezinhlelo zokuqapha, izinkundla zokuhweba, amasistimu wokuqoqa amamethrikhi kanye nenzwa ithi. Izindlela zokuhlanganisa nephrojekthi yeGrafana ne-Prometheus zinikeziwe.
Isici esiyinhloko seTimescaleDB ukusekelwa kwaso ukwahlukaniswa okuzenzakalelayo kwedatha yamalungu, kanye nokuhamba kwedatha yokufaka kusatshalaliswa ngokuzenzakalela phakathi kwamatafula ahlukanisiwe nokuthi izigaba zenziwa ngokwesikhathi (isigaba ngasinye sigcina idatha isikhathi esithile) noma maqondana nokhiye wokuphikisana.
Izici ezintsha eziyinhloko ku-TimescaleDB 2.0
Kule nguqulo entsha ukuqaliswa okusha kwemisebenzi eyenziwa ngokuqhubekayo kuhlongozwa Ziyakuvumela ukuthi uhlale ungeza idatha engenayo ngesikhathi sangempela (zifana nokubukwa okwenziwe ngokomzimba kwePostgreSQL, kepha ziyehluka ngoba zinikeza ukubalwa okuzenzakalelayo kwemiphumela yombuzo ngemuva njengoba idatha ifika noma ishintsha).
Ukuqaliswa okusha kuqokonyiswa ushintsho ku-API, manje esehlukanisa ngokusobala imisebenzi nemithetho yokuhlanganisa, ekuvumela ukuthi usebenzise izici ezifana nokubuyekeza ngesandla ibanga elithile ekubukweni okuhlanganisiwe (ngokwesibonelo, ungazenzela imininingwane emisha ngokuzenzakalela, kepha ushiye idatha yakudala yomlando yokuyibuyekeza mathupha). Izinguquko zizophinde zenze ukuthi esikhathini esizayo kuqaliswe ukwesekwa kwemisebenzi esatshalalisiwe lapho kusebenza ama-node amaningi.
Olunye ushintsho olubalulekile yi- ukusekelwa kwezenzo ezichazwe ngumsebenzisi (UDA, Isenzo Esichazwe Umsebenzisi) ukwenza imisebenzi nezinqubo kusheduli ebhalwe ngezilimi ezingacindezeli. Isici esisha silungele ukwenza imisebenzi yezikhathi ezithile engafakiwe kuzinqubomgomo ezikhona zokuxhuma izilawuli (ukuhlanzwa kwedatha, ukucindezelwa, nokuhlanganiswa okuqhubekayo).
Kungeziwe ukusekelwa kwe-hypertext esatshalalisiwe, ivumela isitoreji ukuthi sisabalale kuma-node amaningi nge-TimescaleDB. Ukucushwa kweqoqo le-TimescaleDB kufaka phakathi i-node eyodwa yokufinyelela nezindawo eziningi zokugcina. Zonke izicelo kwi-hypertext esatshalaliswa ziqondiswe kunodi yokufinyelela bese zisatshalaliswa phakathi kwezindawo zokugcina.
Kungezwe ukusekelwa kwemibono emisha yolwazi, ekuvumela ukuthi uthole ulwazi mayelana ne-hypertext, ama-cluster node, izintambo, izinqubomgomo, kanye nohlelo lokuqalisa umsebenzi.
Ungayifaka kanjani i-TimescaleDB ku-Linux?
Okwalabo abanentshisekelo ukuze ukwazi ukufaka i-TimescaleDB kusistimu yakhoBangakwenza lokho ngokulandela imiyalo esabelana ngayo ngezansi.
Endabeni yalabo abakhona Abasebenzisi be-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
Endabeni 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
I-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
Manje sizomisa i-database nge:
sudo timescaledb-tune
Lapha ukucushwa okuhlukahlukene kungenziwa, ongabonisana nayo Kulesi sixhumanisi esilandelayo.
Ekugcineni, vele uqale kabusha insiza:
sudo service postgresql restart