Pivotal GemFireXD*Web

GemFireXD*Web is New Browser-based Database Schema Management Tool Available for Pivotal GemFireXD which allows users to view/alter schema objects as well as GemFireXD schema objects.

GemFireXDWeb is a translation of phpmyadmin to GemFireXD and the GemFireXDWeb UI is base on the look and feel of phpmyadmin.

GemFireXD*Web Supports the following features

• Browse / Administer HDFS Stores
• Browse / Administer HDFS Tables
• Browse / Administer Schema Objects
• Auto Login without going through the Login Page
• Disconnect GemFireXD*Web JDBC Connections from GemFireXD
• Schema Creation Dialogs
• New Table Viewer to view everything about a table including sample data
• Grant table / program unit privileges when AUTHENTICATION is enabled
• JMX Mbean Monitoring
• Save Query Results in CSV or JSON format
• View member start properties
• SQL Worksheet to load/execute SQL DML/DDL statements
• View memory Usage for Tables/Indexes
• View data distribution for Tables across members and SQL queries
• Stop/Start Gateway senders / Async Event Listeners

Download

Download GemFireXD*Web using the link below.

Current GA release 1.0, supports GemFireXD 1.3 - gfxdw.war

Deployment via WAR file

The following is based on deployment to Pivotal tcServer

1. Download WAR via link above
2. Create / Start instance

> ./tcruntime-instance.sh create gfxdw
> ./tcruntime-ctl.sh gfxdw start

3. Copy gfxdw.war to $TCSERVER_HOME/gfxdw/webapps

4. Access as follows

http://{server-ip-address}:{server-port}/gfxdw/

Deployment via Template with Pivotal tcServer

1. Download the template zip from the location below.

gemfirexdweb.zip

2. Extract it in your $TCSERVER_HOME/templates directory

3. Create new instance based on this template

./tcruntime-instance.sh create --template gemfirexdweb {instance-name}

Example:

./tcruntime-instance.sh create --template gemfirexdweb gfxdwtemplate

4. Start tcServer instance

./tcruntime-ctl.sh gfxdwtemplate start

5. Browse app it should be started automatically

http://{server-ip-address}:{server-port}/gfxdwtemplate/

Enabling JMX monitoring

1. Start a locator using the following syntax to add jolokia-jvm-1.2.2-agent.jar

gfxd locator start -peer-discovery-address=$IP -peer-discovery-port=41111 \
-jmx-manager-port=1103 -jmx-manager-start=true -jmx-manager-http-port=7075 \
-conserve-sockets=false -client-bind-address=$IP \ 
-client-port=1527 -dir=locator -sync=false \
-J-javaagent:$CURRENT_DIR/lib/jolokia-jvm-1.2.2-agent.jar=host=0.0.0.0

2. Download jolokia-jvm-1.2.2-agent.jar from the link below.

http://www.jolokia.org/download.html

Saving Query Results

GemFireXD*Web allows you to save query results in CSV or JSON format. The output for each is as follows. This could be a whole table or simply a restricted view of the table using a where clause for example.

CSV

"EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO"
"7369","SMITH","CLERK","7902","17-Dec-1980","800","","20"
"7566","JONES","MANAGER","7839","02-Apr-1981","2975","","20"
"7788","SCOTT","ANALYST","7566","09-Dec-1982","3000","","20"
"7876","ADAMS","CLERK","7788","12-Jan-1983","1100","","20"
"7902","FORD","ANALYST","7566","03-Dec-1981","3000","","20"

JSON

{"fields":[{"name":"DEPTNO","type":"INTEGER"},{"name":"DNAME","type":"VARCHAR"},
{"name":"LOC","type":"VARCHAR"}],"records":[[10,"ACCOUNTING","NEW YORK"],
[20,"RESEARCH","DALLAS"],[30,"SALES","CHICAGO"],[40,"OPERATIONS","BRISBANE"],
[50,"MARKETING","ADELAIDE"],[60,"DEV","PERTH"],[70,"SUPPORT","SYDNEY"]]}

Created by Pas Apicella - papicella@pivotal.io for Pivotal GemFireXD Schema Management