VMware vFabric SQLFire 1.1 User guide

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

©

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

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

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

Chapter 7: Tutorials..................................................................................35

Main Steps..................................................................................................................................................35

iii

Create a SQLFire Cluster...........................................................................................................................35

Connect to the Cluster Using SQLF...........................................................................................................37

Create Replicated Tables and Execute Queries.........................................................................................38

Implement a Partitioning Strategy...............................................................................................................39

Persist Tables to Disk..................................................................................................................................41

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

Perform Additional Tasks............................................................................................................................44

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

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

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

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

Identify Entity Groups and Partitioning Keys...............................................................................................49

Replicate Code Tables................................................................................................................................50

Dealing with Many-to-Many Relationships..................................................................................................50

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

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

Server Groups Overview.............................................................................................................................55

Adding Members to Server Groups............................................................................................................57

Assigning Tables to Server Groups.............................................................................................................58

Chapter 11: Partitioning Tables...............................................................59

How Table Partitioning Works.....................................................................................................................59

Understanding Where Data Is Stored.........................................................................................................60

Failure and Redundancy.............................................................................................................................61

Creating Partitioned Tables.........................................................................................................................62

Rebalancing Partitioned Data on SQLFire Members..................................................................................66

Managing Replication Failures....................................................................................................................67

Chapter 12: Replicating Tables................................................................69

How SQLFire Replicates Tables.................................................................................................................69

Deciding When to Use Replicated Tables...................................................................................................69

Creating Replicated Tables.........................................................................................................................70

Chapter 13: Estimating Memory Requirements.....................................71

Estimating SQLFire Overhead....................................................................................................................71

Viewing Memory Usage in SYS.MEMORYANALYTICS..............................................................................72

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

Overview of Disk Stores..............................................................................................................................77

Guidelines for Designing Disk Stores.........................................................................................................83

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

vFabric SQLFire User's Guideiv

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

Optimizing Availability and Performance.....................................................................................................85

Starting System with Disk Stores................................................................................................................85

Disk Store Management.............................................................................................................................87

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

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

Using Apache DdlUtils to Import Data........................................................................................................99

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

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

Overview of SQLFire Table Functions.......................................................................................................103

Example Table Function............................................................................................................................105

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

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

Starting a Network Server........................................................................................................................110

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

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

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

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

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

Class Loading Overview...........................................................................................................................121

Alternate Methods for Managing JAR Files..............................................................................................123

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

About the ADO.NET Driver.......................................................................................................................127

ADO.NET Driver Classes..........................................................................................................................128

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

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

Managing Connections.............................................................................................................................130

Executing SQL Commands.......................................................................................................................130

Working with Result Sets..........................................................................................................................131

Storing a Table..........................................................................................................................................132

Storing Multiple Tables..............................................................................................................................133

Specifying Command Parameters with SQLFParameter..........................................................................134

Updating Row Data...................................................................................................................................135

Adding Rows to a Table............................................................................................................................136

Managing SQLFire Transactions...............................................................................................................137

Performing Batch Updates........................................................................................................................138

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

v

Contents

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

Installing SQLFire.NET Designer..............................................................................................................143

Connecting to a SQLFire Distributed System...........................................................................................143

Editing Tables............................................................................................................................................144

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

Data Consistency Concepts.....................................................................................................................145

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

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

Atomicity for Bulk Updates........................................................................................................................146

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

Overview of SQLFire Distributed Transactions.........................................................................................147

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

SQLFire Transaction Design.....................................................................................................................151

Best Practices for Using Transactions.......................................................................................................151

Transaction Functionality and Limitations.................................................................................................152

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

Configuring a Procedure...........................................................................................................................153

Configuring a Custom Result Processor...................................................................................................154

Invoking a Procedure................................................................................................................................155

Example JDBC Client...............................................................................................................................156

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

Procedure Parameters..............................................................................................................................159

Populating OUT and INOUT Parameters..................................................................................................160

Populating Result Sets..............................................................................................................................160

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

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

Implementing the ProcedureResultProcessor Interface ..........................................................................163

Example Result Processor: MergeSort.....................................................................................................163

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

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

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

Updatable Result Sets..............................................................................................................................172

Scrollable Insensitive Result Sets.............................................................................................................177

Result Sets and Autocommit.....................................................................................................................178

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

