You can graph your MySQL data with 1 line of code

$ crontab -l
*/5 * * * * curl -F number=`mysql -BN -e 'select count(*) from member' game` http://example.com/api/socialgame/member/register 2>&1 | logger -t post_gf -p local0.info

By periodically POSTing to GrowthForecast with cron, you can make charts without having to deal with complex settings

We'll first install the libraries that RRDTool depends on using package managers like yum, apt, homebrew, etc.

• glib
• xml2
• pango
• cairo

CentOS

$ sudo yum groupinstall "Development Tools"
$ sudo yum install pkgconfig glib2-devel gettext libxml2-devel pango-devel cairo-devel

Ubuntu

$ sudo apt-get build-dep rrdtool

We'll use the cpanm command to install GrowthForecast together with its module dependencies.

We recommend that you use Perl built with perlbrew (or others) rather than the default Perl that ships with your OS.

$ cpanm -n GrowthForecast

Please check for version information on CPAN. Installation will take a bit of time since there are a many module dependencies.

You've now installed GrowthForecast! To start GrowthForecast, please execute "growthforecast.pl".

If you run it with the data-dir option (specifying the directory to store the graph data), the web server will start on port 5125. You can verify this in your browser.

Boot Command

$ growthforecast.pl --data-dir /home/user/growthforecast

Other Boot Options

You will need the following permissions when using the --with-mysql option.

• CREATE
• ALTER
• DELETE
• INSERT
• UPDATE
• SELECT

Expamle of GRANT Command

mysql> GRANT  CREATE, ALTER, DELETE, INSERT, UPDATE, SELECT \\
         ON growthforecast.* TO 'www'\@'localhost' IDENTIFIED BY foobar;

Your username and password are set by system environment variables.

$ MYSQL_USER=www MYSQL_PASSWORD=foobar growthforecast.pl \\
      --data-dir /home/user/growthforecast \\
      --with-mysql dbi:mysql:growthforecast;hostname=localhost 

The names of the items within the URL to POST to are shown in the table to the right.

You can use multi-byte strings for each item name as long as it is UTF-8.

GrowthForecast uses RRDtool as a tool for graph drawing and Round Robbin Database.

Data sent to the endpoint of the API is stored temporarily into RDBMS. Worker reads the data from the RDBMS, and update RRD files periodically. In doing so, GrowthForecast worker stores the difference from the previous value as a `subtract` data in addition to the current value.

By utilizing the `subtract` data as a source of the graph, GrowthForecast makes possible to visualize the change of the data.

Parameters on Adding Vertical Line(s)

Example of adding a vertical line

If using curl:

$ curl -F description=deploy -F color=#FF0000 http://example.com/vrule/api/socialgame/member

Parameters on Getting a Vertical Line Data

List of Supported Parameters

You can even make graphs like the one below just by changing the parameters!

http://example.com/graph/service/section/graph?t=d&gmode=gauge&border=0&legend=0&width=200&background_color=333333&canvas_color=333333&font_color=CCCCCC&axis_color=666666

You can export your graph data in JSON format.

Endpoint

URI of the Graph http://example.com/xport/:service_name/:section_name/:graph_name
URI of the Compound Graph http://example.com/xport/:pattern

List of Parameters

fluent-plugin-growthforecast

https://github.com/tagomoris/fluent-plugin-growthforecast
Fluentd plugin to output numbers(metrics) to 'GrowthForecast', metrics drawing tool over HTTP.

rb-growthforecast (ruby)

https://github.com/tagomoris/rb-growthforecast
Client library and command to operate GrowthForecast

growthforecast-client (ruby)

https://github.com/sonots/growthforecast-client
growthforecast-client is a ruby client library for GrowthForecast API where GrowthForecast is a visualization graph tool.

Net::GrowthForecast (perl)

https://metacpan.org/pod/Net::GrowthForecast
A client library for awesome visualization tool GrowthForecast