Shulou(Shulou.com)06/01 Report--

Introduction to 01-InfluxDB

Authority Management of 02-influxdb

Introduction to the backup and recovery of 03-Influxdb influxdb is a time series-based database written in GO, which is used to store a large number of time-stamped data, error DevOps monitoring, log data, application indicators, data analysis data and so on. With influxdb automatically saving data, you don't need to delete and clean up, you just need to define DB for a period of time to help you clean up automatically.

Characteristics

It can process millions of data points per second. It will also compress a large amount of data for you over a long period of time to minimize space. It can save recent high-precision data and long-term sampled data, that is, the continuous query and retention strategy, which ensures automatic sampling and automatic expiration of old data. Support a variety of data extraction plug-ins, such as: graphite,collected,openTSD.

Other information

Influxdb default port 8086, default is http protocol interface, easy to use

Installation

Download the installation package: wget 'http://dl.influxdata.com/influxdb/nightlies/influxdb-nightly_darwin_amd64.tar.gz'

Extract the installation package: tar zxf influxdb-nightly_darwin_amd64.tar.gz

Start influxdb:cd influxdb-1.7.0~n201811230800-0 / & &. / usr/bin/influxd

Log in to the database:. / usr/bin/influx

View help:

> helpUsage: connect connects to another node specified by host:port auth prompts for username and password pretty toggles pretty print for the json format chunked turns on chunked responses from server chunk size sets the size of the chunked responses. Set to 0 to reset to the default chunked size use sets current database format specifies the format of the server responses: json, csv, or column precision specifies the format of the timestamp: rfc3339, h, m, s, ms, uor ns consistency sets write consistency level: any, one, quorum Or all history displays command history settings outputs the current settings for the shell clear clears settings such as database or retention policy. Run 'clear' for help exit/quit/ctrl+d quits the influx shell show databases show database names show series show series information show measurements show measurement information show tag keys show tag key information show field keys show field key information A full list of influxql commands can be found at: https://docs.influxdata.com/influxdb/latest/query_language/spec/

Log in to Influxdb

Influx-precision rfc3339-precision rfc3339 # precise specified parameters, rfc3339 time format database operation

Now that the influxdb has been built, you can start the operation, build a database, build a table and write data. When writing a time series data, it may contain 0 to more points, each data corresponding to a monitoring sample (e.g. cpu_load, temperature) including at least one key-value pair (cplu_load=5)

Here it can be regarded as:

Measurement is a table that provides a time index. Fields is the column in the table.

Tags is the index in the table

Unlike mysql, you can have millions of measurements, and n doesn't need to define the table structure in advance, and it doesn't store null values.

1. Create a database

CREATE DATABASE {NAME}

> create database order_record; > show databases;name: databasesname----_internalorder_record at this time we found that the database has a table "_ internal". In fact, this table is some indicator repository of the influxdb database. It is somewhat similar to the mysql library of mysql database.

two。 Write data

Note that if you do not add a timestamp when writing data, the system will add a time by default.

[, =.] = [, =.] [unix-nano-timestamp]

> use order_record;Using database order_record > INSERT cpu,host=serverA,region=us_west value=0.64 > SELECT "host", "region", "value" FROM "cpu" name: cputime host region value-----2018-11-23T16:01:29.995044Z serverA us_west 0.64

3. Data reading

Like mysql, if you want to empty the number of lines of content output, you can use [limit 1 output;], and influxdb's sql also supports the regularity of the go language format.

> select * from cpu Name: cputime host region value---- 2018-11-23T16:01:29.995044Z serverA us_west 0.64 > INSERT stock,symbol=AAPL bid=127.46,ask=127.48 > INSERT temperature,machine=unit42,type=assembly external=25,internal=37 14340674670000000 > SELECT "host", "region" "value" FROM "cpu" name: cputime host region value-----2018-11-23T16:01:29.995044Z serverA us_west 0.64 each table outputs one line SELECT * FROM /. * / LIMIT 1

4. View the shards of the current database

