Yadda ake Sanya dbWatch don Kula da Ayyukan MySQL a cikin Linux

dbWatch mai ƙarfi ne, dandamali da yawa, cikakken fasali, da kuma kayan aikin sarrafa bayanai na SQL na masana'antu wanda ke ba ku cikakken iko akan abubuwan bayanan ku da albarkatun tsarin. Yana da ƙima sosai, amintacce, kuma an tsara shi don sarrafa manyan gonakin bayanai.

Ga wasu mahimman abubuwan da ke cikinsa:

• Yana goyan bayan tsarin bayanai da yawa da suka haɗa da PostgreSQL, MySQL, Oracle, MS SQL, Sybase, da ƙari.
• Yana da ƙananan sawun ƙafa da ƙananan buƙatun albarkatun kayan masarufi.
• Yana goyan bayan saka idanu da yawa a cikin ra'ayi ɗaya.
• Yana ba ku damar rarraba, rukuni, tace, da kuma saka sunaye zuwa sabobin da ƙungiyoyi don daidaita abin da kuke gani.
• Yana goyan bayan aikin sa ido, lokacin aiki, kaya, haɗin kai, sararin diski da aka yi amfani da shi, ƙimar girma, duban tebur, karatun ma'ana, ƙimar bugun cache, da ƙari mai yawa.
• Yana ba da izinin sarrafa duk ayyukan sa ido da ayyukan kulawa na yau da kullun.
• Yana ba da izinin ƙirƙirar dashboards na al'ada da rahotanni don saka idanu akan aiki.
• Yana ba ku damar yin tambayoyin SQL akan kowace uwar garken bayanai.
• Yana ba ku damar canzawa cikin sauƙi daga yanayin sa ido zuwa yanayin sarrafa bayanai.
• Hakanan yana goyan bayan haɗin gwiwar uwar garken ta hanyar cikakkun rahotanni da ra'ayoyi.
• Yana goyan bayan rahoton lasisin uwar garken bayanai don taimaka muku shirya da guje wa abubuwan mamaki, misali, cikakken rahoton lasisin bayanan Oracle.
• Game da tsaro, yana goyan bayan rufaffiyar haɗin kai da takaddun shaida, bayanan shiga na tushen rawar, kuma yana goyan bayan tsarin tantancewa na Active Directory da Kerberos, da sauran fasaloli da yawa.

Don amfani da dbWatch, kuna buƙatar ɗaya daga cikin nau'ikan lasisi masu zuwa:

• Gwaji ko lasisin haɓakawa - babu aikin kulawa ko tallafin gungu.
• Lasisi na yau da kullun don kumburi ɗaya - an yi nufin yanayin samarwa.
• Lasisi na yau da kullun tare da tallafin gungu - an yi nufin yanayin samarwa.

Don manyan ayyukan kasuwanci, zaku iya zuwa dbWatch Enterprise wanda aka yi niyya don buƙatu masu girma. Bayan haka, dbWatch Essentials da dbWatch Professional suma suna samuwa don ƙananan mahalli, duka suna jigilar kaya tare da mafita iri ɗaya mai sauƙin amfani, amma tare da ƙarancin abubuwan ci gaba kuma a ƙaramin farashi.

dbWatch mafi ƙarancin buƙatun tsarin:

• 8 GB RAM
• 1 GB sararin diski
• mafi ƙanƙara 2, bayar da shawarar 4 cores

A cikin wannan jagorar, za mu nuna yadda ake shigar da kunshin dbWatch da tura tsarin dbWatch don saka idanu akan bayanan MySQL. Don wannan jagorar, za mu yi amfani da gwajin ko lasisin haɓaka don sigar gwaji na dbWatch.

Shigar da dbWatch - Kulawa da Bayanai a cikin Linux

Da farko, fara da ƙirƙirar kundin adireshi wanda za a adana fayilolin dbWatch akan tsarin, tsoho shine /usr/local/dbWatch.

Sannan kama umarnin wget, cire shi, sanya rubutun aiwatarwa, kuma gudanar da shi (tuna shigar da kalmar wucewa lokacin da aka sa ku), kamar haka:

$ 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 

Da zarar aikace-aikacen mai sakawa dbWatch ya bayyana, danna Next don ci gaba.

Danna Gaba don matsawa zuwa mataki na gaba. Lura cewa idan kuna son haɓaka shigarwar dbWatch data kasance, duba zaɓin Haɓaka shigarwa data kasance.

Sannan saita tashar tashar dbWatch uwar garken zai saurara a kunne ko barin tsohuwar tashar jiragen ruwa wacce ita ce 7099 kuma danna Next.

Na gaba, saita tsohuwar kalmar sirrin mai amfani da uwar garken dbWatch.

Yanzu shigar da maɓallin lasisi. Idan kuna son ci gaba da gwada dbWatch (a cikin wannan yanayin zai gudana ƙarƙashin lasisin da ba na kasuwanci ba), danna Next.

Na gaba, karanta kuma karɓi yarjejeniyar lasisin dbWatch kamar yadda aka nuna a hoton allo. Kuma danna Next don ci gaba. A cikin matakin da ya biyo baya, zaku iya ci gaba tare da ainihin shigarwar fayilolin fakitin dbWatch akan tsarin, ta danna Next.

Jira tsarin shigarwa don kammala. Da zarar ya samu, za ku ga sakon taya murna kamar yadda aka nuna a hoto na gaba. Danna Gaba don ci gaba.

Fara uwar garken dbWatch ta barin zaɓin Fara dbWatch Monitor da aka duba.

Na gaba, saita haɗin kai zuwa cibiyar sarrafa bayanai na dbWatch ta hanyar shiga azaman mai amfani. Shigar da kalmar sirrin mai amfani da admin da aka kirkira a baya kuma danna Login.

Saita dbWatch don Saka idanu MySQL Database

Bayan shiga cikin nasara, taga zai tashi don ƙara misali na bayanai. Zaɓi MySQL daga zaɓuɓɓukan bayanan da ake da su, danna Ƙara Misalin Bayanai kuma danna Gaba.

Ƙayyade suna don misalin MySQL. Hakanan, zaɓi rukuni wanda misalin ya kasance (samuwa zaɓuɓɓukan samarwa, Gwaji, da haɓakawa). Sannan duba zabin Monitoring kuma danna Next.

Na gaba, haɗa zuwa bayanan MySQL azaman mai amfani na gudanarwa kamar tsoho tushen mai amfani. Shigar da mai masaukin bayanai, sunan mai amfani, kalmar sirrin mai amfani, da tashar jiragen ruwa. Sannan danna Next don ci gaba.

dbWatch yana buƙatar rumbun adana bayanai don adana bayanansa (kamar ayyuka da faɗakarwa game da yanayin bayanai da sauran bayanan da ke da alaƙa). Shigar da bayanai don amfani da dbWatch kuma saita sunan mai amfani da kalmar wucewa. Kuna iya barin tsoffin ƙimar. Sannan danna Next don baiwa mai sakawa damar ƙirƙirar ƙayyadaddun bayanai da mai amfani.

Na gaba, zaɓi ayyuka da faɗakarwa da kuke son girka kuma danna Next.

A wannan gaba, zaku iya shigar da injin dbWatch akan uwar garken bayanan MySQL ta danna Next.

Da zarar an gama shigarwa. Danna Ok don fara saka idanu da sarrafa bayanan MySQL ta amfani da dbWatch.

Taya murna! Yanzu kun yi nasarar shigar da kafa tsarin kulawa da tsarin sarrafa bayanai na dbWatch. Don ƙarin bayani, duba gidan yanar gizon dbWatch.