Page is loading ...
vFabric SQLFire User's Guide
VMware vFabric SQLFire 1.1
VMware vFabric Suite 5.3
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-001171-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
©
2013 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
vFabric SQLFire in 15 Minutes.....................................................................................................................2
Chapter 1: Overview of vFabric SQLFire..................................................7
Data Flow Diagram.......................................................................................................................................8
GemFire, Apache Derby, and SQL Components..........................................................................................8
Chapter 2: Understanding the SQLFire Distributed System.................11
vFabric SQLFire Members..........................................................................................................................11
Servers, Peer Clients, and Server Groups..................................................................................................12
Discovery Mechanisms...............................................................................................................................12
Group Membership Service........................................................................................................................12
Replicated Tables and Partitioned Tables...................................................................................................13
Parallel Execution of Data-Aware Stored Procedures.................................................................................13
Cache Plug-ins for External Data Connections..........................................................................................14
Chapter 3: Installing vFabric SQLFire.....................................................15
Installation Note for vFabric Suite Customers.............................................................................................15
RHEL Only: Install vFabric SQLFire from an RPM.....................................................................................15
Install vFabric SQLFire from a ZIP File.......................................................................................................19
Chapter 4: Activating vFabric SQLFire Licensing.................................21
Understand vFabric SQLFire License Options...........................................................................................21
Choose a License Option Based on Topology............................................................................................22
How vFabric SQLFire Manages Licensing..................................................................................................24
Install and Configure vFabric SQLFire Licenses.........................................................................................25
Verify Your License and Check Your License Usage...................................................................................27
Chapter 5: Upgrading vFabric SQLFire..................................................29
Before You Upgrade....................................................................................................................................29
RHEL: Upgrade vFabric SQLFire from RPM..............................................................................................30
Upgrade vFabric SQLFire from a ZIP File..................................................................................................31
Version Compatibility Rules........................................................................................................................33
Chapter 6: Connect to vFabric SQLFire with JDBC Tools.....................35
Chapter 7: Tutorials..................................................................................37
Main Steps..................................................................................................................................................37
iii
Create a SQLFire Cluster...........................................................................................................................37
Connect to the Cluster Using SQLF...........................................................................................................39
Create Replicated Tables and Execute Queries.........................................................................................40
Implement a Partitioning Strategy...............................................................................................................41
Persist Tables to Disk..................................................................................................................................43
Add Servers to the Cluster and Stop Servers.............................................................................................45
Perform Additional Tasks............................................................................................................................46
Chapter 8: vFabric SQLFire Features and Benefits...............................47
Part II: Managing Your Data in vFabric SQLFire.....................................49
Chapter 9: Designing vFabric SQLFire Databases................................51
Design Principles of Scalable, Partition-Aware Databases.........................................................................51
Identify Entity Groups and Partitioning Keys...............................................................................................51
Replicate Code Tables................................................................................................................................52
Dealing with Many-to-Many Relationships..................................................................................................52
Example: Adapting a Database Schema for SQLFire.................................................................................53
Chapter 10: Using Server Groups to Manage Data................................57
Server Groups Overview.............................................................................................................................57
Adding Members to Server Groups............................................................................................................59
Assigning Tables to Server Groups.............................................................................................................60
Chapter 11: Partitioning Tables...............................................................61
How Table Partitioning Works.....................................................................................................................61
Understanding Where Data Is Stored.........................................................................................................62
Failure and Redundancy.............................................................................................................................63
Creating Partitioned Tables.........................................................................................................................64
Rebalancing Partitioned Data on SQLFire Members..................................................................................69
Managing Replication Failures....................................................................................................................70
Chapter 12: Replicating Tables................................................................71
How SQLFire Replicates Tables.................................................................................................................71
Deciding When to Use Replicated Tables...................................................................................................71
Creating Replicated Tables.........................................................................................................................72
Chapter 13: Estimating Memory Requirements.....................................73
Estimating SQLFire Overhead....................................................................................................................73
Viewing Memory Usage in SYS.MEMORYANALYTICS..............................................................................74
Chapter 14: Using Disk Stores to Persist Data......................................79
Overview of Disk Stores..............................................................................................................................79
Guidelines for Designing Disk Stores.........................................................................................................85
Creating a Disk Store or Using the Default.................................................................................................86
vFabric SQLFire User's Guideiv
Persist Table Data to a Disk Store...............................................................................................................86
Optimizing Availability and Performance.....................................................................................................87
Starting System with Disk Stores................................................................................................................87
Disk Store Management.............................................................................................................................90
Chapter 15: Exporting and Importing Data with vFabric SQLFire.......99
Using SQLF Commands to Export and Import Data..................................................................................99
Using Apache DdlUtils to Import Data......................................................................................................101
Exporting and Importing Data from Text Files...........................................................................................104
Chapter 16:Using Table Functions to Import Data as a SQLFire Tables.107
Overview of SQLFire Table Functions.......................................................................................................107
Example Table Function............................................................................................................................109
Part III: Developing Applications with SQLFire....................................111
Chapter 17:Starting SQLFire Servers with the FabricServer Interface.113
Starting a Network Server........................................................................................................................114
Chapter 18: Developing Java Clients and Peers..................................117
Connect to a SQLFire Server with the Thin Client JDBC Driver...............................................................117
Start a SQLFire Peer with the Peer Client JDBC Driver...........................................................................120
Chapter 19: Configuring SQLFire as a JDBC Datasource..................123
Using SQLFire with Hibernate..................................................................................................................112
Chapter 20: Storing and Loading JAR Files in SQLFire......................125
Class Loading Overview...........................................................................................................................125
Alternate Methods for Managing JAR Files..............................................................................................127
Chapter 21: Developing ADO.NET Client Applications.......................131
About the ADO.NET Driver.......................................................................................................................131
ADO.NET Driver Classes..........................................................................................................................132
Installing and Using the ADO.NET driver..................................................................................................133
Connecting to SQLFire with the ADO.NET Driver....................................................................................134
Managing Connections.............................................................................................................................134
Executing SQL Commands.......................................................................................................................135
Working with Result Sets..........................................................................................................................135
Storing a Table..........................................................................................................................................136
Storing Multiple Tables..............................................................................................................................137
Specifying Command Parameters with SQLFParameter..........................................................................138
Updating Row Data...................................................................................................................................139
Adding Rows to a Table............................................................................................................................140
Managing SQLFire Transactions...............................................................................................................141
Performing Batch Updates........................................................................................................................142
v
Contents
Generic Coding with the SQLFire ADO.NET Driver..................................................................................143
Chapter 22: Using SQLFire.NET Designer...........................................147
Installing SQLFire.NET Designer..............................................................................................................147
Connecting to a SQLFire Distributed System...........................................................................................147
Editing Tables............................................................................................................................................148
Chapter 23: Understanding the Data Consistency Model...................149
Data Consistency Concepts.....................................................................................................................149
No Ordering Guarantee for DML in Separate Threads.............................................................................150
Updates on Any Row Are Atomic and Isolated.........................................................................................150
Atomicity for Bulk Updates........................................................................................................................150
Chapter 24: Using Distributed Transactions in Your Applications.....151
Overview of SQLFire Distributed Transactions.........................................................................................151
Sequence of Events for a Distributed Transaction....................................................................................154
SQLFire Transaction Design.....................................................................................................................155
Best Practices for Using Transactions.......................................................................................................155
Transaction Functionality and Limitations.................................................................................................156
Chapter 25: Using Data-Aware Stored Procedures.............................157
Configuring a Procedure...........................................................................................................................157
Configuring a Custom Result Processor...................................................................................................158
Invoking a Procedure................................................................................................................................159
Example JDBC Client...............................................................................................................................160
Chapter 26: Using the Procedure Provider API....................................163
Procedure Parameters..............................................................................................................................163
Populating OUT and INOUT Parameters..................................................................................................164
Populating Result Sets..............................................................................................................................164
Using the <local> and <global> Escape Syntax with Nested Queries......................................................166
Chapter 27: Using the Custom Result Processor API.........................167
Implementing the ProcedureResultProcessor Interface ..........................................................................167
Example Result Processor: MergeSort.....................................................................................................167
Chapter 28: Programming User-Defined Types....................................171
Chapter 29: Using Result Sets and Cursors........................................175
Non-updatable, Forward-Only Result Sets...............................................................................................175
Updatable Result Sets..............................................................................................................................176
Scrollable Insensitive Result Sets.............................................................................................................181
Result Sets and Autocommit.....................................................................................................................182
Part IV: Caching Data with vFabric SQLFire.........................................183
vFabric SQLFire User's Guidevi
Chapter 30: SQLFire Cache Strategies.................................................185
Chapter 31: Using a RowLoader to Load Existing Data......................187
How SQLFire Invokes a RowLoader.........................................................................................................187
Implementing the RowLoader Interface....................................................................................................188
Using the JDBCRowLoader Example.......................................................................................................188
Chapter 32: Evicting Table Data from SQLFire.....................................191
How LRU Eviction Works..........................................................................................................................191
Limitations of Eviction...............................................................................................................................191
Eviction in Partitioned Tables....................................................................................................................192
Create a Table with Eviction Settings........................................................................................................192
Chapter 33: Handling DML Events Synchronously.............................195
Writer and Listener Cache Plug-ins..........................................................................................................195
Example Writer Implementation................................................................................................................196
Example Listener Implementation............................................................................................................196
Chapter 34: Handling DML Events Asynchronously..........................197
How the AsyncEventListener Works.........................................................................................................197
Implementation Requirements..................................................................................................................197
Implementing an AsyncEventListener.......................................................................................................198
Chapter 35: Using DBSynchronizer to Apply DML to an RDBMS......203
How DBSynchronizer Works.....................................................................................................................203
Restrictions and Limitations......................................................................................................................204
Configuring DBSynchronizer....................................................................................................................205
Chapter 36:Suppressing Event Callbacks for a vFabric SQLFire Connection.209
Part V: Deploying vFabric SQLFire........................................................211
Chapter 37: SQLFire Deployment Models............................................213
Embedded Peer-to-Peer Deployment.......................................................................................................214
Client-Server Deployment.........................................................................................................................216
Multi-site Deployment...............................................................................................................................217
Chapter 38: Steps to Plan and Configure a Deployment....................221
Chapter 39: Configuring Discovery Mechanisms................................223
Using Locators..........................................................................................................................................223
Configure Multicast Discovery..................................................................................................................225
vii
Contents
Chapter 40: Starting and Configuring SQLFire Servers.....................227
Start and Stop SQLFire Servers Using sqlf..............................................................................................227
Specify the Server Working Directory.......................................................................................................228
Specify Client Connection Information......................................................................................................228
Define Server Groups...............................................................................................................................228
Execute SQL When You Start a Server.....................................................................................................229
Using Additional Boot Properties..............................................................................................................229
Chapter 41: Configuring Multi-site (WAN) Deployments.....................231
About Gateways........................................................................................................................................231
About High Availability for WAN Deployments..........................................................................................233
Limitations of Multi-Site Replication..........................................................................................................234
Prerequisites for WAN Replication............................................................................................................235
Steps to Configure a Multi-site Deployment..............................................................................................235
Chapter 42: Configuring Authentication and Authorization...............241
Configuring User Authentication...............................................................................................................241
User Names in Authentication and Authorization ....................................................................................249
Configuring User Authorization.................................................................................................................250
Configuring Network Encryption and Authentication with SSL/TLS..........................................................254
Part VI: Managing and Monitoring vFabric SQLFire............................259
Chapter 43: Configuring and Using SQLFire Log Files.......................261
Log Message Format................................................................................................................................261
Severity Levels..........................................................................................................................................261
Using java.util.logging.Logger for Application Log Messages...................................................................262
Using Trace Flags for Advanced Debugging.............................................................................................262
Chapter 44: Querying SQLFire System Tables and Indexes...............265
Getting Information About SQLFire Members..........................................................................................265
Getting Information About User Tables.....................................................................................................266
Chapter 45: Evaluating Query Plans and Query Statistics.................271
Capture a Query Plan for an Individual Statement...................................................................................271
Capture Query Plans for All Statements...................................................................................................272
Example Query Plan Analysis..................................................................................................................272
Query Plan Codes....................................................................................................................................276
Chapter 46: Overriding Optimizer Choices..........................................279
Chapter 47: Evaluating System and Application Performance..........283
Collecting System Statistics......................................................................................................................283
Collecting Application Statistics................................................................................................................284
vFabric SQLFire User's Guideviii
Using VSD to Analyze Statistics...............................................................................................................284
Chapter 48: Using Java Management Extensions (JMX)....................295
Using a JMX Manager Node.....................................................................................................................295
Using a vFabric SQLFire JMX Agent........................................................................................................298
Chapter 49: Best Practices for Tuning Performance...........................311
Tune Application Logic..............................................................................................................................311
Reduce Distribution Overhead..................................................................................................................311
Reduce Overhead of Eviction to Disk.......................................................................................................312
Minimize Update Latency for Replicated Tables.......................................................................................312
Tune FabricServers...................................................................................................................................312
Tuning Disk I/O.........................................................................................................................................313
Running SQLFire in Virtualized Environments..........................................................................................314
Chapter 50:Detecting and Handling Network Segmentation ("Split Brain").315
Part VII: vFabric SQLFire Reference......................................................317
Chapter 51: Configuration Properties..................................................319
Chapter 52: JDBC API............................................................................357
Mapping java.sql.Types to SQL Types......................................................................................................357
java.sql.BatchUpdateException Class......................................................................................................358
java.sql.Connection Interface....................................................................................................................358
java.sql.DatabaseMetaData Interface.......................................................................................................359
java.sql.Driver Interface............................................................................................................................361
java.sql.DriverManager.getConnection Method........................................................................................361
java.sql.PreparedStatement Interface.......................................................................................................361
java.sql.ResultSet Interface......................................................................................................................363
java.sql.SavePoint Class...........................................................................................................................363
java.sql.SQLException Class....................................................................................................................363
java.sql.Statement Class..........................................................................................................................363
javax.sql.XADataSource...........................................................................................................................363
Chapter 53: sqlf Launcher Commands................................................365
sqlf backup................................................................................................................................................367
sqlf compact-all-disk-stores......................................................................................................................369
sqlf compact-disk-store.............................................................................................................................370
sqlf encrypt-password...............................................................................................................................371
sqlf install-jar.............................................................................................................................................373
sqlf list-missing-disk-stores.......................................................................................................................376
sqlf locator................................................................................................................................................377
sqlf Logging Support.................................................................................................................................382
sqlf merge-logs.........................................................................................................................................382
ix
Contents
sqlf remove-jar..........................................................................................................................................383
sqlf replace-jar..........................................................................................................................................385
sqlf revoke-missing-disk-store...................................................................................................................387
sqlf run......................................................................................................................................................389
sqlf server.................................................................................................................................................391
sqlf show-disk-store-metadata..................................................................................................................402
sqlf shut-down-all......................................................................................................................................403
sqlf stats....................................................................................................................................................404
sqlf upgrade-disk-store.............................................................................................................................408
sqlf validate-disk-store..............................................................................................................................409
sqlf version................................................................................................................................................409
sqlf write-data-dtd-to-file...........................................................................................................................410
sqlf write-data-to-db..................................................................................................................................412
sqlf write-data-to-xml................................................................................................................................416
sqlf write-schema-to-db............................................................................................................................420
sqlf write-schema-to-sql............................................................................................................................424
sqlf write-schema-to-xml...........................................................................................................................429
Chapter 54: sqlf Interactive Commands...............................................435
absolute ...................................................................................................................................................435
after last ...................................................................................................................................................436
async .......................................................................................................................................................437
autocommit ..............................................................................................................................................437
before first ................................................................................................................................................438
close ........................................................................................................................................................438
commit .....................................................................................................................................................439
connect ....................................................................................................................................................439
connect client ...........................................................................................................................................440
connect peer ............................................................................................................................................441
describe ...................................................................................................................................................441
disconnect ................................................................................................................................................442
driver ........................................................................................................................................................443
elapsedtime .............................................................................................................................................443
execute ....................................................................................................................................................444
exit ...........................................................................................................................................................445
first............................................................................................................................................................446
get scroll insensitive cursor.......................................................................................................................446
GetCurrentRowNumber ...........................................................................................................................448
help ..........................................................................................................................................................448
last ...........................................................................................................................................................449
LocalizedDisplay.......................................................................................................................................449
MaximumDisplayWidth.............................................................................................................................450
next...........................................................................................................................................................451
prepare ....................................................................................................................................................451
previous....................................................................................................................................................452
protocol.....................................................................................................................................................453
vFabric SQLFire User's Guidex
relative......................................................................................................................................................454
remove......................................................................................................................................................454
rollback......................................................................................................................................................455
run.............................................................................................................................................................456
set connection...........................................................................................................................................457
show..........................................................................................................................................................457
wait for......................................................................................................................................................461
Chapter 55: SQLFire API........................................................................463
CredentialInitializer...................................................................................................................................464
UserAuthenticator.....................................................................................................................................464
Procedure Implementation Interfaces.......................................................................................................464
Procedure Result Processor Interfaces....................................................................................................466
Chapter 56: SQL Language Reference.................................................471
Keywords and Identifiers...........................................................................................................................471
SQL Statements.......................................................................................................................................472
SQL Queries.............................................................................................................................................532
SQL Clauses.............................................................................................................................................533
SQL Expressions......................................................................................................................................538
JOIN Operations.......................................................................................................................................551
Built-in Functions......................................................................................................................................553
Built-in System Procedures......................................................................................................................595
Data Types................................................................................................................................................624
SQL Standards Conformance...................................................................................................................635
Chapter 57: System Tables.....................................................................655
ASYNCEVENTLISTENERS.....................................................................................................................655
GATEWAYRECEIVERS............................................................................................................................656
GATEWAYSENDERS...............................................................................................................................657
INDEXES..................................................................................................................................................659
JARS.........................................................................................................................................................659
MEMBERS................................................................................................................................................659
MEMORYANALYTICS...............................................................................................................................661
STATEMENTPLANS.................................................................................................................................661
SYSALIASES............................................................................................................................................663
SYSCHECKS............................................................................................................................................664
SYSCOLPERMS......................................................................................................................................664
SYSCOLUMNS.........................................................................................................................................665
SYSCONGLOMERATES..........................................................................................................................667
SYSCONSTRAINTS.................................................................................................................................667
SYSDEPENDS.........................................................................................................................................668
SYSDISKSTORES....................................................................................................................................669
SYSFILES.................................................................................................................................................670
SYSFOREIGNKEYS.................................................................................................................................670
SYSKEYS.................................................................................................................................................671
xi
Contents
SYSROLES...............................................................................................................................................671
SYSROUTINEPERMS..............................................................................................................................672
SYSSCHEMAS.........................................................................................................................................673
SYSSTATEMENTS...................................................................................................................................674
SYSSTATISTICS.......................................................................................................................................674
SYSTABLEPERMS...................................................................................................................................675
SYSTABLES.............................................................................................................................................677
SYSTRIGGERS........................................................................................................................................678
SYSVIEWS...............................................................................................................................................680
Chapter 58: Exception Messages and SQL States..............................681
Chapter 59: ADO.NET Driver Reference...............................................685
SQLFire Data Types in ADO.NET.............................................................................................................685
VMware.Data.SQLFire.BatchUpdateException........................................................................................685
VMWare.Data.SQLFire.SQLFClientConnection.......................................................................................685
VMware.Data.SQLFire.SQLFCommand...................................................................................................690
VMware.Data.SQLFire.SQLFCommandBuilder........................................................................................696
VMware.Data.SQLFire.SQLFType............................................................................................................696
VMware.Data.SQLFire.SQLFDataAdapter...............................................................................................697
VMware.Data.SQLFire.SQLFDataReader................................................................................................699
VMware.Data.SQLFire.SQLFException....................................................................................................701
VMware.Data.SQLFire.SQLFParameter...................................................................................................702
VMware.Data.SQLFire.SQLFParameterCollection...................................................................................702
VMware.Data.SQLFire.SQLFTransaction.................................................................................................703
Chapter 60: vFabric SQLFire Limitations.............................................707
SQL Language Limitations.......................................................................................................................707
ADO.NET Driver Limitations.....................................................................................................................715
Troubleshooting Common Problems........................................................................717
vFabric SQLFire Glossary..........................................................................................721
vFabric SQLFire User's Guidexii
About the SQLFire User's Guide
Revised August 22, 2013.
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 Supported
Configurations and System Requirements for vFabric Suite.
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 (64bit and 32 bit)Red Hat EL 5
ProductionJava SE 6, update 0_26x86 (64bit and 32 bit)Red Hat EL 6
ProductionJava SE 6, update 0_26x86 (64bit and 32 bit)Windows Server 2003 R2
SP2 Professional or
Enterprise*
ProductionJava SE 6, update 0_26x8 (64bit and 32 bit)Windows Server 2008 R2
Standard*
DeveloperJava SE 6, update 0_26x8 (64bit and 32 bit)Windows 7 SP1
Professional or
Enterprise*
DeveloperJava SE 6x86 (64 bit)Windows XP
DeveloperJava SE 6x86 (64 bit)Ubuntu 10.04
*The Microsoft Loopback Adapter is not 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:
1.
Edit the /etc/sysctl.conf file to include the following lines:
net.core.rmem_max=1048576
net.core.wmem_max=1048576
2.
Reload sysctl.conf:
sysctl -p
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.
vFabric SQLFire User's Guide16
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.
17
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:
• vFabric SQLFire in 15 Minutes
• 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
vFabric SQLFire in 15 Minutes
Need a quick introduction to vFabric SQLFire? Take this 15-minute tour to try out the basic features and
functionality.
The vFabric SQLFire tutorials expand on these concepts, and demonstrate additional product features. See
Tutorials on page 37.
1. Download the latest SQLFire 1.1 ZIP file distribution from the download page:
https://my.vmware.com/web/vmware/info/slug/application_platform/vmware_vfabric_sqlfire/1_0. Save the
downloaded file in your home directory.
2. Install SQLFire 1.1 by uncompressing the ZIP file:
$ cd ~
$ unzip vFabric_SQLFire_11_bNNNNN.zip
Substitute the exact filename that you downloaded.
This installs SQLFire in a new vFabric_SQLFire_11_b NNNNN subdirectory in your home directory,
where NNNNN is the specific SQLFire build number that you downloaded.
3. If you have not already done so, download and install Java.
For a list of Java versions supported with this release of vFabric SQLFire, see Supported Configurations and
System Requirements on page 15.
4.
Set your PATH environment variable to include the bin subdirectory of the vFabric SQLFire directory. For
example:
$ export PATH=$PATH:/home/username/vFabric_SQLFire_11_bNNNNN/bin
5.
Change to the SQLFire installation quickstart directory, and create three new directories for the locator
and two servers that will make up the SQLFire distributed system:
$ cd ~/vFabric_SQLFire_11_bNNNNN/quickstart
$ mkdir locator1 server1 server2
6. Start the locator:
$ sqlf locator start -peer-discovery-address=localhost -dir=locator1
Starting network server for SQLFire Locator at address
localhost/127.0.0.1[1527]
SQLFire Locator pid: 8787 status: running
Logs generated in
/home/yozie/vFabric_SQLFire_11_bNNNNN/quickstart/locator1/sqlflocator.log
This command starts a default locator that accepts connections on the localhost address. The default port of
10334 is used for communication with other members of the distributed system. (You can double-check that
this port is used by examining the locator1/sqlflocator.log file.) All new members of the distributed
system must specify this locator's address and peer discovery port, localhost[10334], in order to join the
system.
The default port of 1527 is used for client connections to the distributed system.
7. Start both servers:
$ sqlf server start -locators=localhost[10334] -bind-address=localhost
-client-port=1528 -dir=server1
$ sqlf server start -locators=localhost[10334] -bind-address=localhost
-client-port=1529 -dir=server2
Starting SQLFire Server using locators for peer discovery: localhost[10334]
Starting network server for SQLFire Server at address
localhost/127.0.0.1[1528]
vFabric SQLFire User's Guide2
/
