Page is loading ...
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
©
2012 VMware, Inc. All rights reserved.This product is protected by U.S.
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, configuring, 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 Configurations 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 configurations for vFabric SQLFire. These include vFabric Suite
supported configurations, as well as additional configurations supported by standalone vFabric SQLFire.
Note:
The tables indicate whether the supported configuration 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 file names.
• Adequate per-user quota of file handles (ulimit for Linux)
• TCP/IP.
• System clock set to the correct time.
•
For each Linux host, the hostname and host files must be properly configured. 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 flood
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 file 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, configuring, 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 configuring 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
/
