InfluxDB install on centos

# Centos InfluxDB install on centos

## 安装配置 InfluxDB

# vim /etc/yum.repos.d/influxdb.repo

```python
[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
```

# yum -y install influxdb
    # service influxdb start
    # wget https://s3.amazonaws.com/influxdb/influxdb-0.9.5.1-1.x86_64.rpm
    # sudo yum localinstall influxdb-0.9.5.1-1.x86_64.rpm
    # wget https://dl.influxdata.com/influxdb/releases/influxdb-1.2.4.x86_64.rpm
    # sudo yum localinstall influxdb-1.2.4.x86_64.rpm

## 编辑 InfluxDB 的配置文件

/etc/influxdb/influxdb.conf，将 [collectd] 标签下的内容修改为：

[root@GIC influxdb]# cat influxdb.conf |grep -Ev "^$|#"
```python
[meta]
  dir = "/var/lib/influxdb/meta"
[data]
  dir = "/var/lib/influxdb/data"
  wal-dir = "/var/lib/influxdb/wal"
[coordinator]
[retention]
[shard-precreation]
[monitor]
[admin]
   enabled = true
   bind-address = ":8083"
[http]
   enabled = true
   bind-address = ":8086"
[subscriber]
[[graphite]]
[[collectd]]
   enabled = true
   bind-address = ":25826"
   database = "collectd"
   #typesdb = "/usr/local/share/collectd"
   typesdb = "/usr/share/collectd"
   batch-size = 5000
   batch-pending = 10
   batch-timeout = "10s"
   read-buffer = 0
[[opentsdb]]
[[udp]]
[continuous_queries]
```

## 启动守护程序

# service influxdb start
启动后TCP端口:8083 为InfluxDB 管理控制台
TCP端口:8086 为客户端和InfluxDB通信时的HTTP API
启动后InfluxDB用户认证默认是关闭的，先创建用户: tester

这时候可以上influxdb数据库查看是否有数据传输过来，可以命令行查看也可上WEB页面查看

# influx
Connected to http://localhost:8086 version 1.2.4
InfluxDB shell version: 1.2.4
显示用户

# show users
创建用户

# create user "username" with password 'password'
创建管理员权限用户

# create user "username" with password 'password' with all privileges

删除用户

# drop user "username"
    #  show databases;

```
 name: databases
 name
 ----
 collectd
  _internal
    # use collectd;
Using database collectd
    #  select * from /load/;
 name: load_longterm
 time                host type value
 ----                ---- ---- -----
 1495439885941550600 gic  load 0
 1495439895941017268 gic  load 0
 1495439905942144152 gic  load 0
 1495439915940668255 gic  load 0
 1495439925945475393 gic  load 0
 1495439935941039668 gic  load 0

```
 
### 创建数据库

# create database "db_name"
### 显示所有的数据库

# show databases
### 删除数据库

# drop database "db_name"
### 使用数据库

# use db_name
### 显示该数据库中所有的表

# show measurements
### 创建表，直接在插入数据的时候指定表名

# insert test,host=127.0.0.1,monitor_name=test count=1
### 删除表

# drop measurement "measurement_name"

Done