Otu esi etinye dbWatch iji nyochaa arụmọrụ MySQL na Linux

dbWatch bụ ngwa ọrụ nchekwa data SQL siri ike, nke nwere ọtụtụ ihe, gosipụtara na ọkwa ụlọ ọrụ nke na-enye gị njikwa zuru oke na ọnọdụ nchekwa data gị na akụrụngwa sistemụ. Ọ nwere ike ịgbatị nke ukwuu, echekwara ma hazie ya maka ijikwa nnukwu ugbo nchekwa data.

Nke a bụ ụfọdụ njiri mara ya:

  • Na-akwado ọtụtụ sistemụ nchekwa data gụnyere PostgreSQL, MySQL, Oracle, MS SQL, Sybase, na ndị ọzọ.
  • O nwere obere akara ukwu yana chọrọ akụrụngwa akụrụngwa dị ala.
  • Na-akwado nlekota ọtụtụ oge n'otu nlele jikọtara ọnụ.
  • Na-enye gị ohere ịhazi, otu, nzacha, na ezipụta aha na sava na otu iji mezie ihe ị na-ahụ.
  • Na-akwado nleba anya arụmọrụ, oge ọrụ, ibu, njikọ, ohere diski eji, ọnụego uto, nyocha tebụl, ọgụgụ ezi uche dị na ya, ọnụ ọgụgụ cache hit, na ọtụtụ ndị ọzọ.
  • Na-enye ohere maka arụ ọrụ nleba anya na nhazi oge niile.
  • Na-enye ohere ịmepụta dashboards omenala yana akụkọ maka nleba anya arụmọrụ.
  • Na-enyere gị aka ịme ajụjụ SQL na sava nchekwa data ọ bụla.
  • Na-enyere gị aka ịgbanwe ngwa ngwa site na ọnọdụ nlekota gaa na ọnọdụ nchịkwa nchekwa data.
  • Nakwa akwado nkwado nkesa site na akụkọ na nlele zuru ezu.
  • Na-akwado mkpesa ikike sava nchekwa data iji nyere gị aka ịkwado ma zere ihe ịtụnanya nyocha, dịka ọmụmaatụ, mkpesa ikike nchekwa data Oracle zuru ezu.
  • N'ihe gbasara nchekwa, ọ na-akwado njikọ ezoro ezo na asambodo, profaịlụ ohere dabere na ọrụ, yana akwado sistemu nyocha Active Directory na Kerberos, yana ọtụtụ atụmatụ ndị ọzọ.

Iji jiri dbWatch, ịchọrọ otu n'ime ụdị ikike ndị a:

  • Nnwale ma ọ bụ ikike mmepe – enweghị ọrụ mmezi ma ọ bụ nkwado ụyọkọ.
  • Ikikere oge niile maka otu ọnụ – ezubere maka gburugburu nrụpụta.
  • Ikikere oge niile yana nkwado ụyọkọ - ezubere maka gburugburu nrụpụta.

Maka nnukwu ụlọ ọrụ na-ebuga, ị nwere ike ịga maka dbWatch Enterprise nke ezubere maka ihe achọrọ dị elu. E wezụga nke ahụ, dbWatch Essentials na dbWatch Professional dịkwa maka obere gburugburu, ma ụgbọ mmiri nwere otu ngwọta dị mfe iji, ma na-enwe obere atụmatụ dị elu yana na ọnụ ala dị ala.

dbWatch kacha nta sistemu chọrọ:

  • 8 GB Ram
  • Oghere diski 1 GB
  • Cores 2 kacha nta, kwado 4 cores

N'ime ntuziaka a, anyị ga-egosi otu esi etinye ngwugwu dbWatch ma tinye usoro dbWatch iji nyochaa ọdụ data MySQL. Maka ntuziaka a, anyị ga-eji ule ma ọ bụ ikike mmepe maka ụdị nnwale nke dbWatch.

Ịwụnye dbWatch - Nyochaa nchekwa data na Linux

Nke mbụ, malite site na ịmepụta ndekọ nke a ga-echekwa faịlụ dbWatch na sistemụ, ndabara bụ /usr/local/dbWatch.

Wee jide iwu wget, wepụ ya, mee ka ederede ahụ nwee ike ịme ya, wee mee ya (cheta itinye paswọọdụ gị mgbe kpaliri), dị ka ndị a:

