VMware vFabric SQLFire 1.0 User guide

vFabric SQLFire User's Guide

VMware vFabric SQLFire 1.0.3

VMware vFabric Suite 5.1

This document supports the version of each product listed and

supports all subsequent versions until the document is replaced by

a new edition. To check for more recent editions of this document,

see http://www.vmware.com/support/pubs.

EN-000663-00

You can find the most up-to-date technical documentation on the VMware Web site

at: http://www.vmware.com/support/

The VMware Web site also provides the latest product updates. If you have comments

about this documentation, submit your feedback to: docfeedback@vmware.com

Copyright

©

and international copyright and intellectual property laws.VMware products are

covered by one or more patents listed at http://www.vmware.com/go/patents

VMware is a registered trademark or trademark of VMware, Inc. in the United States

and/or other jurisdictions. All other marks and names mentioned herein may be

trademarks of their respective companies.

VMware, Inc.

3401 Hillview Ave.

Palo Alto, CA 94304

Contents

About the SQLFire User's Guide.................................................................................13

Supported Configurations and System Requirements.............................................15

Part I: Getting Started with vFabric SQLFire............................................1

Chapter 1: Overview of vFabric SQLFire..................................................3

Data Flow Diagram.......................................................................................................................................4

GemFire, Apache Derby, and SQL Components..........................................................................................4

Chapter 2: Understanding the SQLFire Distributed System...................7

vFabric SQLFire Members............................................................................................................................7

Servers, Peer Clients, and Server Groups....................................................................................................8

Discovery Mechanisms.................................................................................................................................8

Group Membership Service..........................................................................................................................8

Replicated Tables and Partitioned Tables.....................................................................................................9

Parallel Execution of Data-Aware Stored Procedures...................................................................................9

Cache Plug-ins for External Data Connections..........................................................................................10

Chapter 3: Installing vFabric SQLFire.....................................................11

Installation Note for vFabric Suite Customers.............................................................................................11

RHEL Only: Install vFabric SQLFire from the VMWare YUM Repository....................................................11

Install vFabric SQLFire from a JAR File......................................................................................................13

Chapter 4: Activating vFabric SQLFire Licensing.................................15

Understand vFabric SQLFire License Options...........................................................................................15

Choose a License Option Based on Topology............................................................................................16

How vFabric SQLFire Manages Licensing..................................................................................................18

Install and Configure vFabric SQLFire Licenses.........................................................................................19

Verify Your License and Check Your License Usage...................................................................................21

Chapter 5: Upgrading vFabric SQLFire..................................................23

RHEL Only: Upgrade vFabric SQLFire from the VMWare YUM Repository...............................................23

Upgrade Issues...........................................................................................................................................24

Chapter 6: Connect to vFabric SQLFire with JDBC Tools.....................25

Chapter 7: Tutorials..................................................................................27

Main Steps..................................................................................................................................................27

Create a SQLFire Cluster...........................................................................................................................27

Connect to the Cluster Using SQLF...........................................................................................................29

Create Replicated Tables and Execute Queries.........................................................................................30

iii

Implement a Partitioning Strategy...............................................................................................................31

Persist Tables to Disk..................................................................................................................................34

Add Servers to the Cluster and Stop Servers.............................................................................................35

Perform Additional Tasks............................................................................................................................36

Chapter 8: vFabric SQLFire Features and Benefits...............................37

Part II: Managing Your Data in vFabric SQLFire.....................................39

Chapter 9: Designing vFabric SQLFire Databases................................41

Design Principles of Scalable, Partition-Aware Databases.........................................................................41

Identify Entity Groups and Partitioning Keys...............................................................................................41

Replicate Code Tables................................................................................................................................42

Dealing with Many-to-Many Relationships..................................................................................................42

Example: Adapting a Database Schema for SQLFire.................................................................................43

Chapter 10: Using Server Groups to Manage Data................................47

Server Groups Overview.............................................................................................................................47

Adding Members to Server Groups............................................................................................................49

Assigning Tables to Server Groups.............................................................................................................50

