{"id":4608,"date":"2021-03-02T23:51:07","date_gmt":"2021-03-02T14:51:07","guid":{"rendered":"https:\/\/higherhope.net\/?p=4608"},"modified":"2024-04-10T23:18:20","modified_gmt":"2024-04-10T14:18:20","slug":"post-4608","status":"publish","type":"post","link":"https:\/\/higherhope.net\/?p=4608","title":{"rendered":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002"},"content":{"rendered":"

\u4ee5\u524d\u306b\u3082\u540c\u3058\u30cd\u30bf\u304c\u3042\u308a\u307e\u3057\u305f\u304c<\/a>\u4eca\u56de\u3082MariaDB\u306eupdate\u5f8c\u306bzabbix\u3067slave\u306e\u5024\u304c\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002<\/p>\n

MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u4ee5\u4e0b<\/p>\n

MariaDB [(none)]> select version();
\n+—————-+
\n| version() |
\n+—————-+
\n| 10.5.9-MariaDB |
\n+—————-+
\n1 row in set (0.000 sec)<\/p><\/blockquote>\n

zabbix\u306e\u30ed\u30b0\u3092\u898b\u308b\u3068\u4ee5\u4e0b\u306e\u69d8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

ERROR 1227 (42000) at line 1: Access denied; you need (at least one of) the SUPER, SLAVE MONITOR privilege(s) for this operation<\/p><\/blockquote>\n

SUPER, SLAVE MONITOR\u3069\u3061\u3089\u304b\u306e\u6a29\u9650\u304c\u5fc5\u8981\u3068\u8a00\u3063\u3066\u307e\u3059\u3002<\/p>\n

slave\u30b5\u30fc\u30d0\u30fc\u306b\u5165\u308a\u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u3067\u78ba\u8a8d<\/p>\n

MariaDB [(none)]> show slave status\\G
\nERROR 1227 (42000): Access denied; you need (at least one of) the SUPER, SLAVE MONITOR privilege(s) for this operation<\/p><\/blockquote>\n

\u540c\u3058\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u3059\u306d\u3002
\n\u6a29\u9650\u3092\u898b\u3066\u307f\u307e\u3059\u3002<\/p>\n

MariaDB [(none)]> show grants for ‘zabbixagent’@’localhost’;
\n+—————————————————————————————————————————————————————+
\n| Grants for zabbixagent@localhost |
\n+—————————————————————————————————————————————————————+
\n| GRANT PROCESS, BINLOG MONITOR, REPLICATION SLAVE ADMIN ON *.* TO `zabbixagent`@`localhost` IDENTIFIED BY PASSWORD ‘*********’ |
\n+—————————————————————————————————————————————————————+
\n1 row in set (0.000 sec)<\/p><\/blockquote>\n

\u78ba\u304b\u306bSUPER, SLAVE MONITOR\u3069\u3061\u3089\u306e\u6a29\u9650\u3082\u4ed8\u4e0e\u3055\u308c\u3066\u307e\u305b\u3093\u3002
\n\u4ed8\u4e0e\u3057\u305f\u899a\u3048\u3082\u3042\u308a\u307e\u305b\u3093\u3002\u3002\u306a\u306e\u3067\u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n

root\u30e6\u30fc\u30b6\u30fc\u306b\u5207\u308a\u66ff\u3048\u5f8c<\/p>\n

MariaDB [(none)]> GRANT SLAVE MONITOR ON *.* TO ‘zabbixagent’@’localhost’;
\nQuery OK, 0 rows affected (0.001 sec)<\/p><\/blockquote>\n

SLAVE MONITOR \u6a29\u9650\u3092\u4ed8\u4e0e\u3057\u518d\u5ea6\u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u3067\u78ba\u8a8d<\/p>\n

MariaDB [(none)]> show slave status\\G
\n*************************** 1. row ***************************
\n Slave_IO_State: Waiting for master to send event
\n\u7565\u30fb\u30fb<\/p><\/blockquote>\n

\u7121\u4e8b\u306b\u53d6\u5f97\u3059\u308b\u4e8b\u304c\u3067\u304dzabbix\u3067\u3082\u76e3\u8996\u304c\u5fa9\u6d3b\u3057\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4ee5\u524d\u306b\u3082\u540c\u3058\u30cd\u30bf\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u4eca\u56de\u3082MariaDB\u306eupdate\u5f8c\u306bzabbix\u3067slave\u306e\u5024\u304c\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002 MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u4ee5\u4e0b MariaDB [(none)]> select … Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178,184,134],"tags":[],"class_list":["post-4608","post","type-post","status-publish","format-standard","hentry","category-centos8","category-mariadb","category-zabbix"],"yoast_head":"\nMariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/higherhope.net\/?p=4608\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"og:description\" content=\"\u4ee5\u524d\u306b\u3082\u540c\u3058\u30cd\u30bf\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u4eca\u56de\u3082MariaDB\u306eupdate\u5f8c\u306bzabbix\u3067slave\u306e\u5024\u304c\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002 MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u4ee5\u4e0b MariaDB [(none)]> select ... Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/higherhope.net\/?p=4608\" \/>\n<meta property=\"og:site_name\" content=\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-02T14:51:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-10T14:18:20+00:00\" \/>\n<meta name=\"author\" content=\"higherhope\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:site\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"higherhope\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/higherhope.net\/?p=4608#article\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/?p=4608\"},\"author\":{\"name\":\"higherhope\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"headline\":\"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002\",\"datePublished\":\"2021-03-02T14:51:07+00:00\",\"dateModified\":\"2024-04-10T14:18:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/higherhope.net\/?p=4608\"},\"wordCount\":140,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"articleSection\":[\"CentOS8\",\"MariaDB\",\"zabbix\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/higherhope.net\/?p=4608#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/higherhope.net\/?p=4608\",\"url\":\"https:\/\/higherhope.net\/?p=4608\",\"name\":\"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/#website\"},\"datePublished\":\"2021-03-02T14:51:07+00:00\",\"dateModified\":\"2024-04-10T14:18:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/higherhope.net\/?p=4608#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/higherhope.net\/?p=4608\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/higherhope.net\/?p=4608#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/higherhope.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/higherhope.net\/#website\",\"url\":\"https:\/\/higherhope.net\/\",\"name\":\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"description\":\"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002\",\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/higherhope.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\",\"name\":\"higherhope\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"contentUrl\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"width\":700,\"height\":394,\"caption\":\"higherhope\"},\"logo\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/higherhope5963\"],\"url\":\"https:\/\/higherhope.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/higherhope.net\/?p=4608","og_locale":"ja_JP","og_type":"article","og_title":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","og_description":"\u4ee5\u524d\u306b\u3082\u540c\u3058\u30cd\u30bf\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u4eca\u56de\u3082MariaDB\u306eupdate\u5f8c\u306bzabbix\u3067slave\u306e\u5024\u304c\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002 MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u4ee5\u4e0b MariaDB [(none)]> select ... Continue reading →","og_url":"https:\/\/higherhope.net\/?p=4608","og_site_name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","article_published_time":"2021-03-02T14:51:07+00:00","article_modified_time":"2024-04-10T14:18:20+00:00","author":"higherhope","twitter_card":"summary_large_image","twitter_creator":"@higherhope5963","twitter_site":"@higherhope5963","twitter_misc":{"\u57f7\u7b46\u8005":"higherhope","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/higherhope.net\/?p=4608#article","isPartOf":{"@id":"https:\/\/higherhope.net\/?p=4608"},"author":{"name":"higherhope","@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"headline":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002","datePublished":"2021-03-02T14:51:07+00:00","dateModified":"2024-04-10T14:18:20+00:00","mainEntityOfPage":{"@id":"https:\/\/higherhope.net\/?p=4608"},"wordCount":140,"commentCount":0,"publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"articleSection":["CentOS8","MariaDB","zabbix"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/higherhope.net\/?p=4608#respond"]}]},{"@type":"WebPage","@id":"https:\/\/higherhope.net\/?p=4608","url":"https:\/\/higherhope.net\/?p=4608","name":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","isPartOf":{"@id":"https:\/\/higherhope.net\/#website"},"datePublished":"2021-03-02T14:51:07+00:00","dateModified":"2024-04-10T14:18:20+00:00","breadcrumb":{"@id":"https:\/\/higherhope.net\/?p=4608#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/higherhope.net\/?p=4608"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/higherhope.net\/?p=4608#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/higherhope.net\/"},{"@type":"ListItem","position":2,"name":"MariaDB\u306eSLAVE STATUS\u304czabbix\u3067\u53d6\u5f97\u51fa\u6765\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u5bfe\u51e6\u3057\u305f\u3002"}]},{"@type":"WebSite","@id":"https:\/\/higherhope.net\/#website","url":"https:\/\/higherhope.net\/","name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","description":"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002","publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/higherhope.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af","name":"higherhope","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/","url":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","contentUrl":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","width":700,"height":394,"caption":"higherhope"},"logo":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/x.com\/higherhope5963"],"url":"https:\/\/higherhope.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4608"}],"version-history":[{"count":2,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4608\/revisions"}],"predecessor-version":[{"id":5664,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/4608\/revisions\/5664"}],"wp:attachment":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}