1.1

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