Chapter 11: Partitioning Tables...............................................................51

How Table Partitioning Works.....................................................................................................................51

Understanding Where Data Is Stored.........................................................................................................52

Failure and Redundancy.............................................................................................................................53

Creating Partitioned Tables.........................................................................................................................54

Rebalancing Partitioned Data on SQLFire Members..................................................................................59

Managing Replication Failures....................................................................................................................60

Chapter 12: Replicating Tables................................................................61

How SQLFire Replicates Tables.................................................................................................................61

Deciding When to Use Replicated Tables...................................................................................................61

Creating Replicated Tables.........................................................................................................................62

Chapter 13: Estimating Memory Requirements.....................................63

Estimating SQLFire Overhead....................................................................................................................63

Viewing Memory Usage in SYS.MEMORYANALYTICS..............................................................................64

Chapter 14: Using Disk Stores to Persist Data......................................69

Overview of Disk Stores..............................................................................................................................69

Guidelines for Designing Disk Stores.........................................................................................................74

Creating a Disk Store or Using the Default.................................................................................................75

Persist Table Data to a Disk Store...............................................................................................................76

Optimizing Availability and Performance.....................................................................................................77

Starting System with Disk Stores................................................................................................................77

vFabric SQLFire User's Guideiv

Disk Store Management.............................................................................................................................79

Chapter 15: Exporting and Importing Data with vFabric SQLFire.......89

Using SQLF Commands to Export and Import Data..................................................................................89

Using Apache DdlUtils to Import Data........................................................................................................91

Exporting and Importing Data from Text Files.............................................................................................94

Chapter 16:Using Table Functions to Import Data as a SQLFire Tables.95

Overview of SQLFire Table Functions.........................................................................................................95

Example Table Function..............................................................................................................................97

Part III: Developing Applications with SQLFire......................................99

Chapter 17:Starting SQLFire Servers with the FabricServer Interface.101

Starting a Network Server........................................................................................................................102

Chapter 18: Developing Java Clients and Peers..................................105

Connect to a SQLFire Server with the Thin Client JDBC Driver...............................................................105

Start a SQLFire Peer with the Peer Client JDBC Driver...........................................................................107

Chapter 19: Configuring SQLFire as a JDBC Datasource..................109

Chapter 20: Storing and Loading JAR Files in SQLFire......................111

Class Loading Overview...........................................................................................................................111

Alternate Methods for Managing JAR Files..............................................................................................113

Chapter 21: Developing ADO.NET Client Applications.......................117

About the ADO.NET Driver.......................................................................................................................117

ADO.NET Driver Classes..........................................................................................................................118

Installing and Using the ADO.NET driver..................................................................................................119

Connecting to SQLFire with the ADO.NET Driver....................................................................................119

Managing Connections.............................................................................................................................120

Executing SQL Commands.......................................................................................................................120

Working with Result Sets..........................................................................................................................121

Storing a Table..........................................................................................................................................122

Storing Multiple Tables..............................................................................................................................123

Specifying Command Parameters with SQLFParameter..........................................................................124

Updating Row Data...................................................................................................................................125

Adding Rows to a Table............................................................................................................................126

Managing SQLFire Transactions...............................................................................................................127

Performing Batch Updates........................................................................................................................128

Generic Coding with the SQLFire ADO.NET Driver..................................................................................129

Chapter 22: Using SQLFire.NET Designer...........................................133

Installing SQLFire.NET Designer..............................................................................................................133

v

Contents

Connecting to a SQLFire Distributed System...........................................................................................133

Editing Tables............................................................................................................................................134

Chapter 23: Understanding the Data Consistency Model...................135

Data Consistency Concepts.....................................................................................................................135

No Ordering Guarantee for DML in Separate Threads.............................................................................136

Updates on Any Row Are Atomic and Isolated.........................................................................................136

Atomicity for Bulk Updates........................................................................................................................136

Chapter 24: Using Distributed Transactions in Your Applications.....137

Overview of SQLFire Distributed Transactions.........................................................................................137

