Otu esi nyochaa MySQL/MariaDB ọdụ data site na iji Netdata na CentOS 7

Netdata bụ ebe mepere emepe n'efu, dị mfe ma nwee ike ịgbatị, arụmọrụ sistemụ yana ngwa nleba anya ahụike maka sistemụ Unix dị ka Linux, FreeBSD na MacOS. Ọ na-achịkọta metrik dị iche iche ma na-ahụ ha anya, na-enye gị ohere ilele ọrụ na sistemụ gị. Ọ na-akwado plugins dị iche iche maka nyochaa ọkwa sistemụ ugbu a, ngwa na-agba ọsọ, yana ọrụ dị ka MySQL/MariaDB nkesa nchekwa data, yana ọtụtụ ndị ọzọ.

Otu esi enyocha arụmọrụ Apache Iji Netdata na CentOS 7
Otu esi eleba anya na arụmọrụ Nginx Iji Netdata na CentOS 7

N'isiokwu a, anyị ga-akọwa otú e si nyochaa MySQL/MariaDB nchekwa data nkesa arụmọrụ iji Netdata na CentOS 7 ma ọ bụ RHEL 7 nkesa.

Na njedebe nke isiokwu a, ị ga-enwe ike ilele anya nke bandwit, ajụjụ, njikwa, mkpọchi, okwu, nwa oge, njikọ, binlog, eri metrics nke MySQL/MariaDB nchekwa data nkesa site na netdata nlekota oru web interface.

Ihe nkesa RHEL 7 nwere obere nwụnye.
Nwụnye nchekwa data MariaDB.

Kwụpụ 1: Wụnye MariaDB Database Server na CentOS 7

1. Mmalite mbụ site na ịgbakwunye MariaDB YUM ebe nchekwa ngwanrọ na sistemụ gị.

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

Ugbu a tinye ahịrị ndị a na faịlụ a.

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

2. Ọzọ, wụnye ngwugwu MariaDB, dị ka ndị a.

# yum install MariaDB-server MariaDB-client -y

3. Ozugbo ị wụnyere nchekwa data MariaDB, malite daemon nkesa nchekwa data maka oge a, ma mee ka ọ malite na akpaghị aka na sistemụ buut, ma gosi na ọ dị elu na-arụ ọrụ site na iji iwu ndị a.

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

4. Site na ndabara, nrụnye MySQL enweghị nchekwa na ịkwesịrị ịchekwa ya site na iji edemede nchekwa nke na-abịa na ngwugwu ọnụọgụ abụọ. A ga-ajụ gị ka ịtọọ paswọọdụ mgbọrọgwụ, tọọ ya wee gaba n'ihu.

# mysql_secure_installation

Ozugbo i debere okwuntughe mgbọrọgwụ, tinye ee/y n'ajụjụ ndị ọzọ iji wepụ ndị ọrụ na-amaghị aha, kwenye nbanye nbanye n'ime oge, wepụ data nchekwa data na ịnweta ya, yana bugharịa tebụl ihe ùgwù ugbu a. .

5. Iji nakọta ọnụ ọgụgụ arụmọrụ site na MySQL/MariaDB nchekwa data nkesa, netdata kwesịrị jikọọ na ihe nkesa nchekwa data. Yabụ mepụta onye ọrụ nchekwa data akpọrọ \netdata iji nye ya ikike ijikọ na sava nchekwa data na localhost, na-enweghị paswọọdụ.

# 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

Kwụpụ 2: Wụnye Netdata iji nyochaa arụmọrụ MySQL

6. N'ụzọ dị mma, anyị enweelarị otu edemede nke ndị na-emepụta netdata nyere, maka ịwụnye ya n'enweghị ihe mgbu site na osisi isi na github repository.

Edemede kickstarter na-ebudata edemede ọzọ maka ịchọpụta distro Linux gị; na-etinye ngwugwu usoro achọrọ maka iwulite netdata; wee budata osisi isi iyi netdata kachasị ọhụrụ; na-ewuli ma tinye ya na sistemụ gị.

Iwu a ga-enyere gị aka ịmalite edemede kickstarter, nhọrọ niile na-enye ohere maka ịwụnye ngwugwu achọrọ maka plugins netdata niile gụnyere nke MySQL/MariaDB.

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

Ọ bụrụ na ị naghị ejikwa sistemụ gị dị ka mgbọrọgwụ, a ga-akpali gị itinye paswọọdụ njirimara gị maka iwu sudo, a ga-agwakwa gị ka ị kwado ọtụtụ ọrụ site na ịpị [Tinye].

7. Ozugbo script dechara ewu na wụnye netdata, ọ ga-akpaghị aka na-amalite ọrụ netdata, na-enyere ya na-amalite na usoro buut.

8. Netdata na-ege ntị na ọdụ ụgbọ mmiri 19999 na ndabara, ị ga-eji ọdụ ụgbọ mmiri a nweta UI weebụ. Yabụ, mepee ọdụ ụgbọ mmiri na firewall sistemụ gị.

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

Kwụpụ 2: Hazie Netdata iji nyochaa MySQL/MariaDB

9. Nhazi netdata maka ngwa mgbakwunye MySQL/MariaDB bụ /etc/netdata/python.d/mysql.conf, nke edere na usoro YaML.

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

Nhazi ndabara zuru oke iji bido na nyochaa ihe nkesa nchekwa data MySQL/MariaDB gị. Ọ bụrụ na ị gụọla akwụkwọ ahụ, wee mee mgbanwe ọ bụla na faịlụ dị n'elu, ịkwesịrị ịmalitegharị ọrụ netdata iji mee mgbanwe ndị ahụ.

# systemctl restart netdata

10. Ọzọ, mepee ihe nchọgharị weebụ wee jiri URL ọ bụla na-esonụ iji nweta netdata webụ UI.

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

Site na dashboard netdata, chọọ \MySQL local na ndepụta plugins n'akụkụ aka nri, wee pịa ya ka ịmalite nyochaa sava MySQL/MariaDB gị. yana galera, dị ka egosiri na nseta ihuenyo na-esonụ.

Netdata Github nchekwa: https://github.com/firehol/netdata

Ọ gwụla! N'isiokwu a, anyị akọwala otu esi enyocha ọrụ MySQL/MariaDB nchekwa data nkesa site na iji Netdata na CentOS 7. Jiri mpempe okwu dị n'okpuru jụọ ajụjụ ma ọ bụ soro anyị kerịta echiche ndị ọzọ.