1.1.1

ManualsBrandsVMware ManualsApplicationsvFabric SQLFire

Table Of Contents

Using VSD to Analyze Statistics...............................................................................................................284

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

Using a JMX Manager Node.....................................................................................................................295

Using a vFabric SQLFire JMX Agent........................................................................................................298

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

Tune Application Logic..............................................................................................................................311

Reduce Distribution Overhead..................................................................................................................311

Reduce Overhead of Eviction to Disk.......................................................................................................312

Minimize Update Latency for Replicated Tables.......................................................................................312

Tune FabricServers...................................................................................................................................312

Tuning Disk I/O.........................................................................................................................................313

Running SQLFire in Virtualized Environments..........................................................................................314

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

Part VII: vFabric SQLFire Reference......................................................317

Chapter 51: Configuration Properties..................................................319

Chapter 52: JDBC API............................................................................357

Mapping java.sql.Types to SQL Types......................................................................................................357

java.sql.BatchUpdateException Class......................................................................................................358

java.sql.Connection Interface....................................................................................................................358

java.sql.DatabaseMetaData Interface.......................................................................................................359

java.sql.Driver Interface............................................................................................................................361

java.sql.DriverManager.getConnection Method........................................................................................361

java.sql.PreparedStatement Interface.......................................................................................................361

java.sql.ResultSet Interface......................................................................................................................363

java.sql.SavePoint Class...........................................................................................................................363

java.sql.SQLException Class....................................................................................................................363

java.sql.Statement Class..........................................................................................................................363

javax.sql.XADataSource...........................................................................................................................363

Chapter 53: sqlf Launcher Commands................................................365

sqlf backup................................................................................................................................................367

sqlf compact-all-disk-stores......................................................................................................................369

sqlf compact-disk-store.............................................................................................................................370

sqlf encrypt-password...............................................................................................................................371

sqlf install-jar.............................................................................................................................................373

sqlf list-missing-disk-stores.......................................................................................................................376

sqlf locator................................................................................................................................................377

sqlf Logging Support.................................................................................................................................382

sqlf merge-logs.........................................................................................................................................382

Contents