Sequence of Events for a Distributed Transaction....................................................................................140

SQLFire Transaction Design.....................................................................................................................141

Best Practices for Using Transactions.......................................................................................................141

Transaction Functionality and Limitations.................................................................................................142

Chapter 25: Using Data-Aware Stored Procedures.............................143

Configuring a Procedure...........................................................................................................................143

Configuring a Custom Result Processor...................................................................................................144

Invoking a Procedure................................................................................................................................145

Example JDBC Client...............................................................................................................................146

Chapter 26: Using the Procedure Provider API....................................149

Procedure Parameters..............................................................................................................................149

Populating OUT and INOUT Parameters..................................................................................................150

Populating Result Sets..............................................................................................................................150

Using the <local> and <global> Escape Syntax with Nested Queries......................................................152

Chapter 27: Using the Custom Result Processor API.........................153

Implementing the ProcedureResultProcessor Interface ..........................................................................153

Example Result Processor: MergeSort.....................................................................................................153

Chapter 28: Programming User-Defined Types....................................157

Chapter 29: Using Result Sets and Cursors........................................161

Non-updatable, Forward-Only Result Sets...............................................................................................161

Updatable Result Sets..............................................................................................................................162

Scrollable Insensitive Result Sets.............................................................................................................167

Result Sets and Autocommit.....................................................................................................................168

Holdable Result Sets................................................................................................................................168

Part IV: Caching Data with vFabric SQLFire.........................................171

Chapter 30: SQLFire Cache Strategies.................................................173

vFabric SQLFire User's Guidevi

Chapter 31: Using a RowLoader to Load Existing Data......................175

How SQLFire Invokes a RowLoader.........................................................................................................175

Implementing the RowLoader Interface....................................................................................................176

Using the JDBCRowLoader Example.......................................................................................................176

Chapter 32: Evicting Table Data from SQLFire.....................................179

How LRU Eviction Works..........................................................................................................................179

Limitations of Eviction...............................................................................................................................179

Eviction in Partitioned Tables....................................................................................................................180

Create a Table with Eviction Settings........................................................................................................180

Chapter 33: Handling DML Events Synchronously.............................183

Writer and Listener Cache Plug-ins..........................................................................................................183

Example Writer Implementation................................................................................................................184

Example Listener Implementation............................................................................................................184

Chapter 34: Handling DML Events Asynchronously..........................185

How the AsyncEventListener Works.........................................................................................................185

Implementation Requirements..................................................................................................................186

Implementing an AsyncEventListener.......................................................................................................186

Chapter 35: Using DBSynchronizer to Apply DML to an RDBMS......191

How DBSynchronizer Works.....................................................................................................................191

Restrictions and Limitations......................................................................................................................192

Configuring DBSynchronizer....................................................................................................................193

Chapter 36:Suppressing Event Callbacks for a vFabric SQLFire Connection.197

Part V: Deploying vFabric SQLFire........................................................199

Chapter 37: SQLFire Deployment Models............................................201

Embedded Peer-to-Peer Deployment.......................................................................................................202

Client-Server Deployment.........................................................................................................................204

Multi-site Deployment...............................................................................................................................205

Chapter 38: Steps to Plan and Configure a Deployment....................209

Chapter 39: Configuring Discovery Mechanisms................................211

Using Locators..........................................................................................................................................211

Configure Multicast Discovery..................................................................................................................213

Chapter 40: Starting and Configuring SQLFire Servers.....................215

Start and Stop SQLFire Servers Using sqlf..............................................................................................215

Specify the Server Working Directory.......................................................................................................216

vii

Contents

Specify Client Connection Information......................................................................................................216

Define Server Groups...............................................................................................................................216

Execute SQL When You Start a Server.....................................................................................................217

Using Additional Boot Properties..............................................................................................................217

Chapter 41: Configuring Multi-site (WAN) Deployments.....................219

About Gateways........................................................................................................................................219

About High Availability for WAN Deployments..........................................................................................221

Limitations of Multi-Site Replication..........................................................................................................222

