README.md in fluent-plugin-sql-1.1.1 vs README.md in fluent-plugin-sql-2.0.0

- old
+ new

@@ -3,32 +3,31 @@ ## Overview This SQL plugin has two parts: 1. SQL **input** plugin reads records from RDBMSes periodically. An example use case would be getting "diffs" of a table (based on the "updated_at" field). -2. SQL **output** plugin that writes records into RDBMes. An example use case would be aggregating server/app/sensor logs into RDBMS systems. +2. SQL **output** plugin that writes records into RDBMSes. An example use case would be aggregating server/app/sensor logs into RDBMS systems. ## Requirements | fluent-plugin-sql | fluentd | ruby | |-------------------|------------|--------| | >= 1.0.0 | >= v0.14.4 | >= 2.1 | | < 1.0.0 | < v0.14.0 | >= 1.9 | -NOTE: fluent-plugin-sql v1.0.0 is now RC. We will release stable v1.0.0 soon. +NOTE: fluent-plugin-sql v2's buffer format is different from v1. If you update the plugin to v2, don't reuse v1's buffer. ## Installation $ fluent-gem install fluent-plugin-sql --no-document - $ fluent-gem install pg -v 0.21.0 --no-document # for postgresql + $ fluent-gem install pg --no-document # for postgresql You should install actual RDBMS driver gem together. `pg` gem for postgresql adapter or `mysql2` gem for `mysql2` adapter. Other adapters supported by [ActiveRecord](https://github.com/rails/rails/tree/master/activerecord) should work. We recommend that mysql2 gem is higher than `0.3.12` and pg gem is higher than `0.16.0`. -We must use pg gem 0.21.0 (< 1.0.0) because ActiveRecord 5.0 or later doesn't support Ruby 2.1. -NOTE: ActiveRecord has supported pg 1.0.0 since ActiveRecord 5.1.5. +If you use ruby 2.1, use pg gem 0.21.0 (< 1.0.0) because ActiveRecord 5.1.4 or earlier doesn't support Ruby 2.1. ## Input: How It Works This plugin runs following SQL periodically: @@ -149,12 +148,14 @@ * **database** RDBMS database name * **adapter** RDBMS driver name. You should install corresponding gem before start (mysql2 gem for mysql2 adapter, pg gem for postgresql adapter, etc.) * **username** RDBMS login user name * **password** RDBMS login password * **socket** RDBMS socket path +* **pool** A connection pool synchronizes thread access to a limited number of database connections +* **timeout** RDBMS connection timeout * **remove_tag_prefix** remove the given prefix from the events. See "tag_prefix" in "Input: Configuration". (optional) \<table\> sections: * **table** RDBM table name * **column_mapping**: [Required] Record to table schema mapping. The format is consists of `from:to` or `key` values are separated by `,`. For example, if set 'item_id:id,item_text:data,updated_at' to **column_mapping**, `item_id` field of record is stored into `id` column and `updated_at` field of record is stored into `updated_at` column. -* **<table pattern>**: the pattern to which the incoming event's tag (after it goes through `remove_tag_prefix`, if given). The patterns should follow the same syntax as [that of <match>](http://docs.fluentd.org/articles/config-file#match-pattern-how-you-control-the-event-flow-inside-fluentd). **Exactly one <table> element must NOT have this parameter so that it becomes the default table to store data**. +* **\<table pattern\>**: the pattern to which the incoming event's tag (after it goes through `remove_tag_prefix`, if given). The patterns should follow the same syntax as [that of \<match\>](https://docs.fluentd.org/configuration/config-file#how-match-patterns-work). **Exactly one \<table\> element must NOT have this parameter so that it becomes the default table to store data**.