====== 安裝 InfluxDB Cluster ======
  * CentOS 6.x x86_64 環境
  * InfluxDB 0.10.x
  * Hybrid node : 
    * infxnode1 : 140.92.143.36
    * infxnode2 : 140.92.143.43
    * infxnode3 : 140.92.143.86

===== 安裝 InfluxDB =====
  * 建立 InfluxDB yum Repos<code sh>
cat <<EOF | sudo tee /etc/yum.repos.d/influxdb.repo
[influxdb]
name = InfluxDB Repository - RHEL \$releasever
baseurl = https://repos.influxdata.com/rhel/\$releasever/\$basearch/stable
enabled = 1
gpgcheck = 1
gpgkey = https://repos.influxdata.com/influxdb.key
EOF
</code>
  * 透過 yum 安裝<code sh>
su - root
yum install influxdb
chkconfig influxdb on
servvice influxdb start

vi /etc/sysconfig/iptables
</code><file>
:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
# InfluxDB
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8088 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8083 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8086 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8091 -j ACCEPT
:
</file><code sh>
service iptables reload
</code>

  * 透過 http://[ip]:8083/ 就可以看到安裝後的基本操作管理網頁
  * 透過 tail -f /var/log/influxdb/influxd.log 可以看到運行紀錄

===== InfluxDB Cluster 設定 =====
  * 設定 /etc/hosts <code sh>
vi /etc/hosts</code><file>
:
140.92.143.36 infxnode1 
140.92.143.43 infxnode2
140.92.143.86 infxnode3
</file>

  * Node 1 : <code sh>
vi /etc/influxdb/influxdb.conf
</code><file>
:
[meta]
  enabled = true
:
  bind-address = "infxnode1:8088"
  http-bind-address = "infxnode1:8091"

:

[data]
  enabled = true

[http]
:
  bind-address = "infxnode1:8086"