Prerequisites for WAN Replication............................................................................................................223

Steps to Configure a Multi-site Deployment..............................................................................................223

Chapter 42: Configuring Authentication and Authorization...............229

Configuring User Authentication...............................................................................................................229

User Names in Authentication and Authorization ....................................................................................237

Configuring User Authorization.................................................................................................................238

Configuring Network Encryption and Authentication with SSL/TLS..........................................................242

Part VI: Managing and Monitoring vFabric SQLFire............................247

Chapter 43: Configuring and Using SQLFire Log Files.......................249

Log Message Format................................................................................................................................249

Severity Levels..........................................................................................................................................249

Using java.util.logging.Logger for Application Log Messages...................................................................250

Using Trace Flags for Advanced Debugging.............................................................................................250

Chapter 44: Querying SQLFire System Tables and Indexes...............253

Getting Information About SQLFire Members..........................................................................................253

Getting Information About User Tables.....................................................................................................254

Chapter 45:Evaluating Query Execution Plans and Query Statistics.259

Capture the Query Execution Plan for Individual Statements...................................................................259

Capture Query Execution Plans for All Statements..................................................................................260

View Query Plans and Statistics...............................................................................................................260

SQLFire Query Execution Plan Codes.....................................................................................................262

Chapter 46: Overriding Optimizer Choices..........................................265

Chapter 47: Evaluating System and Application Performance..........269

Collecting System Statistics......................................................................................................................269

Collecting Application Statistics................................................................................................................270

Using VSD to Analyze Statistics...............................................................................................................270

Chapter 48: Using Java Management Extensions (JMX)....................281

Overview of the vFabric SQLFire JMX Agent...........................................................................................281

vFabric SQLFire User's Guideviii

Example Configuration.............................................................................................................................281

Starting the JMX Agent.............................................................................................................................282

Stopping the JMX Agent...........................................................................................................................286

Configuring JMX Connectors and Adapters.............................................................................................286

SSL Communication Properties................................................................................................................288

vFabric SQLFire MBeans..........................................................................................................................288

Chapter 49: Best Practices for Tuning Performance...........................291

Tune Application Logic..............................................................................................................................291

Reduce Distribution Overhead..................................................................................................................291

Reduce Overhead of Eviction to Disk.......................................................................................................292

Minimize Update Latency for Replicated Tables.......................................................................................292

Tune FabricServers...................................................................................................................................292

Tuning Disk I/O.........................................................................................................................................293

Running SQLFire in Virtualized Environments..........................................................................................294

Chapter 50:Detecting and Handling Network Segmentation ("Split Brain").295

Part VII: vFabric SQLFire Reference......................................................297

Chapter 51: Configuration Properties..................................................299

Chapter 52: JDBC API............................................................................331

Mapping java.sql.Types to SQL Types......................................................................................................331

java.sql.BatchUpdateException Class......................................................................................................332

java.sql.Connection Interface....................................................................................................................332

java.sql.DatabaseMetaData Interface.......................................................................................................333

java.sql.Driver Interface............................................................................................................................335

java.sql.DriverManager.getConnection Method........................................................................................335

java.sql.PreparedStatement Interface.......................................................................................................335

java.sql.ResultSet Interface......................................................................................................................337

java.sql.SavePoint Class...........................................................................................................................337

java.sql.SQLException Class....................................................................................................................337

java.sql.Statement Class..........................................................................................................................337

javax.sql.XADataSource...........................................................................................................................337

Chapter 53: sqlf Launcher Commands................................................339

sqlf backup................................................................................................................................................340

sqlf compact-all-disk-stores......................................................................................................................343

sqlf compact-disk-store.............................................................................................................................344

sqlf encrypt-password...............................................................................................................................345

sqlf install-jar.............................................................................................................................................345

sqlf list-missing-disk-stores.......................................................................................................................348

sqlf locator................................................................................................................................................349

sqlf Logging Support.................................................................................................................................352

ix

Contents

sqlf merge-logs.........................................................................................................................................353

sqlf remove-jar..........................................................................................................................................353

