No description, website, or topics provided.
Java CSS XSLT JavaScript
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src/main
COPYING.txt
LICENSE.txt
README.md
pom.xml

README.md

Pivotal GemFireXD*Web

alt tag

alt tag

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
  1. Copy gfxdw.war to $TCSERVER_HOME/gfxdw/webapps

  2. 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

  1. Extract it in your $TCSERVER_HOME/templates directory

  2. Create new instance based on this template

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

Example:

./tcruntime-instance.sh create --template gemfirexdweb gfxdwtemplate
  1. Start tcServer instance
./tcruntime-ctl.sh gfxdwtemplate start
  1. Browse app it should be started automatically
http://{server-ip-address}:{server-port}/gfxdwtemplate/

alt tag

JVM heap Settings

GemFireXD*Web will run with as low as 512M oif heap memory. It is recommended you run it with at least 1G of memory. For example to increase the memory settings in Pivotal tcServer perform the steps below.

  1. Edit $TCSERVER_HOME/{instance-name}/bin/setenv.sh

  2. Increase memory to 2G of heap as shown below and re-start the instance

JAVA_HOME="/Library/Java/JavaVirtualMachines/jdk1.7.0_60.jdk/Contents/Home"
AGENT_PATHS=""
JAVA_AGENTS=""
JAVA_LIBRARY_PATH=""
JVM_OPTS="-Xms2g -Xmx2g -Xss256K"
JAVA_OPTS="$JVM_OPTS $AGENT_PATHS $JAVA_AGENTS $JAVA_LIBRARY_PATH"

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
  1. Download jolokia-jvm-1.2.2-agent.jar from the link below.
http://www.jolokia.org/download.html

alt tag

alt tag

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"]]}

alt tag

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