vFabric SQLFire User's Guidevi

Chapter 30: SQLFire Cache Strategies.................................................181

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

How SQLFire Invokes a RowLoader.........................................................................................................183

Implementing the RowLoader Interface....................................................................................................184

Using the JDBCRowLoader Example.......................................................................................................184

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

How LRU Eviction Works..........................................................................................................................187

Limitations of Eviction...............................................................................................................................187

Eviction in Partitioned Tables....................................................................................................................188

Create a Table with Eviction Settings........................................................................................................188

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

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

Example Writer Implementation................................................................................................................192

Example Listener Implementation............................................................................................................192

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

How the AsyncEventListener Works.........................................................................................................193

Implementation Requirements..................................................................................................................193

Implementing an AsyncEventListener.......................................................................................................194

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

How DBSynchronizer Works.....................................................................................................................199

Restrictions and Limitations......................................................................................................................200

Configuring DBSynchronizer....................................................................................................................201

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

Part V: Deploying vFabric SQLFire........................................................207

Chapter 37: SQLFire Deployment Models............................................209

Embedded Peer-to-Peer Deployment.......................................................................................................210

Client-Server Deployment.........................................................................................................................212

Multi-site Deployment...............................................................................................................................213

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

Chapter 39: Configuring Discovery Mechanisms................................219

Using Locators..........................................................................................................................................219

Configure Multicast Discovery..................................................................................................................221

vii

Contents

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

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

Specify the Server Working Directory.......................................................................................................224

Specify Client Connection Information......................................................................................................224

Define Server Groups...............................................................................................................................224

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

Using Additional Boot Properties..............................................................................................................225

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

About Gateways........................................................................................................................................227

About High Availability for WAN Deployments..........................................................................................229

Limitations of Multi-Site Replication..........................................................................................................230

Prerequisites for WAN Replication............................................................................................................231

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

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

Configuring User Authentication...............................................................................................................237

User Names in Authentication and Authorization ....................................................................................245

Configuring User Authorization.................................................................................................................246

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

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

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

Log Message Format................................................................................................................................257

Severity Levels..........................................................................................................................................257

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

Using Trace Flags for Advanced Debugging.............................................................................................258

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

Getting Information About SQLFire Members..........................................................................................261

Getting Information About User Tables.....................................................................................................262

Chapter 45: Evaluating Query Plans and Query Statistics.................267

Capture a Query Plan for an Individual Statement...................................................................................267

Capture Query Plans for All Statements...................................................................................................268

Example Query Plan Analysis..................................................................................................................268

Query Plan Codes....................................................................................................................................271

Chapter 46: Overriding Optimizer Choices..........................................275

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

Collecting System Statistics......................................................................................................................279

Collecting Application Statistics................................................................................................................280

vFabric SQLFire User's Guideviii

Using VSD to Analyze Statistics...............................................................................................................280

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

Using a JMX Manager Node.....................................................................................................................291

Using a vFabric SQLFire JMX Agent........................................................................................................294

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

Tune Application Logic..............................................................................................................................307

Reduce Distribution Overhead..................................................................................................................307

Reduce Overhead of Eviction to Disk.......................................................................................................308

Minimize Update Latency for Replicated Tables.......................................................................................308

Tune FabricServers...................................................................................................................................308

Tuning Disk I/O.........................................................................................................................................309

Running SQLFire in Virtualized Environments..........................................................................................310

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

Part VII: vFabric SQLFire Reference......................................................313

Chapter 51: Configuration Properties..................................................315

Chapter 52: JDBC API............................................................................351

Mapping java.sql.Types to SQL Types......................................................................................................351

java.sql.BatchUpdateException Class......................................................................................................352

java.sql.Connection Interface....................................................................................................................352

java.sql.DatabaseMetaData Interface.......................................................................................................353

java.sql.Driver Interface............................................................................................................................355

java.sql.DriverManager.getConnection Method........................................................................................355

java.sql.PreparedStatement Interface.......................................................................................................355

java.sql.ResultSet Interface......................................................................................................................357

java.sql.SavePoint Class...........................................................................................................................357

java.sql.SQLException Class....................................................................................................................357

java.sql.Statement Class..........................................................................................................................357

javax.sql.XADataSource...........................................................................................................................357

Chapter 53: sqlf Launcher Commands................................................359

