1.0

-rw-rw-r-- 1 jpearson users 25 Apr 7 14:56 BACKUPds1_3.crf
drwxrwxr-x 3 jpearson users 1024 Apr 7 15:02 ..
-rw-rw-r-- 1 jpearson users 7085 Apr 7 15:06 BACKUPds1.if
-rw-rw-r-- 1 jpearson users 18 Apr 7 15:07 BACKUPds1_4.drf
-rw-rw-r-- 1 jpearson users 1070 Apr 7 15:07 BACKUPds1_4.crf
drwxrwxr-x 2 jpearson users 512 Apr 7 15:07 .
bash-2.05$ sqlf validate-disk-store ds1 backupDirectory
/root: entryCount=6
/partitioned_region entryCount=1 bucketCount=10
Disk store contains 12 compactable records.
Total number of region entries in this disk store is: 7
bash-2.05$ sqlf compact-disk-store ds1 backupDirectory
Offline compaction removed 12 records.
Total number of region entries in this disk store is: 7
bash-2.05$ ls -ltra backupDirectory
total 16
-rw-rw-r-- 1 jpearson users 3 Apr 7 14:56 BACKUPds1_3.drf
-rw-rw-r-- 1 jpearson users 25 Apr 7 14:56 BACKUPds1_3.crf
drwxrwxr-x 3 jpearson users 1024 Apr 7 15:02 ..
-rw-rw-r-- 1 jpearson users 0 Apr 7 15:08 BACKUPds1_5.drf
-rw-rw-r-- 1 jpearson users 638 Apr 7 15:08 BACKUPds1_5.crf
-rw-rw-r-- 1 jpearson users 2788 Apr 7 15:08 BACKUPds1.if
drwxrwxr-x 2 jpearson users 512 Apr 7 15:09 .
bash-2.05$
Backing Up and Restoring Online Disk Stores
When you invoke the sqlf backup command, SQLFire backs up disk stores for all members that are running
in the distributed system at that time. Each member with persistent data creates a backup of its own configuration
and disk stores.
• Backup Guidelines and Prerequisites on page 83
• Back Up an Online Disk Store on page 84
• What the Online Backup Saves on page 84
• Restore an Online Backup on page 84
Backup Guidelines and Prerequisites
• Run the backup during a period of low activity in your system. The backup does not block any activities in the
distributed system, but it does use file system resources on all hosts in your distributed system and can affect
performance.
• Optionally, compact your disk store before running the backup. See Compacting Disk Store Log Files on page
80.
•
Only use the sqlf backup command to create backup files from a running distributed system. Do not try
to create backup files from a running system using file copy commands. You will get incomplete and unusable
copies.
• Back up to a directory that all members can access. Make sure the directory exists and has the proper permissions
for your members to write to it and create subdirectories.
•
Make sure there is a sqlfire.properties file for the distributed system in the directory where you will
run the sqlf command, or specify the multicast port or locator properties to connect to the cluster (for example,
-mcast-port= port_number). The command will back up all disk stores in the specified distributed system.
• The directory you specify for backup can be used multiple times. Each backup first creates a top level directory
for the backup, under the directory you specify, identified to the minute.
83
Using Disk Stores to Persist Data