VMware vFabric SQLFire 1.1.1 User guide

Category
Software manuals
Type
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
©
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, conguring, 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 Congurations 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 congurations for vFabric SQLFire. These include Supported
Congurations and System Requirements for vFabric Suite.
Note:
The tables indicate whether the supported conguration 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 congured. 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, conguring, 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 le distribution from the download page:
https://my.vmware.com/web/vmware/info/slug/application_platform/vmware_vfabric_sqlre/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 specic 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 Congurations 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 1 1
  • Page 2 2
  • Page 3 3
  • Page 4 4
  • Page 5 5
  • Page 6 6
  • Page 7 7
  • Page 8 8
  • Page 9 9
  • Page 10 10
  • Page 11 11
  • Page 12 12
  • Page 13 13
  • Page 14 14
  • Page 15 15
  • Page 16 16
  • Page 17 17
  • Page 18 18
  • Page 19 19
  • Page 20 20
  • Page 21 21
  • Page 22 22
  • Page 23 23
  • Page 24 24
  • Page 25 25
  • Page 26 26
  • Page 27 27
  • Page 28 28
  • Page 29 29
  • Page 30 30
  • Page 31 31
  • Page 32 32
  • Page 33 33
  • Page 34 34
  • Page 35 35
  • Page 36 36
  • Page 37 37
  • Page 38 38
  • Page 39 39
  • Page 40 40
  • Page 41 41
  • Page 42 42
  • Page 43 43
  • Page 44 44
  • Page 45 45
  • Page 46 46
  • Page 47 47
  • Page 48 48
  • Page 49 49
  • Page 50 50
  • Page 51 51
  • Page 52 52
  • Page 53 53
  • Page 54 54
  • Page 55 55
  • Page 56 56
  • Page 57 57
  • Page 58 58
  • Page 59 59
  • Page 60 60
  • Page 61 61
  • Page 62 62
  • Page 63 63
  • Page 64 64
  • Page 65 65
  • Page 66 66
  • Page 67 67
  • Page 68 68
  • Page 69 69
  • Page 70 70
  • Page 71 71
  • Page 72 72
  • Page 73 73
  • Page 74 74
  • Page 75 75
  • Page 76 76
  • Page 77 77
  • Page 78 78
  • Page 79 79
  • Page 80 80
  • Page 81 81
  • Page 82 82
  • Page 83 83
  • Page 84 84
  • Page 85 85
  • Page 86 86
  • Page 87 87
  • Page 88 88
  • Page 89 89
  • Page 90 90
  • Page 91 91
  • Page 92 92
  • Page 93 93
  • Page 94 94
  • Page 95 95
  • Page 96 96
  • Page 97 97
  • Page 98 98
  • Page 99 99
  • Page 100 100
  • Page 101 101
  • Page 102 102
  • Page 103 103
  • Page 104 104
  • Page 105 105
  • Page 106 106
  • Page 107 107
  • Page 108 108
  • Page 109 109
  • Page 110 110
  • Page 111 111
  • Page 112 112
  • Page 113 113
  • Page 114 114
  • Page 115 115
  • Page 116 116
  • Page 117 117
  • Page 118 118
  • Page 119 119
  • Page 120 120
  • Page 121 121
  • Page 122 122
  • Page 123 123
  • Page 124 124
  • Page 125 125
  • Page 126 126
  • Page 127 127
  • Page 128 128
  • Page 129 129
  • Page 130 130
  • Page 131 131
  • Page 132 132
  • Page 133 133
  • Page 134 134
  • Page 135 135
  • Page 136 136
  • Page 137 137
  • Page 138 138
  • Page 139 139
  • Page 140 140
  • Page 141 141
  • Page 142 142
  • Page 143 143
  • Page 144 144
  • Page 145 145
  • Page 146 146
  • Page 147 147
  • Page 148 148
  • Page 149 149
  • Page 150 150
  • Page 151 151
  • Page 152 152
  • Page 153 153
  • Page 154 154
  • Page 155 155
  • Page 156 156
  • Page 157 157
  • Page 158 158
  • Page 159 159
  • Page 160 160
  • Page 161 161
  • Page 162 162
  • Page 163 163
  • Page 164 164
  • Page 165 165
  • Page 166 166
  • Page 167 167
  • Page 168 168
  • Page 169 169
  • Page 170 170
  • Page 171 171
  • Page 172 172
  • Page 173 173
  • Page 174 174
  • Page 175 175
  • Page 176 176
  • Page 177 177
  • Page 178 178
  • Page 179 179
  • Page 180 180
  • Page 181 181
  • Page 182 182
  • Page 183 183
  • Page 184 184
  • Page 185 185
  • Page 186 186
  • Page 187 187
  • Page 188 188
  • Page 189 189
  • Page 190 190
  • Page 191 191
  • Page 192 192
  • Page 193 193
  • Page 194 194
  • Page 195 195
  • Page 196 196
  • Page 197 197
  • Page 198 198
  • Page 199 199
  • Page 200 200
  • Page 201 201
  • Page 202 202
  • Page 203 203
  • Page 204 204
  • Page 205 205
  • Page 206 206
  • Page 207 207
  • Page 208 208
  • Page 209 209
  • Page 210 210
  • Page 211 211
  • Page 212 212
  • Page 213 213
  • Page 214 214
  • Page 215 215
  • Page 216 216
  • Page 217 217
  • Page 218 218
  • Page 219 219
  • Page 220 220
  • Page 221 221
  • Page 222 222
  • Page 223 223
  • Page 224 224
  • Page 225 225
  • Page 226 226
  • Page 227 227
  • Page 228 228
  • Page 229 229
  • Page 230 230
  • Page 231 231
  • Page 232 232
  • Page 233 233
  • Page 234 234
  • Page 235 235
  • Page 236 236
  • Page 237 237
  • Page 238 238
  • Page 239 239
  • Page 240 240
  • Page 241 241
  • Page 242 242
  • Page 243 243
  • Page 244 244
  • Page 245 245
  • Page 246 246
  • Page 247 247
  • Page 248 248
  • Page 249 249
  • Page 250 250
  • Page 251 251
  • Page 252 252
  • Page 253 253
  • Page 254 254
  • Page 255 255
  • Page 256 256
  • Page 257 257
  • Page 258 258
  • Page 259 259
  • Page 260 260
  • Page 261 261
  • Page 262 262
  • Page 263 263
  • Page 264 264
  • Page 265 265
  • Page 266 266
  • Page 267 267
  • Page 268 268
  • Page 269 269
  • Page 270 270
  • Page 271 271
  • Page 272 272
  • Page 273 273
  • Page 274 274
  • Page 275 275
  • Page 276 276
  • Page 277 277
  • Page 278 278
  • Page 279 279
  • Page 280 280
  • Page 281 281
  • Page 282 282
  • Page 283 283
  • Page 284 284
  • Page 285 285
  • Page 286 286
  • Page 287 287
  • Page 288 288
  • Page 289 289
  • Page 290 290
  • Page 291 291
  • Page 292 292
  • Page 293 293
  • Page 294 294
  • Page 295 295
  • Page 296 296
  • Page 297 297
  • Page 298 298
  • Page 299 299
  • Page 300 300
  • Page 301 301
  • Page 302 302
  • Page 303 303
  • Page 304 304
  • Page 305 305
  • Page 306 306
  • Page 307 307
  • Page 308 308
  • Page 309 309
  • Page 310 310
  • Page 311 311
  • Page 312 312
  • Page 313 313
  • Page 314 314
  • Page 315 315
  • Page 316 316
  • Page 317 317
  • Page 318 318
  • Page 319 319
  • Page 320 320
  • Page 321 321
  • Page 322 322
  • Page 323 323
  • Page 324 324
  • Page 325 325
  • Page 326 326
  • Page 327 327
  • Page 328 328
  • Page 329 329
  • Page 330 330
  • Page 331 331
  • Page 332 332
  • Page 333 333
  • Page 334 334
  • Page 335 335
  • Page 336 336
  • Page 337 337
  • Page 338 338
  • Page 339 339
  • Page 340 340
  • Page 341 341
  • Page 342 342
  • Page 343 343
  • Page 344 344
  • Page 345 345
  • Page 346 346
  • Page 347 347
  • Page 348 348
  • Page 349 349
  • Page 350 350
  • Page 351 351
  • Page 352 352
  • Page 353 353
  • Page 354 354
  • Page 355 355
  • Page 356 356
  • Page 357 357
  • Page 358 358
  • Page 359 359
  • Page 360 360
  • Page 361 361
  • Page 362 362
  • Page 363 363
  • Page 364 364
  • Page 365 365
  • Page 366 366
  • Page 367 367
  • Page 368 368
  • Page 369 369
  • Page 370 370
  • Page 371 371
  • Page 372 372
  • Page 373 373
  • Page 374 374
  • Page 375 375
  • Page 376 376
  • Page 377 377
  • Page 378 378
  • Page 379 379
  • Page 380 380
  • Page 381 381
  • Page 382 382
  • Page 383 383
  • Page 384 384
  • Page 385 385
  • Page 386 386
  • Page 387 387
  • Page 388 388
  • Page 389 389
  • Page 390 390
  • Page 391 391
  • Page 392 392
  • Page 393 393
  • Page 394 394
  • Page 395 395
  • Page 396 396
  • Page 397 397
  • Page 398 398
  • Page 399 399
  • Page 400 400
  • Page 401 401
  • Page 402 402
  • Page 403 403
  • Page 404 404
  • Page 405 405
  • Page 406 406
  • Page 407 407
  • Page 408 408
  • Page 409 409
  • Page 410 410
  • Page 411 411
  • Page 412 412
  • Page 413 413
  • Page 414 414
  • Page 415 415
  • Page 416 416
  • Page 417 417
  • Page 418 418
  • Page 419 419
  • Page 420 420
  • Page 421 421
  • Page 422 422
  • Page 423 423
  • Page 424 424
  • Page 425 425
  • Page 426 426
  • Page 427 427
  • Page 428 428
  • Page 429 429
  • Page 430 430
  • Page 431 431
  • Page 432 432
  • Page 433 433
  • Page 434 434
  • Page 435 435
  • Page 436 436
  • Page 437 437
  • Page 438 438
  • Page 439 439
  • Page 440 440
  • Page 441 441
  • Page 442 442
  • Page 443 443
  • Page 444 444
  • Page 445 445
  • Page 446 446
  • Page 447 447
  • Page 448 448
  • Page 449 449
  • Page 450 450
  • Page 451 451
  • Page 452 452
  • Page 453 453
  • Page 454 454
  • Page 455 455
  • Page 456 456
  • Page 457 457
  • Page 458 458
  • Page 459 459
  • Page 460 460
  • Page 461 461
  • Page 462 462
  • Page 463 463
  • Page 464 464
  • Page 465 465
  • Page 466 466
  • Page 467 467
  • Page 468 468
  • Page 469 469
  • Page 470 470
  • Page 471 471
  • Page 472 472
  • Page 473 473
  • Page 474 474
  • Page 475 475
  • Page 476 476
  • Page 477 477
  • Page 478 478
  • Page 479 479
  • Page 480 480
  • Page 481 481
  • Page 482 482
  • Page 483 483
  • Page 484 484
  • Page 485 485
  • Page 486 486
  • Page 487 487
  • Page 488 488
  • Page 489 489
  • Page 490 490
  • Page 491 491
  • Page 492 492
  • Page 493 493
  • Page 494 494
  • Page 495 495
  • Page 496 496
  • Page 497 497
  • Page 498 498
  • Page 499 499
  • Page 500 500
  • Page 501 501
  • Page 502 502
  • Page 503 503
  • Page 504 504
  • Page 505 505
  • Page 506 506
  • Page 507 507
  • Page 508 508
  • Page 509 509
  • Page 510 510
  • Page 511 511
  • Page 512 512
  • Page 513 513
  • Page 514 514
  • Page 515 515
  • Page 516 516
  • Page 517 517
  • Page 518 518
  • Page 519 519
  • Page 520 520
  • Page 521 521
  • Page 522 522
  • Page 523 523
  • Page 524 524
  • Page 525 525
  • Page 526 526
  • Page 527 527
  • Page 528 528
  • Page 529 529
  • Page 530 530
  • Page 531 531
  • Page 532 532
  • Page 533 533
  • Page 534 534
  • Page 535 535
  • Page 536 536
  • Page 537 537
  • Page 538 538
  • Page 539 539
  • Page 540 540
  • Page 541 541
  • Page 542 542
  • Page 543 543
  • Page 544 544
  • Page 545 545
  • Page 546 546
  • Page 547 547
  • Page 548 548
  • Page 549 549
  • Page 550 550
  • Page 551 551
  • Page 552 552
  • Page 553 553
  • Page 554 554
  • Page 555 555
  • Page 556 556
  • Page 557 557
  • Page 558 558
  • Page 559 559
  • Page 560 560
  • Page 561 561
  • Page 562 562
  • Page 563 563
  • Page 564 564
  • Page 565 565
  • Page 566 566
  • Page 567 567
  • Page 568 568
  • Page 569 569
  • Page 570 570
  • Page 571 571
  • Page 572 572
  • Page 573 573
  • Page 574 574
  • Page 575 575
  • Page 576 576
  • Page 577 577
  • Page 578 578
  • Page 579 579
  • Page 580 580
  • Page 581 581
  • Page 582 582
  • Page 583 583
  • Page 584 584
  • Page 585 585
  • Page 586 586
  • Page 587 587
  • Page 588 588
  • Page 589 589
  • Page 590 590
  • Page 591 591
  • Page 592 592
  • Page 593 593
  • Page 594 594
  • Page 595 595
  • Page 596 596
  • Page 597 597
  • Page 598 598
  • Page 599 599
  • Page 600 600
  • Page 601 601
  • Page 602 602
  • Page 603 603
  • Page 604 604
  • Page 605 605
  • Page 606 606
  • Page 607 607
  • Page 608 608
  • Page 609 609
  • Page 610 610
  • Page 611 611
  • Page 612 612
  • Page 613 613
  • Page 614 614
  • Page 615 615
  • Page 616 616
  • Page 617 617
  • Page 618 618
  • Page 619 619
  • Page 620 620
  • Page 621 621
  • Page 622 622
  • Page 623 623
  • Page 624 624
  • Page 625 625
  • Page 626 626
  • Page 627 627
  • Page 628 628
  • Page 629 629
  • Page 630 630
  • Page 631 631
  • Page 632 632
  • Page 633 633
  • Page 634 634
  • Page 635 635
  • Page 636 636
  • Page 637 637
  • Page 638 638
  • Page 639 639
  • Page 640 640
  • Page 641 641
  • Page 642 642
  • Page 643 643
  • Page 644 644
  • Page 645 645
  • Page 646 646
  • Page 647 647
  • Page 648 648
  • Page 649 649
  • Page 650 650
  • Page 651 651
  • Page 652 652
  • Page 653 653
  • Page 654 654
  • Page 655 655
  • Page 656 656
  • Page 657 657
  • Page 658 658
  • Page 659 659
  • Page 660 660
  • Page 661 661
  • Page 662 662
  • Page 663 663
  • Page 664 664
  • Page 665 665
  • Page 666 666
  • Page 667 667
  • Page 668 668
  • Page 669 669
  • Page 670 670
  • Page 671 671
  • Page 672 672
  • Page 673 673
  • Page 674 674
  • Page 675 675
  • Page 676 676
  • Page 677 677
  • Page 678 678
  • Page 679 679
  • Page 680 680
  • Page 681 681
  • Page 682 682
  • Page 683 683
  • Page 684 684
  • Page 685 685
  • Page 686 686
  • Page 687 687
  • Page 688 688
  • Page 689 689
  • Page 690 690
  • Page 691 691
  • Page 692 692
  • Page 693 693
  • Page 694 694
  • Page 695 695
  • Page 696 696
  • Page 697 697
  • Page 698 698
  • Page 699 699
  • Page 700 700
  • Page 701 701
  • Page 702 702
  • Page 703 703
  • Page 704 704
  • Page 705 705
  • Page 706 706
  • Page 707 707
  • Page 708 708
  • Page 709 709
  • Page 710 710
  • Page 711 711
  • Page 712 712
  • Page 713 713
  • Page 714 714
  • Page 715 715
  • Page 716 716
  • Page 717 717
  • Page 718 718
  • Page 719 719
  • Page 720 720
  • Page 721 721
  • Page 722 722
  • Page 723 723
  • Page 724 724
  • Page 725 725
  • Page 726 726
  • Page 727 727
  • Page 728 728
  • Page 729 729
  • Page 730 730
  • Page 731 731
  • Page 732 732
  • Page 733 733
  • Page 734 734
  • Page 735 735
  • Page 736 736
  • Page 737 737
  • Page 738 738
  • Page 739 739
  • Page 740 740
  • Page 741 741
  • Page 742 742
  • Page 743 743
  • Page 744 744

VMware vFabric SQLFire 1.1.1 User guide

Category
Software manuals
Type
User guide

Ask a question and I''ll find the answer in the document

Finding information in a document is now easier with AI