sqlf replace-jar..........................................................................................................................................355

sqlf revoke-missing-disk-store...................................................................................................................358

sqlf server.................................................................................................................................................359

sqlf shut-down-all......................................................................................................................................368

sqlf stats....................................................................................................................................................369

sqlf validate-disk-store..............................................................................................................................372

sqlf version................................................................................................................................................373

sqlf write-data-dtd-to-file...........................................................................................................................373

sqlf write-data-to-db..................................................................................................................................376

sqlf write-data-to-xml................................................................................................................................380

sqlf write-schema-to-db............................................................................................................................384

sqlf write-schema-to-sql............................................................................................................................388

sqlf write-schema-to-xml...........................................................................................................................392

Chapter 54: sqlf Interactive Commands...............................................397

absolute ...................................................................................................................................................397

after last ...................................................................................................................................................398

async .......................................................................................................................................................399

autocommit ..............................................................................................................................................399

before first ................................................................................................................................................400

close ........................................................................................................................................................400

commit .....................................................................................................................................................401

connect ....................................................................................................................................................401

connect client ...........................................................................................................................................402

connect peer ............................................................................................................................................403

describe ...................................................................................................................................................403

disconnect ................................................................................................................................................404

driver ........................................................................................................................................................404

elapsedtime .............................................................................................................................................405

execute ....................................................................................................................................................406

exit ...........................................................................................................................................................407

first............................................................................................................................................................407

get scroll insensitive cursor.......................................................................................................................408

GetCurrentRowNumber ...........................................................................................................................410

help ..........................................................................................................................................................410

last ...........................................................................................................................................................410

LocalizedDisplay.......................................................................................................................................411

MaximumDisplayWidth.............................................................................................................................412

next...........................................................................................................................................................412

prepare ....................................................................................................................................................413

previous....................................................................................................................................................414

protocol.....................................................................................................................................................415

relative......................................................................................................................................................415

remove......................................................................................................................................................416

vFabric SQLFire User's Guidex

rollback......................................................................................................................................................417

run.............................................................................................................................................................418

set connection...........................................................................................................................................418

show..........................................................................................................................................................419

wait for......................................................................................................................................................422

Chapter 55: SQLFire API........................................................................423

CredentialInitializer...................................................................................................................................424

UserAuthenticator.....................................................................................................................................424

Procedure Implementation Interfaces.......................................................................................................424

Procedure Result Processor Interfaces....................................................................................................426

Chapter 56: SQL Language Reference.................................................431

Keywords and Identifiers...........................................................................................................................431

SQL Statements.......................................................................................................................................432

SQL Clauses.............................................................................................................................................489

SQL Expressions......................................................................................................................................493

JOIN Operations.......................................................................................................................................506

Built-in Functions......................................................................................................................................508

Built-in System Procedures......................................................................................................................550

Data Types................................................................................................................................................573

SQL Standards Conformance...................................................................................................................584

Chapter 57: System Tables.....................................................................605

ASYNCEVENTLISTENERS table.............................................................................................................605

GATEWAYRECEIVERS table...................................................................................................................606

GATEWAYSENDERS table.......................................................................................................................607

MEMBERS system table...........................................................................................................................608

MEMORYANALYTICS system table..........................................................................................................609

STATEMENTPLANS system table............................................................................................................609

SYSALIASES system table.......................................................................................................................610

SYSCHECKS system table.......................................................................................................................610

SYSCOLPERMS system table.................................................................................................................611

SYSCOLUMNS system table....................................................................................................................612

SYSCONGLOMERATES system table.....................................................................................................613

SYSCONSTRAINTS system table............................................................................................................613

SYSDEPENDS system table....................................................................................................................614

SYSDISKSTORES system table..............................................................................................................615

SYSFILES system table............................................................................................................................615

SYSFOREIGNKEYS system table............................................................................................................616

SYSKEYS system table............................................................................................................................616

SYSROLES system table.........................................................................................................................617

SYSROUTINEPERMS system table.........................................................................................................618

