{"id":1258,"date":"2018-08-12T01:05:37","date_gmt":"2018-08-11T18:05:37","guid":{"rendered":"https:\/\/lagonet.vn\/?p=1258"},"modified":"2018-08-12T01:05:37","modified_gmt":"2018-08-11T18:05:37","slug":"grafana","status":"publish","type":"post","link":"https:\/\/kb.lagonet.vn\/?p=1258","title":{"rendered":"GRAFANA"},"content":{"rendered":"<p>##M\u1ee5c l\u1ee5c<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#model\">1. Grafana logical model<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#dashboard\">2. Grafana Dashboard<\/a>\n<ul>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#pie\">2.1. Pie Chart<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#graph\">2.2 Graph<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#single\">2.3 Singlestat<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md#password\">3. Reset admin password<\/a><\/li>\n<\/ul>\n<p><a name=\"user-content-model\"><\/a>###1. M\u00f4 h\u00ecnh logic Grafana k\u1ebft h\u1ee3p Graphite v\u00e0 Collectd\u00a0<a href=\"https:\/\/camo.githubusercontent.com\/823d66ffd2ebe4720921fee9b7326decdff8bc4b\/687474703a2f2f692e696d6775722e636f6d2f35475758574c422e706e67\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/camo.githubusercontent.com\/823d66ffd2ebe4720921fee9b7326decdff8bc4b\/687474703a2f2f692e696d6775722e636f6d2f35475758574c422e706e67\" data-canonical-src=\"http:\/\/i.imgur.com\/5GWXWLB.png\" \/><\/a><\/p>\n<p><a name=\"user-content-dashboard\"><\/a>###2. H\u01b0\u1edbng d\u1eabn t\u1ea1o Dashboard gi\u00e1m s\u00e1t c\u00e1c host tr\u00ean Grafana 3.0 K\u1ecbch b\u1ea3n : \u0110\u00e3 c\u00f3 s\u1eb5n c\u00e1c host \u0111\u01b0\u1ee3c gi\u00e1m s\u00e1t b\u1edfi Graphite v\u00e0 Collectd. ####C\u00e1c b\u01b0\u1edbc c\u00e0i \u0111\u1eb7t Add Graphite cho Grafana\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra1.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra1.png\" alt=\"graphite\" \/><\/a><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra2.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra2.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>3: T\u00ean c\u1ee7a DataSource<\/p>\n<p>4: Khai b\u00e1o URL c\u1ee7a Graphite<\/p>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra3.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra3.png\" alt=\"graphite\" \/><\/a>\u1ea4n\u00a0<code>Test Connection<\/code>, n\u1ebfu k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 nh\u01b0 h\u00ecnh ngh\u0129a l\u00e0 \u0111\u00e3 add source th\u00e0nh c\u00f4ng. ####T\u1ea1o m\u1ed9t Dashboard m\u1edbi \u0111\u1ec3 gi\u00e1m s\u00e1t c\u00e1c host t\u1eeb Graphite\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra4.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra4.png\" alt=\"graphite\" \/><\/a>\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra5.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra5.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>Trong b\u00e0i s\u1ebd h\u01b0\u1edbng d\u1eabn t\u1ea1o 3 bi\u1ec3u \u0111\u1ed3 th\u00f4ng d\u1ee5ng:<\/p>\n<ul>\n<li>2.1 Pie Chart : Th\u00edch h\u1ee3p \u0111\u1ec3 th\u1ec3 hi\u1ec7n c\u00e1c d\u1ea1ng nh\u01b0 RAM, Disk Usage.<\/li>\n<li>2.2 Graphp : Th\u00edch h\u1ee3p \u0111\u1ec3 th\u1ec3 hi\u1ec7n c\u00e1c d\u1ea1ng nh\u01b0 Network Traffic, CPU Utilization.<\/li>\n<li>2.3 Singlestat : Th\u1ec3 hi\u1ec7n 1 s\u1ed1 li\u1ec7u c\u1ee5 th\u1ec3 nh\u01b0 System Uptime, RAM, Disk Total<\/li>\n<\/ul>\n<p><a name=\"user-content-pie\"><\/a>####2.1 Pie Chart\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra6.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra6.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>M\u1ee5c 1 :\u00a0<strong>Gerenal<\/strong><\/p>\n<ul>\n<li>1: Title c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>2: K\u00edch th\u01b0\u1edbc chi\u1ec1u ngang c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/li>\n<li>3: K\u00edch th\u01b0\u1edbc chi\u1ec1u d\u00e0i c\u1ee7a bi\u1ec3u \u0111\u1ed3<\/li>\n<li>4: Th\u00eam th\u00f4ng tin n\u1ebfu mu\u1ed1n link t\u1edbi m\u1ed9t Dashboard ho\u0103c URL kh\u00e1c<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra8.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra8.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>M\u1ee5c 2:\u00a0<strong>Metrics<\/strong><\/p>\n<ul>\n<li>1: Ch\u1ecdn host<\/li>\n<li>2,3 : Ch\u1ecdn th\u00f4ng s\u1ed1 mu\u1ed1n hi\u1ec3n th\u1ecb c\u1ee7a host<\/li>\n<li>4: D\u00f9ng function alias \u0111\u1ec3 \u0111\u1eb7t t\u00ean kh\u00e1c \u1edf \u00f4 5<\/li>\n<\/ul>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra9.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra9.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>Thay th\u1ebf legend name v\u1edbi t\u00ean ng\u1eafn g\u1ecdn l\u00e0\u00a0<strong>FREE<\/strong><\/p>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra10.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra10.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>T\u1ea1o th\u00eam m\u1ed9t query v\u1edbi m\u1ee5c \u0111\u00edch hi\u1ec3n th\u1ecb t\u1ed5ng s\u1ed1 dung l\u01b0\u1ee3ng RAM \u0111\u00e3 s\u1eed d\u1ee5ng.<\/p>\n<ul>\n<li>3: Ch\u1ecdn th\u1ed1ng s\u1ed1 l\u00e0\u00a0<code>memory-buffered<\/code><\/li>\n<li>4: S\u1eed d\u1ee5ng function t\u00ednh t\u1ed5ng l\u00e0\u00a0<code>sumSeries()<\/code>, \u1edf trong ta \u0111i\u1ec1n th\u00f4ng s\u1ed1\u00a0<code>memory-cached, memory-used<\/code>, h\u00e0m\u00a0<code>sumSeries()<\/code>s\u1ebd t\u00ednh t\u1ed5ng 3 th\u00f4ng s\u1ed1 l\u00e0 memory-buffer, cached v\u00e0 used, hi\u1ec3n th\u1ecb t\u00ean bi\u1ec3u \u0111\u1ed3 v\u1edbi t\u00ean l\u00e0\u00a0<code>USED<\/code><\/li>\n<\/ul>\n<p>C\u00e1ch l\u1ea5y t\u00ean \u0111\u1ea7y \u0111\u1ee7 cho th\u1ed1ng s\u1ed1 \u1edf m\u1ee5c 4:<\/p>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra7.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra7.png\" alt=\"graphite\" \/><\/a><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra11.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra11.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>Ch\u1ecdn \u0111\u01a1n v\u1ecb hi\u1ec3n th\u1ecb l\u00e0\u00a0<code>byte<\/code>\u00a0v\u00e0 legend name hi\u1ec3n th\u1ecb tr\u00ean graph<\/p>\n<p><a name=\"user-content-graph\"><\/a>####2.2 Graph\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra12.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra12.png\" alt=\"graphite\" \/><\/a><\/p>\n<p>M\u1ee5c 1 v\u00e0 2 c\u00e1ch c\u00e1c th\u00f4ng s\u1ed1 v\u1eabn gi\u1ed1ng v\u1eabn ki\u1ec3u Pie Chart ( ch\u00fa \u00fd ch\u1ecdn th\u00f4ng s\u1ed1 ph\u00f9 h\u1ee3p v\u1edbi d\u1ea1ng bi\u1ec3u \u0111\u1ed3 Graph)<\/p>\n<p>M\u1ee5c 3:\u00a0<strong>Axes<\/strong><\/p>\n<ul>\n<li>M\u1ee5c n\u00e0y \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u00e1c th\u00f4ng s\u1ed1 \u1edf tr\u1ee5c X v\u00e0 Y<\/li>\n<li>Ta ch\u1ecdn \u0111\u01a1n v\u1ecb hi\u1ec3n th\u1ecb l\u00e0 c\u1ee7a Network Traffic l\u00e0 kilobits\/sec, \u1edf tr\u1ee5c Y b\u00ean tr\u00e1i<\/li>\n<\/ul>\n<p>M\u1ee5c 4:\u00a0<strong>Legend<\/strong><\/p>\n<ul>\n<li>M\u1ee5c n\u00e0y \u0111\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1c th\u00f4ng s\u1ed1 li\u00ean quan \u0111\u1ebfn\u00a0<code>lengend<\/code><\/li>\n<li>Ta c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c ki\u1ec3u hi\u1ec3n th\u1ecb c\u1ee7a\u00a0<code>legend<\/code>\u00a0c\u0169ng nh\u01b0 c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a lenged<\/li>\n<\/ul>\n<p>Ch\u1ecdn Decimals = 2 \u0111\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 l\u1ea5y 2 \u0111\u01a1n v\u1ecb th\u1eadp ph\u00e2n sau d\u1ea5u &#8220;,&#8221;<\/p>\n<p><a name=\"user-content-single\"><\/a>####2.3 Singlestat\u00a0<a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra16.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra16.png\" alt=\"graphite\" \/><\/a><\/p>\n<ul>\n<li>M\u1ee5c 1 v\u00e0 2 c\u00e1c th\u1ed1ng s\u1ed1 v\u1eabn gi\u1ed1ng v\u1edbi c\u00e1c ki\u1ec3u bi\u1ec3u \u0111\u1ed3 kh\u00e1c<\/li>\n<li>M\u1ee5c 3, th\u1ed1ng s\u1ed1 ta l\u1ea5y \u1edf \u0111\u00e2y l\u00e0\u00a0<code>System Uptime<\/code>\u00a0n\u00ean \u0111\u01a1n v\u1ecb s\u1ebd l\u00e0\u00a0<code>second(s)<\/code><\/li>\n<\/ul>\n<p>T\u00f9y ch\u1ecdn th\u00eam\u00a0<code>Colonng<\/code>\u00a0n\u1ebfu mu\u1ed1n \u0111\u1eb7t ng\u01b0\u1ee1ng cho c\u00e1c th\u00f4ng s\u1ed1 n\u00e0y.<\/p>\n<p>V\u00ed d\u1ee5 Dashboard ho\u00e0n ch\u1ec9nh :<\/p>\n<p><a href=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/images\/Gra17.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/github.com\/hocchudong\/ghichep-grafana\/raw\/master\/images\/Gra17.png\" alt=\"graphite\" \/><\/a><a name=\"user-content-password\"><\/a>###3. Reset admin password C\u00e0i \u0111\u1eb7t database sqlite cho Grafana<\/p>\n<div class=\"highlight highlight-source-shell\">\n<pre>sudo apt-get update\nsudo apt-get install sqlite3 libsqlite3-dev<\/pre>\n<\/div>\n<p>C\u00fa ph\u00e1p reset password admin<\/p>\n<div class=\"highlight highlight-source-shell\">\n<pre>sudo sqlite3 \/var\/lib\/grafana\/grafana.db\n\nsqlite<span class=\"pl-k\">&gt;<\/span> update user <span class=\"pl-c1\">set<\/span> password = <span class=\"pl-s\"><span class=\"pl-pds\">'<\/span>59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6<span class=\"pl-pds\">'<\/span><\/span>, salt = <span class=\"pl-s\"><span class=\"pl-pds\">'<\/span>F3FAxVm33R<span class=\"pl-pds\">'<\/span><\/span> where login = <span class=\"pl-s\"><span class=\"pl-pds\">'<\/span>admin<span class=\"pl-pds\">'<\/span><\/span><span class=\"pl-k\">;<\/span>\nsqlite<span class=\"pl-k\">&gt;<\/span> .exit<\/pre>\n<\/div>\n<p>L\u00fac n\u00e0y password c\u1ee7a user admin \u0111\u0103ng nh\u1eadp tr\u00ean dashboard s\u1ebd tr\u1edf l\u1ea1i m\u1eb7c \u0111\u1ecbnh l\u00e0\u00a0<code>admin<\/code><\/p>\n<p>Ngu\u1ed3n:\u00a0https:\/\/github.com\/hocchudong\/ghichep-grafana\/blob\/master\/ghichep-grafana.md<\/p>\n","protected":false},"excerpt":{"rendered":"<p>##M\u1ee5c l\u1ee5c 1. Grafana logical model 2. Grafana Dashboard 2.1. Pie Chart 2.2 Graph 2.3 Singlestat 3. Reset admin password [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5,6,8],"tags":[],"class_list":["post-1258","post","type-post","status-publish","format-standard","hentry","category-monitoring","category-networking","category-system"],"_links":{"self":[{"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=\/wp\/v2\/posts\/1258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1258"}],"version-history":[{"count":0,"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=\/wp\/v2\/posts\/1258\/revisions"}],"wp:attachment":[{"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.lagonet.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}