1.1.1

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