Recipe Tsv To Mongo

Looking to get data out of tsv into mongo? You can do that with fluentd in 10 minutes!
Here is how:
1
$ gem install fluentd
2
$ gem install fluent-plugin-mongo
3
$ touch fluentd.conf
Copied!
fluentd.conf should look like this (just copy and paste this into fluentd.conf):
1
<source>
2
  @type tail
3
  path /var/log/httpd-access.log #...or where you placed your Apache access log
4
  pos_file /var/log/td-agent/httpd-access.log.pos # This is where you record file position
5
  tag foobar.tsv #fluentd tag!
6
  format tsv
7
  keys key1, key2, key3 # e.g., user_id, timestamp, action
8
  time_key key2 # Specify the column that you want to use as timestamp
9
</source>
10
​
11
<match **>
12
  @type mongo
13
  database <db name> #(required)
14
  collection <collection name> #(optional; default="untagged")
15
  host <hostname> #(optional; default="localhost")
16
  port <port> #(optional; default=27017)
17
</match>
Copied!
After that, you can start fluentd and everything should work:
1
$ fluentd -c fluentd.conf
Copied!
Of course, this is just a quick example. If you are thinking of running fluentd in production, consider using td-agent, the enterprise version of Fluentd packaged and maintained by Treasure Data, Inc..
If this article is incorrect or outdated, or omits critical information, please let us know. Fluentd is a open source project under Cloud Native Computing Foundation (CNCF). All components are available under the Apache 2 License.

Recipe Tsv To Elasticsearch

Recipe Tsv To S3

Last modified 2yr ago

Copy link