1.0

Implement a Partitioning Strategy...............................................................................................................31
Persist Tables to Disk..................................................................................................................................34
Add Servers to the Cluster and Stop Servers.............................................................................................35
Perform Additional Tasks............................................................................................................................36
Chapter 8: vFabric SQLFire Features and Benefits...............................37
Part II: Managing Your Data in vFabric SQLFire.....................................39
Chapter 9: Designing vFabric SQLFire Databases................................41
Design Principles of Scalable, Partition-Aware Databases.........................................................................41
Identify Entity Groups and Partitioning Keys...............................................................................................41
Replicate Code Tables................................................................................................................................42
Dealing with Many-to-Many Relationships..................................................................................................42
Example: Adapting a Database Schema for SQLFire.................................................................................43
Chapter 10: Using Server Groups to Manage Data................................47
Server Groups Overview.............................................................................................................................47
Adding Members to Server Groups............................................................................................................49
Assigning Tables to Server Groups.............................................................................................................50
Chapter 11: Partitioning Tables...............................................................51
How Table Partitioning Works.....................................................................................................................51
Understanding Where Data Is Stored.........................................................................................................52
Failure and Redundancy.............................................................................................................................53
Creating Partitioned Tables.........................................................................................................................54
Rebalancing Partitioned Data on SQLFire Members..................................................................................59
Managing Replication Failures....................................................................................................................60
Chapter 12: Replicating Tables................................................................61
How SQLFire Replicates Tables.................................................................................................................61
Deciding When to Use Replicated Tables...................................................................................................61
Creating Replicated Tables.........................................................................................................................62
Chapter 13: Estimating Memory Requirements.....................................63
Estimating SQLFire Overhead....................................................................................................................63
Viewing Memory Usage in SYS.MEMORYANALYTICS..............................................................................64
Chapter 14: Using Disk Stores to Persist Data......................................69
Overview of Disk Stores..............................................................................................................................69
Guidelines for Designing Disk Stores.........................................................................................................74
Creating a Disk Store or Using the Default.................................................................................................75
Persist Table Data to a Disk Store...............................................................................................................76
Optimizing Availability and Performance.....................................................................................................77
Starting System with Disk Stores................................................................................................................77
vFabric SQLFire User's Guideiv