目前還是測試版，千萬不要用在正式環境!!

Zabbix 3.4.5版本支援data存至elasticsearch
Zabbix has recently started to support storage of historical data by means of Elasticsearch instead of a database.
https://www.zabbix.com/documentation/3.4/manual/appendix/install/elastic_search_setup

推測應該跟Type of information資料型態有關
uint:Numeric (unsigned),dbl:Numeric (float)

vi /etc/zabbix/zabbix_server.conf
HistoryStorageURL=http://172.16.1.1:9200
HistoryStorageTypes=uint,dbl,str,log,text

不確定路徑可以用find / -name zabbix.conf.php

vi /etc/zabbix/web/zabbix.conf.php
global $DB, $HISTORY;
$HISTORY['url']   = 'http://172.16.1.1:9200';
$HISTORY['types'] = ['uint','str', 'text', 'log'];

重啟zabbix server即可

設定elasticsearch上zabbix資料的型態
(錯了要把資料全清掉才能重做)

curl -XPUT 172.16.1.1:9200/text -d'

{
 "settings" : {
    "index" : {
       "number_of_replicas" : 1,
       "number_of_shards" : 5
    }
 },
 "mappings" : {
    "values" : {
       "properties" : {
          "itemid" : {
             "type" : "long"
          },
          "clock" : {
             "format" : "epoch_second",
             "type" : "date"
          },
          "value" : {
             "fields" : {
                "analyzed" : {
                   "index" : true,
                   "type" : "text",
                   "analyzer" : "standard"
                }
             },
             "index" : false,
             "type" : "text"
          }
       }
    }
 }
}
'

範本

# uint mapping

{
   "settings" : {
      "index" : {
         "number_of_replicas" : 1,
         "number_of_shards" : 5
      }
   },
   "mappings" : {
      "values" : {
         "properties" : {
            "itemid" : {
               "type" : "long"
            },
            "clock" : {
               "format" : "epoch_second",
               "type" : "date"
            },
            "value" : {
               "type" : "long"
            }
         }
      }
   }
}


# dbl mapping

{
   "settings" : {
      "index" : {
         "number_of_replicas" : 1,
         "number_of_shards" : 5
      }
   },
   "mappings" : {
      "values" : {
         "properties" : {
            "itemid" : {
               "type" : "long"
            },
            "clock" : {
               "format" : "epoch_second",
               "type" : "date"
            },
            "value" : {
               "type" : "double"
            }
         }
      }
   }
}


# str mapping

{
   "settings" : {
      "index" : {
         "number_of_replicas" : 1,
         "number_of_shards" : 5
      }
   },
   "mappings" : {
      "values" : {
         "properties" : {
            "itemid" : {
               "type" : "long"
            },
            "clock" : {
               "format" : "epoch_second",
               "type" : "date"
            },
            "value" : {
               "fields" : {
                  "analyzed" : {
                     "index" : true,
                     "type" : "text",
                     "analyzer" : "standard"
                  }
               },
               "index" : false,
               "type" : "text"
            }
         }
      }
   }
}


# text mapping

{
   "settings" : {
      "index" : {
         "number_of_replicas" : 1,
         "number_of_shards" : 5
      }
   },
   "mappings" : {
      "values" : {
         "properties" : {
            "itemid" : {
               "type" : "long"
            },
            "clock" : {
               "format" : "epoch_second",
               "type" : "date"
            },
            "value" : {
               "fields" : {
                  "analyzed" : {
                     "index" : true,
                     "type" : "text",
                     "analyzer" : "standard"
                  }
               },
               "index" : false,
               "type" : "text"
            }
         }
      }
   }
}


# log mapping

{
   "settings" : {
      "index" : {
         "number_of_replicas" : 1,
         "number_of_shards" : 5
      }
   },
   "mappings" : {
      "values" : {
         "properties" : {
            "itemid" : {
               "type" : "long"
            },
            "clock" : {
               "format" : "epoch_second",
               "type" : "date"
            },
            "value" : {
               "fields" : {
                  "analyzed" : {
                     "index" : true,
                     "type" : "text",
                     "analyzer" : "standard"
               },
               "index" : false,
               "type" : "text"
            }
         }
      }
   }
}

Kibana顯示，格式與SQL相同，要知道itemid才能做圖表

繪圖，與1-12相同的itemid

Grafana繪圖 (Display的Null value 要選 Connected 不然圖繪顯示不出來)

小插曲
為了要測試找了一台3.2升級3.4，server啟動成功，查看log也沒異常，可是網頁開不起來
System error occurred. Please contact Zabbix administrator.

vi /var/log/zabbix/zabbix_server.log

  2247:20180108:145759.671 database connection re-established
  2247:20180108:145759.702 current database version (mandatory/optional): 03040000/03040005
  2247:20180108:145759.702 required mandatory version: 03040000
  2247:20180108:145801.017 server #0 started [main process]
  2542:20180108:145801.018 server #1 started [configuration syncer #1]

懷疑連網頁至DB問題，檢查conf設定，確定設定皆正常

vi /etc/zabbix/zabbix_server.conf
find / -name zabbix.conf.php
vi /etc/zabbix/web/zabbix.conf.php

刪除所有zabbix檔案 (包含/usr/share/zabbix/及/etc/zabbix/ 底下手動rm刪除)
重新安裝後正常運作