sqlf backup................................................................................................................................................360

sqlf compact-all-disk-stores......................................................................................................................363

sqlf compact-disk-store.............................................................................................................................364

sqlf encrypt-password...............................................................................................................................365

sqlf install-jar.............................................................................................................................................365

sqlf list-missing-disk-stores.......................................................................................................................368

sqlf locator................................................................................................................................................369

sqlf Logging Support.................................................................................................................................374

sqlf merge-logs.........................................................................................................................................374

ix

Contents

sqlf remove-jar..........................................................................................................................................375

sqlf replace-jar..........................................................................................................................................377

sqlf revoke-missing-disk-store...................................................................................................................379

sqlf server.................................................................................................................................................380

sqlf show-disk-store-metadata..................................................................................................................391

sqlf shut-down-all......................................................................................................................................392

sqlf stats....................................................................................................................................................393

sqlf upgrade-disk-store.............................................................................................................................397

sqlf validate-disk-store..............................................................................................................................398

sqlf version................................................................................................................................................398

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

sqlf write-data-to-db..................................................................................................................................401

sqlf write-data-to-xml................................................................................................................................405

sqlf write-schema-to-db............................................................................................................................409

sqlf write-schema-to-sql............................................................................................................................413

sqlf write-schema-to-xml...........................................................................................................................417

Chapter 54: sqlf Interactive Commands...............................................423

absolute ...................................................................................................................................................423

after last ...................................................................................................................................................424

async .......................................................................................................................................................425

autocommit ..............................................................................................................................................425

before first ................................................................................................................................................426

close ........................................................................................................................................................426

commit .....................................................................................................................................................427

connect ....................................................................................................................................................427

connect client ...........................................................................................................................................428

connect peer ............................................................................................................................................429

describe ...................................................................................................................................................429

disconnect ................................................................................................................................................430

driver ........................................................................................................................................................430

elapsedtime .............................................................................................................................................431

execute ....................................................................................................................................................432

exit ...........................................................................................................................................................433

first............................................................................................................................................................433

get scroll insensitive cursor.......................................................................................................................434

GetCurrentRowNumber ...........................................................................................................................436

help ..........................................................................................................................................................436

last ...........................................................................................................................................................436

LocalizedDisplay.......................................................................................................................................437

MaximumDisplayWidth.............................................................................................................................438

next...........................................................................................................................................................438

prepare ....................................................................................................................................................439

previous....................................................................................................................................................440

protocol.....................................................................................................................................................441

relative......................................................................................................................................................441

vFabric SQLFire User's Guidex

remove......................................................................................................................................................442

rollback......................................................................................................................................................443

run.............................................................................................................................................................444

set connection...........................................................................................................................................444

show..........................................................................................................................................................445

wait for......................................................................................................................................................448

Chapter 55: SQLFire API........................................................................449

CredentialInitializer...................................................................................................................................450

UserAuthenticator.....................................................................................................................................450

Procedure Implementation Interfaces.......................................................................................................450

Procedure Result Processor Interfaces....................................................................................................452

Chapter 56: SQL Language Reference.................................................457

Keywords and Identifiers...........................................................................................................................457

SQL Statements.......................................................................................................................................458

SQL Queries.............................................................................................................................................517

SQL Clauses.............................................................................................................................................518

SQL Expressions......................................................................................................................................523

JOIN Operations.......................................................................................................................................536

Built-in Functions......................................................................................................................................538

Built-in System Procedures......................................................................................................................580

Data Types................................................................................................................................................604

SQL Standards Conformance...................................................................................................................615

Chapter 57: System Tables.....................................................................635

ASYNCEVENTLISTENERS.....................................................................................................................635

GATEWAYRECEIVERS............................................................................................................................636

GATEWAYSENDERS...............................................................................................................................637

INDEXES..................................................................................................................................................639

JARS.........................................................................................................................................................639

MEMBERS................................................................................................................................................639

MEMORYANALYTICS...............................................................................................................................641

STATEMENTPLANS.................................................................................................................................641

SYSALIASES............................................................................................................................................643

SYSCHECKS............................................................................................................................................644

SYSCOLPERMS......................................................................................................................................644

SYSCOLUMNS.........................................................................................................................................645

SYSCONGLOMERATES..........................................................................................................................647