SYSSCHEMAS system table....................................................................................................................619

SYSSTATEMENTS system table..............................................................................................................619

SYSSTATISTICS system table..................................................................................................................620

xi

Contents

SYSTABLEPERMS system table..............................................................................................................620

SYSTABLES system table........................................................................................................................622

SYSTRIGGERS system table...................................................................................................................624

SYSVIEWS system table..........................................................................................................................625

Chapter 58: Exception Messages and SQL States..............................627

Chapter 59: ADO.NET Driver Reference...............................................631

SQLFire Data Types in ADO.NET.............................................................................................................631

VMware.Data.SQLFire.BatchUpdateException........................................................................................631

VMWare.Data.SQLFire.SQLFClientConnection.......................................................................................631

VMware.Data.SQLFire.SQLFCommand...................................................................................................636

VMware.Data.SQLFire.SQLFCommandBuilder........................................................................................642

VMware.Data.SQLFire.SQLFType............................................................................................................642

VMware.Data.SQLFire.SQLFDataAdapter...............................................................................................643

VMware.Data.SQLFire.SQLFDataReader................................................................................................645

VMware.Data.SQLFire.SQLFException....................................................................................................647

VMware.Data.SQLFire.SQLFParameter...................................................................................................648

VMware.Data.SQLFire.SQLFParameterCollection...................................................................................648

VMware.Data.SQLFire.SQLFTransaction.................................................................................................649

Chapter 60: vFabric SQLFire Limitations.............................................653

SQL Language Limitations.......................................................................................................................653

ADO.NET Driver Limitations.....................................................................................................................660

Troubleshooting Common Problems........................................................................663

vFabric SQLFire Glossary..........................................................................................665

vFabric SQLFire User's Guidexii

About the SQLFire User's Guide

Revised July 31, 2012.

The SQLFire User's Guide provides step-by-step procedures for installing, conﬁguring, managing, and developing

applications with VMware

®

vFabric

™

SQLFire. The guide also provides a complete reference for the SQLFire

tools, supported SQL statements, and APIs.

Intended Audience

The SQLFire User's Guide is intended for anyone who wants to install or deploy SQLFire, and for developers

who want to program applications that access a SQLFire system and/or implement SQLFire APIs. The guide

assumes that you are familiar with SQL databases and database terminology, and that you have experience in

developing database applications using Java or .NET technologies.

13

Supported Configurations and System

Requirements

Before installing vFabric SQLFire, make sure your system meets the minimum system requirements for installing

and running the product.

Before installing vFabric SQLFire, make sure your system meets the minimum system requirements for installing

and running the product.

• Supported Conﬁgurations on page 15

• Host Machine Requirements on page 16

• Increase Unicast Buffer Size on Linux Platforms on page 16

• Disable SYN Cookies on Linux Platforms on page 16

• Client Requirements on page 16

Supported Configurations

The following table shows all supported conﬁgurations for vFabric SQLFire. These include vFabric Suite

supported conﬁgurations, as well as additional conﬁgurations supported by standalone vFabric SQLFire.

Note:

The tables indicate whether the supported conﬁguration is for production or development. Generally,

production support means you can run your production application on the platform; developer support

means you can develop on the platform but you should not run your production application on it.

Production or Developer SupportJVMProcessor

Architecture

Operating System

ProductionJava SE 6, update 0_26x86_64, x86_32Red Hat EL 5

ProductionJava SE 6, update 0_26x86_64, x86_32Red Hat EL 6

ProductionJava SE 6, update 0_26x86_64, x86_32Windows Server 2003 R2

SP2 Professional or

Enterprise*

ProductionJava SE 6, update 0_26x86_64, x86_32Windows Server 2008 R2

Standard*

DeveloperJava SE 6, update 0_26x86_64, x86_32Windows 7 SP1

Professional or

Enterprise*

DeveloperJava SE 6x86_64Windows XP

DeveloperJava SE 6x86_64Ubuntu 10.x, 11.x**

*The Microsoft Loopback Adapter is not supported.

**Only stable and non-EOL releases supported.

