Tutorials

Learn to configure and use SQLFire features such as table
replication and partitioning, persisting data to disk, and dynamically resizing
the cluster.

Main Steps
The tutorial is divided into the following steps, which explain how to set up a cluster of SQLFire servers on multiple Java VMs and then distribute data across the cluster. Perform the steps in the sequence shown.

Connect to the Cluster Using SQLF
sqlf implements a command-line tool that is based on the Apache Derby ij tool. You can use sqlf to connect to a SQLFire cluster and run scripts or interactive queries. You execute sqlf using the sqlf or sqlf.bat script.

Implement a Partitioning Strategy
In this procedure you drop all tables in the ToursDB schema and then recreate them using a new partitioning and replication strategy.

Persist Tables to Disk
At this point, the SQLFire cluster manages the ToursDB tables only in memory. In this procedure you persist table data to disk.

Add Servers to the Cluster and Stop Servers
SQLFire manages data in a flexible way that enables you to expand or contract your cluster at runtime to support different loads. To dynamically add more capacity to a cluster, you add new server members and specify the -rebalance option.

Perform Additional Tasks
After you complete the SQLFire tutorial, you can perform related tutorial tasks to explore other areas of the product.