TICK之CentOS7.6安装influxdb

蔚落 2021-11-22 12:10 304阅读 0赞

1.influxdb 镜像地址 [https://hub.docker.com/\_/influxdb?tab=description][https_hub.docker.com_influxdb_tab_description]

2.下载镜像

docker pull influxdb

3.influxdb 的端口说明

8083 : Web Admin 管理服务端口，访问 http://ip:8083，这个端口没有效果，有人说1.7.4版本管理端又恢复了，实际没有

8086 : Http API 端口

2003 : 图形系统端口

4.创建数据目录及配置文件路径

创建数据目录 /root/runenv/opt/docker/influxdb/data

创建配置文件目录 /root/runenv/opt/docker/influxdb/conf

创建默认配置文件

docker run --rm influxdb influxd config > influxdb.conf

此时配置文件目录下可以看到 influxdb.conf

关注：

第二行 bind-address = "127.0.0.1:8088" 改成了 ":8088"  备份恢复时使用端口

reporting-disabled = false
    bind-address = ":8088"
    
    [meta]
      dir = "/var/lib/influxdb/meta"
      retention-autocreate = true
      logging-enabled = true
    
    [data]
      dir = "/var/lib/influxdb/data"
      index-version = "inmem"
      wal-dir = "/var/lib/influxdb/wal"
      wal-fsync-delay = "0s"
      validate-keys = false
      query-log-enabled = true
      cache-max-memory-size = 1073741824
      cache-snapshot-memory-size = 26214400
      cache-snapshot-write-cold-duration = "10m0s"
      compact-full-write-cold-duration = "4h0m0s"
      compact-throughput = 50331648
      compact-throughput-burst = 50331648
      max-series-per-database = 1000000
      max-values-per-tag = 100000
      max-concurrent-compactions = 0
      max-index-log-file-size = 1048576
      series-id-set-cache-size = 100
      trace-logging-enabled = false
      tsm-use-madv-willneed = false
    
    [coordinator]
      write-timeout = "10s"
      max-concurrent-queries = 0
      query-timeout = "0s"
      log-queries-after = "0s"
      max-select-point = 0
      max-select-series = 0
      max-select-buckets = 0
    
    [retention]
      enabled = true
      check-interval = "30m0s"
    
    [shard-precreation]
      enabled = true
      check-interval = "10m0s"
      advance-period = "30m0s"
    
    [monitor]
      store-enabled = true
      store-database = "_internal"
      store-interval = "10s"
    
    [subscriber]
      enabled = true
      http-timeout = "30s"
      insecure-skip-verify = false
      ca-certs = ""
      write-concurrency = 40
      write-buffer-size = 1000
    
    [http]
      enabled = true
      bind-address = ":8086"
      auth-enabled = true
      log-enabled = true
      suppress-write-log = false
      write-tracing = false
      flux-enabled = false
      flux-log-enabled = false
      pprof-enabled = true
      debug-pprof-enabled = false
      https-enabled = false
      https-certificate = "/etc/ssl/influxdb.pem"
      https-private-key = ""
      max-row-limit = 0
      max-connection-limit = 0
      shared-secret = ""
      realm = "InfluxDB"
      unix-socket-enabled = false
      unix-socket-permissions = "0777"
      bind-socket = "/var/run/influxdb.sock"
      max-body-size = 25000000
      access-log-path = ""
      max-concurrent-write-limit = 0
      max-enqueued-write-limit = 0
      enqueued-write-timeout = 30000000000
    
    [logging]
      format = "auto"
      level = "info"
      suppress-logo = false
    
    [[graphite]]
      enabled = false
      bind-address = ":2003"
      database = "graphite"
      retention-policy = ""
      protocol = "tcp"
      batch-size = 5000
      batch-pending = 10
      batch-timeout = "1s"
      consistency-level = "one"
      separator = "."
      udp-read-buffer = 0
    
    [[collectd]]
      enabled = false
      bind-address = ":25826"
      database = "collectd"
      retention-policy = ""
      batch-size = 5000
      batch-pending = 10
      batch-timeout = "10s"
      read-buffer = 0
      typesdb = "/usr/share/collectd/types.db"
      security-level = "none"
      auth-file = "/etc/collectd/auth_file"
      parse-multivalue-plugin = "split"
    
    [[opentsdb]]
      enabled = false
      bind-address = ":4242"
      database = "opentsdb"
      retention-policy = ""
      consistency-level = "one"
      tls-enabled = false
      certificate = "/etc/ssl/influxdb.pem"
      batch-size = 1000
      batch-pending = 5
      batch-timeout = "1s"
      log-point-errors = true
    
    [[udp]]
      enabled = false
      bind-address = ":8089"
      database = "udp"
      retention-policy = ""
      batch-size = 5000
      batch-pending = 10
      read-buffer = 0
      batch-timeout = "1s"
      precision = ""
    
    [continuous_queries]
      log-enabled = true
      enabled = true
      query-stats-enabled = false
      run-interval = "1s"
    
    [tls]
      min-version = ""
      max-version = ""
    
    #[admin]
    #  enabled = true
    #  bind-address = ":8083"

5.启动 influxdb

docker run -d -p 8086:8086 -p 8088:8088 -e TZ=Asia/Shanghai -v /root/runenv/opt/docker/influxdb/data:/var/lib/influxdb -v /root/runenv/opt/docker/influxdb/conf/influxdb.conf:/etc/influxdb/influxdb.conf:ro --name influxdb influxdb -config /etc/influxdb/influxdb.conf

配置文件中的 \[http\] -> auth-enabled = false 先不改变

服务器开通 8086和8088端口

6.下载工具并连接

[https://github.com/CymaticLabs/InfluxDBStudio][https_github.com_CymaticLabs_InfluxDBStudio]

安装包可以到 [https://github.com/CymaticLabs/InfluxDBStudio/releases][https_github.com_CymaticLabs_InfluxDBStudio_releases] 下载

如下图中UserName 和 Password 可以先不填

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70][]

如下图连接成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 1][]

7.创建账号并授权

创建账号

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 2][]

授权

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 3][]

8.修改 influxdb.conf 开放用户权限验证，并重启容器

\[http\] -> auth-enabled = true

docker restart influxdb容器ID

9.用户权限验证测试

在没有输入正确User Name 和 Password 的情况下，点击 \[Test\] 按钮均会报如下错误，否则可以正常连接及进行相关操作

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 4][]

[https_hub.docker.com_influxdb_tab_description]: https://hub.docker.com/_/influxdb?tab=description
[https_github.com_CymaticLabs_InfluxDBStudio]: https://github.com/CymaticLabs/InfluxDBStudio
[https_github.com_CymaticLabs_InfluxDBStudio_releases]: https://github.com/CymaticLabs/InfluxDBStudio/releases
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70]: /images/20211122/52dfe088843e46a7ac45e7a18f0e237a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 1]: /images/20211122/08e60ec470d64076bb6a49a1e3cda14d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 2]: /images/20211122/00ab2f2bcf1e4f42b8505c4b13d40e75.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 3]: /images/20211122/32dd460246734c2e831f6ee50ca8e173.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbmd0NTk1Mg_size_16_color_FFFFFF_t_70 4]: /images/20211122/1f35784815f24a0f91728921b6945fb9.png