SYSCONSTRAINTS.................................................................................................................................647

SYSDEPENDS.........................................................................................................................................648

SYSDISKSTORES....................................................................................................................................649

SYSFILES.................................................................................................................................................650

SYSFOREIGNKEYS.................................................................................................................................650

SYSKEYS.................................................................................................................................................651

SYSROLES...............................................................................................................................................651

xi

Contents

SYSROUTINEPERMS..............................................................................................................................652

SYSSCHEMAS.........................................................................................................................................653

SYSSTATEMENTS...................................................................................................................................654

SYSSTATISTICS.......................................................................................................................................654

SYSTABLEPERMS...................................................................................................................................655

SYSTABLES.............................................................................................................................................657

SYSTRIGGERS........................................................................................................................................658

SYSVIEWS...............................................................................................................................................660

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

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

SQLFire Data Types in ADO.NET.............................................................................................................665

VMware.Data.SQLFire.BatchUpdateException........................................................................................665

VMWare.Data.SQLFire.SQLFClientConnection.......................................................................................665

VMware.Data.SQLFire.SQLFCommand...................................................................................................670

VMware.Data.SQLFire.SQLFCommandBuilder........................................................................................676

VMware.Data.SQLFire.SQLFType............................................................................................................676

VMware.Data.SQLFire.SQLFDataAdapter...............................................................................................677

VMware.Data.SQLFire.SQLFDataReader................................................................................................679

VMware.Data.SQLFire.SQLFException....................................................................................................681

VMware.Data.SQLFire.SQLFParameter...................................................................................................682

VMware.Data.SQLFire.SQLFParameterCollection...................................................................................682

VMware.Data.SQLFire.SQLFTransaction.................................................................................................683

Chapter 60: vFabric SQLFire Limitations.............................................687

SQL Language Limitations.......................................................................................................................687

ADO.NET Driver Limitations.....................................................................................................................695

Troubleshooting Common Problems........................................................................697

vFabric SQLFire Glossary..........................................................................................699

vFabric SQLFire User's Guidexii

About the SQLFire User's Guide

Revised April 30, 2013.

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

applications with VMware

®

vFabric

™

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

tools, supported SQL statements, and APIs.

Intended Audience

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

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

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

developing database applications using Java or .NET technologies.

13

Supported Configurations and System

Requirements

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

and running the product.

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

and running the product.

• Supported Conﬁgurations on page 15

• Host Machine Requirements on page 16

• Increase Unicast Buffer Size on Linux Platforms on page 16

• Disable SYN Cookies on Linux Platforms on page 16

• Client Requirements on page 16

Supported Configurations

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

Conﬁgurations and System Requirements for vFabric Suite.

Note:

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

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

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

Production or Developer SupportJVMProcessor

Architecture

Operating System

ProductionJava SE 6, update 0_26x86 (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 ﬁle names.

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

• TCP/IP.

• System clock set to the correct time.

•

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

for hostname and hosts.

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

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

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

distributed run.

Increase Unicast Buffer Size on Linux Platforms

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

1.

Edit the /etc/sysctl.conf ﬁle 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 ﬂood

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

a running SQLFire distributed system.

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

that SQLFire network throughput is not affected.

To disable SYN cookies permanently:

1.

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

net.ipv4.tcp_syncookies = 0

Setting this value to zero disables SYN cookies.

2.

Reload sysctl.conf:

sysctl -p

Client Requirements

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

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

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

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, conﬁguring, 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 35.

1. Download the latest SQLFire 1.1 ZIP ﬁle distribution from the download page:

https://my.vmware.com/web/vmware/info/slug/application_platform/vmware_vfabric_sqlﬁre/1_0. Save the

downloaded ﬁle in your home directory.

2. Install SQLFire 1.1 by uncompressing the ZIP ﬁle:

$ cd ~

$ unzip vFabric_SQLFire_11_bNNNNN.zip

Substitute the exact ﬁlename that you downloaded.

This installs SQLFire in a new vFabric_SQLFire_11_b NNNNN subdirectory in your home directory,

where NNNNN is the speciﬁc 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 Conﬁgurations 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 ﬁle.) 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

Page is loading ...

VMware vFabric SQLFire 1.1 User guide

VMware vFabric SQLFire 1.1 User guide

Related papers

Other documents