1.0

Install a DBSynchronizer configuration with a persistent event queue:
CREATE ASYNCEVENTLISTENER mydbsynch
(
LISTENERCLASS 'com.vmware.sqlfire.callbacks.DBSynchronizer'
INITPARAMS
'org.apache.derby.jdbc.EmbeddedDriver,jdbc:derby:newDB;create=true;'
ENABLEPERSISTENCE true
DISKSTORENAME mystore
)
SERVER GROUPS (primary_listener_group);
Install another DBSynchronizer for failover:
CREATE ASYNCEVENTLISTENER mydbsynch
(
LISTENERCLASS 'com.vmware.sqlfire.callbacks.DBSynchronizer'
INITPARAMS
'org.apache.derby.jdbc.EmbeddedDriver,jdbc:derby:newDB;create=true;'
ENABLEPERSISTENCE true
DISKSTORENAME mystore
)
SERVER GROUPS (secondary_listener_group);
Create a new table and attach the installed DBSynchronizer:
CREATE TABLE TESTTABLE (ID INT NOT NULL,
NAME VARCHAR(10))
ASYNCEVENTLISTENER(mydbsynch);
Note: You can optionally install the AsyncEventListener configuration after you
associate a table with the listener name. Make sure that you use the same listener
name with both the CREATE ASYNCEVENTLISTNER command and the CREATE
TABLE command.
CREATE DISKSTORE
Disk stores provide disk storage for tables and queues that need to overflow or persist (for instance when using
an asynchronous write-behind listener).
Syntax
CREATE DISKSTORE
diskstore_name
[ MAXLOGSIZE integer-constant ]
[ AUTOCOMPACT boolean-constant ]
[ ALLOWFORCECOMPACTION
boolean-constant ]
[ COMPACTIONTHRESHOLD
integer-constant ]
[ TIMEINTERVAL
integer-constant ]
[ WRITEBUFFER SIZE
integer-constant ]
[ QUEUESIZE
vFabric SQLFire User's Guide438
vFabric SQLFire Reference