MySQL l\u00e0 m\u1ed9t h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u \u0111\u01a1n v\u1ecb s\u1eed d\u1ee5ng. N\u00f3 v\u00f4 c\u00f9ng quan tr\u1ecdng ph\u1ee5c v\u1ee5 vi\u1ec7c \u0111\u1ecdc ghi d\u1eef li\u1ec7u cho c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c. Ch\u00ednh v\u00ec v\u1eady gi\u00e1m s\u00e1t MySQL l\u00e0 m\u1ed9t vi\u1ec7c l\u00e0m v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Trong b\u00e0i vi\u1ebft n\u00e0y Onet<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ec3 gi\u00e1m s\u00e1t MySQL tr\u00ean h\u1ec7 th\u1ed1ng gi\u00e1m s\u00e1t Checkmk.<\/p>\n

<\/span> <\/p>\n

C\u00e0i \u0111\u1eb7t<\/h2>\n

B\u01b0\u1edbc 1: C\u00e0i \u0111\u1eb7t checkmk agent<\/h3>\n

Tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t checkmk agent tr\u00ean m\u00e1y ch\u1ee7 \u0111ang ch\u1ea1y d\u1ecbch v\u1ee5 MySQL. N\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch c\u00e0i \u0111\u1eb7t b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o t\u1ea1i \u0111\u00e2y<\/a>.<\/p>\n

B\u01b0\u1edbc 2: C\u1ea5u h\u00ecnh MySQL<\/h3>\n

B\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t user mysql d\u00f9ng cho vi\u1ec7c gi\u00e1m s\u00e1t<\/p>\n

MariaDB [(none)]> GRANT SELECT, SHOW DATABASES ON *.* TO 'mysqlmonitor'@'localhost' IDENTIFIED BY 'mysqlmonitor';<\/code><\/pre>\n
Khai b\u00e1o th\u00f4ng tin c\u1ee7a user d\u00f9ng \u0111\u1ec3 gi\u00e1m s\u00e1t v\u00e0o file mysql.cfg<\/em><\/p>\n
cat <<EOF > \/etc\/check_mk\/mysql.cfg [client] user=mysqlmonitor password=mysqlmonitor EOF<\/code><\/pre>\n
Thay \u0111\u1ed5i quy\u1ec1n cho file v\u1eeba t\u1ea1o \u0111\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng n\u1ebfu kh\u00f4ng ph\u1ea3i user root<\/em> th\u00ec s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p s\u1eeda file n\u00e0y<\/p>\n
chmod 400 \/etc\/check_mk\/mysql.cfg<\/code><\/pre>\n
B\u01b0\u1edbc 3: Copy file plugin t\u1eeb checkmk server sang m\u00e1y ch\u1ee7 mysql<\/h3>\n
Truy c\u1eadp v\u00e0o checkmk server \u0111\u1ec3 copy file plugin gi\u00e1m s\u00e1t mysql sang b\u00ean m\u00e1y \u0111ang ch\u1ea1y mysql<\/p>\n
scp \/opt\/omd\/versions\/1.6.0p10.cre\/share\/check_mk\/agents\/plugins\/mk_mysql [email protected]:\/usr\/lib\/check_mk_agent\/plugins<\/code><\/pre>\n
Trong \u0111\u00f3 10.10.35.196<\/code> l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a m\u00e1y ch\u1ea1y mysql<\/p>\n
B\u01b0\u1edbc 4: Th\u1ef1c hi\u1ec7n th\u00eam service tr\u00ean WATO<\/h3>\n
B\u00e2y gi\u1edd truy c\u1eadp v\u00e0o Web UI \u0111\u1ec3 th\u1ef1c hi\u1ec7n discovery c\u00e1c d\u1ecbch v\u1ee5<\/p>\n
Th\u1ef1c hi\u1ec7n discovery \u0111\u1ec3 th\u00eam c\u00e1c d\u1ecbch v\u1ee5 m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o gi\u00e1m s\u00e1t<\/p>\n
Ta th\u1ea5y c\u00f3 6 d\u1ecbch v\u1ee5 m\u1edbi \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam<\/p>\n
C\u1eadp nh\u1eadt thay \u0111\u1ed5i<\/p>\n
Ta \u0111\u00e3 c\u00f3 th\u1ec3 gi\u00e1m s\u00e1t MySQL tr\u00ean checkmk<\/p>\n
\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 gi\u00e1m s\u00e1t d\u1ecbch v\u1ee5 MySQL tr\u00ean h\u1ec7 th\u1ed1ng gi\u00e1m s\u00e1t Checkmk. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c v\u1ec1 checkmk t\u1ea1i \u0111\u00e2y<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL l\u00e0 m\u1ed9t h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u \u0111\u01a1n v\u1ecb s\u1eed d\u1ee5ng. N\u00f3 v\u00f4 c\u00f9ng quan tr\u1ecdng ph\u1ee5c v\u1ee5 vi\u1ec7c \u0111\u1ecdc ghi d\u1eef li\u1ec7u cho c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c. Ch\u00ednh v\u00ec v\u1eady gi\u00e1m s\u00e1t MySQL l\u00e0 m\u1ed9t vi\u1ec7c l\u00e0m v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Trong b\u00e0i vi\u1ebft n\u00e0y […]<\/p>\n","protected":false},"author":1,"featured_media":149901,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[276],"tags":[],"_links":{"self":[{"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/posts\/149900"}],"collection":[{"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/comments?post=149900"}],"version-history":[{"count":0,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/posts\/149900\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/media\/149901"}],"wp:attachment":[{"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/media?parent=149900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/categories?post=149900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onet.com.vn\/wp-json\/wp\/v2\/tags?post=149900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}