</file><code sh>
rm -rf /var/lib/influxdb/*
service influxdb restart
</code>

  * Node 2 : <code sh>
service influxdb stop
vi /etc/influxdb/influxdb.conf
</code><file>
:
[meta]
  enabled = true
:
  bind-address = "infxnode2:8088"
  http-bind-address = "infxnode2:8091"

:

[data]
  enabled = true

[http]
:
  bind-address = "infxnode2:8086"

</file><code sh>
vi /etc/default/influxdb
</code><file>
INFLUXD_OPTS="-join infxnode1:8091"
</file><code sh>
rm -rf /var/lib/influxdb/*
service influxdb start
</code>

  * Node 3 : <code sh>
service influxdb stop
vi /etc/influxdb/influxdb.conf
</code><file>
:
[meta]
  enabled = true
:
  bind-address = "infxnode3:8088"
  http-bind-address = "infxnode3:8091"

:

[data]
  enabled = true

[http]
:
  bind-address = "infxnode3:8086"

</file<code sh>
vi /etc/default/influxdb
</code><file>
INFLUXD_OPTS="-join infxnode1:8091"
</file><code sh>
rm -rf /var/lib/influxdb/*
service influxdb start
</code>

===== 檢查與使用 =====
  * 透過每一台的管理界面 Exp. http://140.92.143.86:8083/ 輸入 **SHOW SERVERS** 就可以看到目前 Cluster 的狀況<file>
data_nodes
id	http_addr	tcp_addr
1	"infxnode1:8086"	"infxnode1:8088"
3	"infxnode3:8086"	"infxnode3:8088"
5	"infxnode2:8086"	"infxnode2:8088"
meta_nodes
id	http_addr	tcp_addr
1	"infxnode1:8091"	"infxnode1:8088"
2	"infxnode3:8091"	"infxnode3:8088"
4	"infxnode2:8091"	"infxnode2:8088"

</file>

===== 增加一個 Node =====
  * 增加一個 Hybrid node : 
    * infxnode4 : 140.92.143.17
  * 更新 node1 ~ node 4 /etc/hosts 內的定義, 設定 /etc/hosts <code sh>
vi /etc/hosts</code><file>
:
140.92.143.36 infxnode1 
140.92.143.43 infxnode2
140.92.143.86 infxnode3
140.92.143.17 infxnode4
</file>
  * 再來執行與 node2 ~ node3 的設定相同

===== 移除一個 Node =====
  * 移除一個 Hybrid node :
    * infxnode3 : 140.92.143.86
  * 使用 influx CLI 操作
    * 連入 influxdb cluster 其中一台 Exp. infxnode3 <code sh>
influx -database sysmon01 -host infxnode3 -port 8086
show servers
</code><file>
> show servers
name: data_nodes
----------------
id      http_addr       tcp_addr
3       infxnode3:8086  infxnode3:8088
5       infxnode2:8086  infxnode2:8088
7       localhost:8086  infxnode4:8088
10      infxnode1:8086  infxnode1:8088
11      infxnode5:8086  infxnode5:8088


name: meta_nodes
----------------
id      http_addr       tcp_addr
1       infxnode1:8091  infxnode1:8088
2       infxnode3:8091  infxnode3:8088
4       infxnode2:8091  infxnode2:8088
6       infxnode4:8091  infxnode4:8088
8       infxnode5:8091  infxnode5:8088
</file>
    * 看到 indxnode3 在 data server id 是 3<code sh>
drop data server 3
show servers
</code><file>
name: data_nodes
----------------
id      http_addr       tcp_addr
5       infxnode2:8086  infxnode2:8088
7       localhost:8086  infxnode4:8088
10      infxnode1:8086  infxnode1:8088
11      infxnode5:8086  infxnode5:8088


name: meta_nodes
----------------
id      http_addr       tcp_addr
1       infxnode1:8091  infxnode1:8088
2       infxnode3:8091  infxnode3:8088
4       infxnode2:8091  infxnode2:8088
6       infxnode4:8091  infxnode4:8088
8       infxnode5:8091  infxnode5:8088
</file>
    * 這樣就移除掉 node3

===== 匯出與匯入 =====
  * 匯出資料 Exp. 將 sysmon01 透過 infxnode3 匯出到 /root/sysmon01 目錄內 <code sh>
influxd backup -database sysmon01 -host infxnode3:8088 /root/sysmon01
ls -lt /root/sysmon01
</code><file>
[root@influxdb3 sysmon01]# ls -lt /root/sysmon01
總計 25700
-rw-r--r--. 1 root root 4326400 2016-03-22 18:58 sysmon01.default.00013.00
-rw-r--r--. 1 root root 8824320 2016-03-22 18:58 sysmon01.default.00003.00
-rw-r--r--. 1 root root    1161 2016-03-22 18:58 meta.00
</file>

  * 清空 Influxdb Cluster node 內所有 /var/lib/influxdb/ 內資料檔案<code sh>
service influxdb stop
rm -rf /var/lib/influxdb/*
</code>
  * 在重新啟動 Influxdb Cluster<code sh>
service influxdb start
</code>
<note>
  * 關閉順序 node 5 4 3 2 1(為主要同步點)
  * 啟動順訊 node 1(為主要同步點) 2 3 4 5
  * 主要同步點各個 node 內 /etc/default/influxdb 設定, 本身不要設定
</note>
  *  匯入資料 Exp. 將 /root/sysmon01 目錄內 sysmon01 備份資料匯入 infxnode3 <code sh>
influxd restore -database sysmon01 -datadir /var/lib/influxdb/data  /root/sysmon01
chown -R influxdb:influxdb /var/lib/influxdb/*

</code>
===== 參考網址 =====
  * https://influxdata.com/downloads/
  * https://docs.influxdata.com/influxdb/v0.10/introduction/installation/#redhat-centos
  * https://docs.influxdata.com/influxdb/v0.10/clustering/cluster_setup/
  * https://docs.influxdata.com/influxdb/v0.9/guides/clustering/
  * https://github.com/influxdata/influxdb/issues/5874
  * https://github.com/influxdata/influxdb/issues/1471
  * https://docs.influxdata.com/influxdb/v0.10/administration/backup_and_restore/

{{tag>influxdb database time-series}}