Yadda ake saka idanu akan bayanan MySQL/MariaDB ta amfani da Netdata akan CentOS 7

Netdata tushen buɗe ido ne na kyauta, mai sauƙi kuma mai ƙima, aikin tsarin ainihin lokaci da aikace-aikacen sa ido kan lafiya don tsarin Unix kamar Linux, FreeBSD da MacOS. Yana tattara ma'auni daban-daban kuma yana hango su, yana ba ku damar kallon ayyukan akan tsarin ku. Yana goyan bayan plugins daban-daban don sa ido kan matsayin tsarin yanzu, aikace-aikacen da ke gudana, da ayyuka kamar uwar garken bayanan MySQL/MariaDB, da ƙari mai yawa.

1. Yadda ake Kula da Ayyukan Apache Ta Amfani da Netdata akan CentOS 7
2. Yadda ake Kula da Ayyukan Nginx Ta Amfani da Netdata akan CentOS 7

A cikin wannan labarin, zamuyi bayanin yadda ake saka idanu akan aikin uwar garken bayanan MySQL/MariaDB ta amfani da Netdata akan rarrabawar CentOS 7 ko RHEL 7.

A ƙarshen wannan labarin, za ku iya kallon abubuwan gani na bandwidth, tambayoyi, masu sarrafa, makullai, batutuwa, na ɗan lokaci, haɗin kai, binlog, ma'aunin zaren sabar bayanan MySQL/MariaDB na sabar bayanan yanar gizo na netdata.

1. Sabar RHEL 7 tare da Mafi ƙarancin shigarwa.
2. Shigar da uwar garken bayanan MariaDB.

Mataki 1: Sanya MariaDB Database Server akan CentOS 7

1. Fara farawa ta hanyar ƙara ma'ajiyar software na MariaDB YUM zuwa tsarin ku.

# vim /etc/yum.repos.d/MariaDB.repo

Yanzu ƙara layin masu zuwa a cikin wannan fayil ɗin.

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

2. Na gaba, shigar da kunshin MariaDB, kamar haka.

# yum install MariaDB-server MariaDB-client -y

3. Da zarar ka shigar da bayanan MariaDB, sai ka fara daemon uwar garken bayanai na yanzu, kuma ka ba shi damar farawa kai tsaye a tsarin boot, kuma tabbatar da cewa yana aiki da bin umarni.

# systemctl start mariadb
# systemctl enable mariadb
# systemctl status mariadb

4. Ta hanyar tsoho, shigarwa na MySQL ba shi da tsaro kuma kana buƙatar kiyaye shi ta hanyar tafiyar da rubutun tsaro wanda ya zo tare da kunshin binary. Za a umarce ku don saita tushen kalmar sirri, saita shi kuma ci gaba.

# mysql_secure_installation

Da zarar ka saita tushen kalmar sirri, shigar da yes/y zuwa ga sauran tambayoyin don cire masu amfani da ba a san sunansu ba, hana tushen shiga daga nesa, cire bayanan gwaji da samun damar shiga, da kuma sake loda teburin gata yanzu. .

5. Don tattara ƙididdiga na aiki daga uwar garken bayanan MySQL/MariaDB, netdata yana buƙatar haɗi zuwa uwar garken bayanai. Don haka ƙirƙiri mai amfani da bayanai mai suna \netdata don ba shi ikon haɗi zuwa uwar garken bayanan akan localhost, ba tare da kalmar sirri ba.

# mysql -u root -p
MariaDB [(none)]> CREATE USER 'netdata'@'localhost';
MariaDB [(none)]> GRANT USAGE on *.* to 'netdata'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit

Mataki 2: Shigar da Netdata don Saka idanu Ayyukan MySQL

6. Sa'ar al'amarin shine, mun riga mun sami rubutun layi ɗaya wanda masu haɓaka netdata suka samar, don shigar da shi ba tare da wahala ba daga bishiyar tushen akan ma'ajin github.

Rubutun kickstarter yana sauke wani rubutun don gano distro Linux ɗin ku; shigar da fakitin tsarin da ake buƙata don gina netdata; sannan zazzage sabuwar bishiyar tushen netdata; yana ginawa da shigar da shi akan tsarin ku.

Wannan umarnin zai taimaka muku ƙaddamar da rubutun kickstarter, zaɓin duk yana ba da damar shigar da fakitin da ake buƙata don duk plugins na netdata gami da na MySQL/MariaDB.

# bash <(curl -Ss https://my-netdata.io/kickstart.sh) all

Idan ba ku sarrafa tsarin ku azaman tushen ba, za a sa ku shigar da kalmar wucewa ta mai amfani don umarnin sudo, sannan kuma za a umarce ku da ku tabbatar da ayyuka da yawa ta danna [Enter].

7. Da zarar rubutun ya kammala ginawa da shigar da netdata, zai fara aikin netdata kai tsaye, kuma yana ba shi damar farawa daga tsarin boot.

8. Netdata yana saurare akan tashar jiragen ruwa 19999 ta tsohuwa, zaku yi amfani da wannan tashar jiragen ruwa don shiga UI na yanar gizo. Don haka, buɗe tashar jiragen ruwa akan tsarin Tacewar zaɓinku.

# firewall-cmd --permanent --add-port=19999/tcp
# firewall-cmd --reload 

Mataki 2: Sanya Netdata don Saka idanu MySQL/MariaDB

9. Tsarin netdata don MySQL/MariaDB plugin shine /etc/netdata/python.d/mysql.conf, wanda aka rubuta a cikin tsarin YaML.

# vim /etc/netdata/python.d/mysql.conf

Tsarin tsoho ya isa kawai don farawa tare da sa ido kan uwar garken bayanan MySQL/MariaDB. Idan kun karanta takaddun, kuma kun yi kowane canje-canje ga fayil ɗin da ke sama, kuna buƙatar sake kunna sabis ɗin netdata don aiwatar da canje-canje.

# systemctl restart netdata

10. Na gaba, buɗe mai binciken gidan yanar gizo kuma yi amfani da kowane URL mai zuwa don samun damar UI na yanar gizo na netdata.

http://domain_name:19999
OR
http://SERVER_IP:19999

Daga netdata dashboard, bincika \MySQL local a gefen dama na jerin plugins, kuma danna kan shi don fara sa ido kan uwar garken MySQL/MariaDB. Za ku sami damar kallon abubuwan gani na bandwidth, tambayoyi, masu sarrafa, makullai, haka kuma galera, kamar yadda aka nuna a hoton da ke gaba.

Wurin ajiya na Github Netdata: https://github.com/firehol/netdata

Shi ke nan! A cikin wannan labarin, mun bayyana yadda ake saka idanu akan aikin uwar garken bayanan MySQL/MariaDB ta amfani da Netdata akan CentOS 7. Yi amfani da sigar sharhi da ke ƙasa don yin tambayoyi ko raba ƙarin tunani tare da mu.