1.1

ManualsBrandsVMware ManualsApplicationsvFabric SQLFire

Table Of Contents

Using VSD to Analyze Statistics...............................................................................................................280

Chapter 48: Using Java Management Extensions (JMX)....................291

Using a JMX Manager Node.....................................................................................................................291

Using a vFabric SQLFire JMX Agent........................................................................................................294

Chapter 49: Best Practices for Tuning Performance...........................307

Tune Application Logic..............................................................................................................................307

Reduce Distribution Overhead..................................................................................................................307

Reduce Overhead of Eviction to Disk.......................................................................................................308

Minimize Update Latency for Replicated Tables.......................................................................................308

Tune FabricServers...................................................................................................................................308

Tuning Disk I/O.........................................................................................................................................309

Running SQLFire in Virtualized Environments..........................................................................................310

Chapter 50:Detecting and Handling Network Segmentation ("Split Brain").311

Part VII: vFabric SQLFire Reference......................................................313

Chapter 51: Configuration Properties..................................................315

Chapter 52: JDBC API............................................................................351

Mapping java.sql.Types to SQL Types......................................................................................................351

java.sql.BatchUpdateException Class......................................................................................................352

java.sql.Connection Interface....................................................................................................................352

java.sql.DatabaseMetaData Interface.......................................................................................................353

java.sql.Driver Interface............................................................................................................................355

java.sql.DriverManager.getConnection Method........................................................................................355

java.sql.PreparedStatement Interface.......................................................................................................355

java.sql.ResultSet Interface......................................................................................................................357

java.sql.SavePoint Class...........................................................................................................................357

java.sql.SQLException Class....................................................................................................................357

java.sql.Statement Class..........................................................................................................................357

javax.sql.XADataSource...........................................................................................................................357

Chapter 53: sqlf Launcher Commands................................................359

sqlf backup................................................................................................................................................360

sqlf compact-all-disk-stores......................................................................................................................363

sqlf compact-disk-store.............................................................................................................................364

sqlf encrypt-password...............................................................................................................................365

sqlf install-jar.............................................................................................................................................365

sqlf list-missing-disk-stores.......................................................................................................................368

sqlf locator................................................................................................................................................369

sqlf Logging Support.................................................................................................................................374

sqlf merge-logs.........................................................................................................................................374

Contents