> SHOW SHARDSname: _ internalid database retention_policy shard_group start_time end_time expiry_time owners -1 _ internal monitor 1 2018-11-24T00:00:00Z 2018-11-25T00:00:00Z 2018-12-02T00:00:00Zname: zabbixid database retention_policy shard_group start_time end_time expiry_time owners -- 5 zabbix autogen 5 1969-12-29T00:00:00Z 1970-01-05T00:00:00Z 1970-01-05T00:00:00Z4 zabbix autogen 4 1970-01 -12T00:00:00Z 1970-01-19T00:00:00Z 1970-01-19T00:00:00Z3 zabbix autogen 3 2018-11-19T00:00:00Z 2018-11-26T00:00:00Z 2018-11-26T00:00:00Zhttp api call influxdb

0. Interface introduction

Interface path description / debug/pprofdebug troubleshooting using / debug/requests use this request to listen for recent requests / debug/vars query influxdb collected static information / ping detect influxdb status / query query data interface (also can create ku) / write write data interface (an existing database)

Status code introduction:

2xx: the service request is normal 4xx: indicates that there is a problem with the request syntax 5xx: there is a problem with the server, resulting in timeout and other failures

1. Create a database

Curl-I-XPOST http://localhost:8086/query-- data-urlencode "q=CREATE DATABASE mydb" HTTP/1.1 200 OKContent-Type: application/jsonRequest-Id: 5edd88a8-ef90-11e8-83cd-a0999b0f94e3X-Influxdb-Build: OSSX-Influxdb-Version: 1.7.0~n201811230800X-Request-Id: 5edd88a8-ef90-11e8-83cd-a0999b0f94e3Date: Sat, 24 Nov 2018 02:26:38 GMTTransfer-Encoding: chunked {"results": [{"statement_id": 0}]}

two。 Write data

Curl-I-XPOST 'http://localhost:8086/write?db=mydb'-- data-binary' cpu_load_short,host=server01,region=us-west value=0.65 1434055564000000000'HTTP/1.1 204No ContentContent-Type: application/jsonRequest-Id: 1ae386c4-ef91-11e8-83d8-a0999b0f94e3X-Influxdb-Build: OSSX-Influxdb-Version: 1.7.0~n201811230800X-Request-Id: 1ae386c4-ef91-11e8-83d8-a0999b0f94e3Date: Sat, 24 Nov 2018 02:31:53 GMT

3. Write to multiple data points

Curl-I-XPOST 'http://localhost:8086/write?db=mydb'-- data-binary' cpu_load_short,host=server02 value=0.67

Cpu_load_short,host=server02,region=us-west value=0.55 1422568543702900257

Cpu_load_short,direction=in,host=server01,region=us-west value=2.0 1422568543702900257'

HTTP/1.1 204 No Content

Content-Type: application/json

Request-Id: 574f52a0-ef91-11e8-83d9-a0999b0f94e3

X-Influxdb-Build: OSS

X-Influxdb-Version: 1.7.0~n201811230800

X-Request-Id: 574f52a0-ef91-11e8-83d9-a0999b0f94e3

Date: Sat, 24 Nov 2018 02:33:34 GMT

4. Import a database from a file

It is recommended that you import no more than 5000 entries from the file. If the number exceeds, please cut the file, because the API 5s of http api will time out, and too much data will cause the data to fail to confirm whether it is successful.

The file cpu_data.txt is as follows:

Cpu_load_short,host=server02 value=111cpu_load_short,host=server02,region=us-west value=0.222 1543027130702900257cputloadloadbooks, directionalism, directionalism, hostkeeper server01, regionalism, west value=111.222 1543027129702900257curl-I-XPOST 'http://localhost:8086/write?db=mydb'-- data-binary @ cpu_data.txt

HTTP/1.1 204 No Content

Content-Type: application/json

Request-Id: 4b2ed710-ef92-11e8-83e3-a0999b0f94e3

X-Influxdb-Build: OSS

X-Influxdb-Version: 1.7.0~n201811230800

X-Request-Id: 4b2ed710-ef92-11e8-83e3-a0999b0f94e3

Date: Sat, 24 Nov 2018 02:40:24 GMT

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.