IGNITE-843 Updated README.txt
Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/39224cb1 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/39224cb1 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/39224cb1 Branch: refs/heads/ignite-843 Commit: 39224cb15f175755b04a46424d21787a687a6157 Parents: e0f04f9 Author: AKuznetsov <[email protected]> Authored: Fri Sep 4 21:14:54 2015 +0700 Committer: AKuznetsov <[email protected]> Committed: Fri Sep 4 21:14:54 2015 +0700 ---------------------------------------------------------------------- modules/control-center-agent/README.txt | 31 ++++++++++++++++++++++++---- 1 file changed, 27 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ignite/blob/39224cb1/modules/control-center-agent/README.txt ---------------------------------------------------------------------- diff --git a/modules/control-center-agent/README.txt b/modules/control-center-agent/README.txt index 26f116d..f20dfe8 100644 --- a/modules/control-center-agent/README.txt +++ b/modules/control-center-agent/README.txt @@ -1,18 +1,40 @@ Ignite Web Agent ====================================== -Ignite Web Agent is a java standalone application that allow to connect Ignite Grid to Ignite Web Agent. -Ignite Web Agent communicates with grid nodes via REST interface and connects to Ignite Web Agent via web-socket. +Ignite Web Agent is a java standalone application that allow to connect Ignite Grid to Ignite Web Control Center. +Ignite Web Agent communicates with grid nodes via REST interface and connects to Ignite Web Control Center via web-socket. Two main functions of Ignite Web Agent: - 1. Proxy between Ignite Web Agent and Ignite Grid to execute SQL statements and collect metrics for monitoring. + 1. Proxy between Ignite Web Control Center and Ignite Grid to execute SQL statements and collect metrics for monitoring. You may need to specify URI for connect to Ignite REST server via "-n" option. - 2. Proxy between Ignite Web Agent and user RDBMS to collect database metadata for later CacheTypeMetadata configuration. + 2. Proxy between Ignite Web Control Center and user RDBMS to collect database metadata for later CacheTypeMetadata configuration. You may need to copy JDBC driver into "./jdbc-drivers" subfolder or specify path via "-drv" option. Usage example: ignite-control-center-agent.sh -l [email protected] -p qwerty -s wss://control-center.example.com +Test drive of Ignite Web Agent: + In order to simplify evaluation two test drive modes were implemented: + + 1) Test drive for metadata load from database. Activated by option: -tm or --test-drive-metadata. + In this mode an in-memory H2 database will started and could be acessed via JDBC URL: jdbc:h2:mem:test-drive-db. + How to evaluate: go to Ignite Web Control Center "Metadata" screen, select "Load from database" and enter JDBC URL. + You should see list of available schemas and tables. Select some of them and click "Save". + + 2) Test drive for SQL. Activated by option: -ts or --test-drive-sql. + In this mode internal Ignite node will be started. Cache created and populated with data. + How to evaluate: go to Ignite Web Control Center "SQL" menu, create new notebook. + In notebook paragraph enter SQL queries for tables: "Country, Department, Employee" in "test-drive-employee" cache + and for tables: "Parking, Car" in "test-drive-car" cache. + + For example: + 2.1) select "test-drive-car" cache, + 2.2) enter SQL: + select count(*) cnt, p.ParkingName from car c + inner join PARKING p on (p.PARKINGID=c.PARKINGID) + group by c.PARKINGID order by p.ParkingName + 2.3) Click "Execute" button. You should get some data in table. Click charts buttons to see auto generated charts. + Configuration file: Should be a file with simple line-oriented format as described here: http://docs.oracle.com/javase/7/docs/api/java/util/Properties.html#load(java.io.Reader) @@ -28,6 +50,7 @@ Configuration file: Example configuration file: [email protected] serverURI=wss://control-center.example.com:3001 + test-drive-sql=true Options: -h, --help