$ sudo mkdir -p /usr/local/dbWatch
$ wget -c https://download.dbWatch.com/download/LATEST/dbWatch_unix_12_8_8.sh.bz2 --no-check-certificate
$ bzip2 -d dbWatch_unix_12_8_8.sh.bz2 
$ sudo chmod +x dbWatch_unix_12_8_8.sh 
$ sudo ./dbWatch_unix_12_8_8.sh

Ozugbo ngwa installer dbWatch gosipụtara, pịa Ọzọ ka ịga n'ihu.

Pịa Ọzọ ka ịkwaga na nzọụkwụ ọzọ. Rịba ama na ọ bụrụ na ịchọrọ ịkwalite nrụnye dbWatch dị ugbu a, lelee nhọrọ Nweta nkwalite dị adị.

Mgbe ahụ tọọ ọdụ ụgbọ mmiri dbWatch nkesa ga-ege ntị ma ọ bụ hapụ ọdụ ụgbọ mmiri nke bụ 7099 wee pịa Ọzọ.

Na-esote, tọọ paswọọdụ onye njikwa ndabara nke sava dbWatch.

Ugbu a tinye igodo ikike. Ọ bụrụ na ịchọrọ ịga n'ihu na-agbalị dbWatch (na nke a ọ ga-agba ọsọ n'okpuru ikikere na-abụghị nke azụmahịa), pịa Ọzọ.

Na-esote, gụọ ma nabata nkwekọrịta ikike dbWatch dị ka egosiri na nseta ihuenyo. Ma pịa Ọzọ ka ịga n'ihu. Na usoro na-esote, ị nwere ike ịga n'ihu na ntinye faịlụ ngwugwu dbWatch na sistemụ, site na ịpị Ọzọ.

Chere ka usoro nrụnye ga-agwụ. Ozugbo emechara, ị ga-ahụ ozi ekele dị ka egosiri na nseta ihuenyo na-esote. Pịa Ọzọ ka ịga n'ihu.

Malite ihe nkesa dbWatch site na ịhapụ nhọrọ Malite dbWatch Monitor enyocha.

Na-esote, hazie njikọ na ebe nchekwa data dbWatch site na ịbanye dị ka onye ọrụ nchịkwa. Tinye paswọọdụ onye ọrụ nke emepụtara na mbụ wee pịa Nbanye.

Tọọ dbWatch ka nyochaa MySQL database

Mgbe nbanye na-aga nke ọma, windo ga-apụta maka gị ịgbakwunye ihe atụ nchekwa data. Họrọ MySQL site na nhọrọ nchekwa data dị, pịa Tinye Database Instance wee pịa Ọzọ.

Ezipụta aha maka ihe atụ MySQL. Ọzọkwa, họrọ otu nke ihe atụ bụ nke (nhọrọ dị bụ Mmepụta, Nnwale na Mmepe). Wee lelee nhọrọ nlekota oru wee pịa Ọzọ.

Na-esote, jikọọ na MySQL nchekwa data dị ka onye ọrụ nchịkwa dị ka onye ọrụ mgbọrọgwụ ndabere. Tinye onye nnabata nchekwa data, aha njirimara, paswọọdụ onye ọrụ, na ọdụ ụgbọ mmiri. Wee pịa Ọzọ ka ịga n'ihu.

dbWatch chọrọ nchekwa data iji chekwaa data ya (dịka ọrụ na ọkwa gbasara steeti nchekwa data yana data ndị ọzọ metụtara ya). Tinye nchekwa data nke dbWatch ga-eji wee tọọ aha njirimara na paswọọdụ. Ị nwere ike hapụ ụkpụrụ ndabara. Wee pịa Ọzọ iji mee ka onye nrụnye nwee ike ịmepụta nchekwa data akọwapụtara na onye ọrụ.

Ọzọ, họrọ ihe aga-eme na ngosi nke ịchọrọ ịwụnye wee pịa Ọzọ.

N'ebe a, ị nwere ike ịwụnye dbWatch engine na ihe nkesa MySQL gị site na ịpị Ọzọ.

Ozugbo echichi zuru ezu. Pịa OK ka ịmalite nlekota na ijikwa ọdụ data MySQL gị site na iji dbWatch.

Ekele! Ị ka arụnyela nke ọma ma guzobe nchekwa data dbWatch nlekota na njikwa njikwa. Maka ozi ndị ọzọ, lelee webụsaịtị dbWatch.