Skip to content

Latest commit

 

History

History
103 lines (68 loc) · 3.19 KB

README.md

File metadata and controls

103 lines (68 loc) · 3.19 KB

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
  • 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 due out same time as GemFireXD - 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

Enabling JMX monitoring

  1. Start a locator using the
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

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