Note: The SQLFire product download does not include Java; you must download and install a supported

JDK for your system.

15

Host Machine Requirements

Requirements for each host:

• A supported Java SE installation.

• File system that supports long ﬁle names.

• Adequate per-user quota of ﬁle handles (ulimit for Linux)

• TCP/IP.

• System clock set to the correct time.

•

For each Linux host, the hostname and host ﬁles must be properly conﬁgured. See the system manpages

for hostname and hosts.

• Time synchronization service such as Network Time Protocol (NTP).

Note: For troubleshooting, you must run a time synchronization service on all hosts. Synchronized time

stamps allow you to merge log messages from different hosts, for an accurate chronological history of a

distributed run.

Increase Unicast Buffer Size on Linux Platforms

On Linux platforms, execute the following commands as the root user to increase the unicast buffer size:

sysctl -w net.core.rmem_max=1048576

sysctl -w net.core.wmem_max=1048576

Disable SYN Cookies on Linux Platforms

Many default Linux installations use SYN cookies to protect the system against malicious attacks that ﬂood

TCP SYN packets. The use of SYN cookies dramatically reduces network bandwidth, and can be triggered by

a running SQLFire distributed system.

If your SQLFire distributed system is otherwise protected against such attacks, disable SYN cookies to ensure

that SQLFire network throughput is not affected.

To disable SYN cookies permanently:

1.

Edit the /etc/sysctl.conf ﬁle to include the following line:

net.ipv4.tcp_syncookies = 0

Setting this value to zero disables SYN cookies.

2.

Reload sysctl.conf:

sysctl -p

Client Requirements

SQLFire supports two JDBC drivers: a thin client JDBC driver and a peer JDBC driver. SQLFire server instances

and the peer driver are supported only with Java SE 6. You can download Java from

http://www.oracle.com/technetwork/java/javase/downloads/index.htm.

SQLFire provides a managed ADO.NET driver that you can use for developing non-Java client applications.

The ADO.NET driver uses IKVM technology to translate SQLFire JDBC core libraries to .NET MSIL. The

ADO.NET driver is supported for applications built using the Microsoft .NET 2.0 SP1 or higher framework.

vFabric SQLFire User's Guide16

Part 1

Getting Started with vFabric SQLFire

Getting Started with vFabric SQLFire provides step-by-step procedures for installing, conﬁguring, and using VMware

®

vFabric

™

SQLFire. The guide also explains main concepts and provides tutorials to help you quickly begin using

SQLFire.

Topics:

• Overview of vFabric SQLFire

• Understanding the SQLFire Distributed System

• Installing vFabric SQLFire

• Activating vFabric SQLFire Licensing

• Upgrading vFabric SQLFire

• Connect to vFabric SQLFire with JDBC Tools

• Tutorials

• vFabric SQLFire Features and Benefits

1

Chapter 1

Overview of vFabric SQLFire

vFabric SQLFire is a memory-optimized, distributed database management system designed for applications that have

demanding scalability and availability requirements. Applications can manage database tables entirely in memory, or

they can persist tables to disk to reload the data after restarting the system. A SQLFire distributed system can be easily

scaled out using commodity hardware.

3

Data Flow Diagram

GemFire, Apache Derby, and SQL Components

vFabric SQLFire incorporates core vFabric GemFire technology and Apache Derby RDBMS components to

provide a high-performance, distributed database management system. SQLFire extends standard SQL statements

where necessary for creating and managing tables and conﬁguring the SQLFire system.

The sections that follow document how SQLFire utilizes the GemFire and Derby component functionality.

vFabric GemFire Technology

vFabric SQLFire incorporates the following VMware vFabric GemFire technology:

• Reliable data distribution

• High performance replication and partitioning

• Caching framework

• Parallel 'data-aware' application behavior routing

vFabric SQLFire User's Guide4

Getting Started with vFabric SQLFire

Page is loading ...

VMware vFabric SQLFire 1.0 User guide

VMware vFabric SQLFire 1.0 User guide

Related papers

Other documents