Supported Configurations and System Requirements

Before installing vFabric SQLFire, make sure your system meets the minimum system requirements for installing and running the product.

Supported Configurations

The following table shows all supported configurations for vFabric SQLFire. These include vFabric Suite supported configurations, as well as additional configurations supported by standalone vFabric SQLFire.

The tables indicate whether the supported configuration is for production or development. Generally, production support means you can run your production application on the platform; developer support means you can develop on the platform but you should not run your production application on it.

Operating System Processor Architecture JVM Production or Developer Support
Red Hat EL 5 x86_64, x86_32 Java SE 6, update 0_26 Production
Red Hat EL 6 x86_64, x86_32 Java SE 6, update 0_26 Production
Windows Server 2003 R2 SP2 Professional or Enterprise* x86_64, x86_32 Java SE 6, update 0_26 Production
Windows Server 2008 R2 Standard* x86_64, x86_32 Java SE 6, update 0_26 Production
Windows 7 SP1 Professional or Enterprise* x86_64, x86_32 Java SE 6, update 0_26 Developer
Windows XP x86_64 Java SE 6 Developer
Ubuntu 10.04 x86_64 Java SE 6 Developer

*The Microsoft Loopback Adapter is not supported.

Note: The SQLFire product download does not include Java; you must download and install a supported JDK for your system.

Host Machine Requirements

Requirements for each host:
  • A supported Java SE installation.
  • File system that supports long file names.
  • Adequate per-user quota of file handles (ulimit for Linux)
  • TCP/IP.
  • System clock set to the correct time.
  • For each Linux host, the hostname and host files must be properly configured. See the system manpages for hostname and hosts.
  • Time synchronization service such as Network Time Protocol (NTP).
Note: For troubleshooting, you must run a time synchronization service on all hosts. Synchronized time stamps allow you to merge log messages from different hosts, for an accurate chronological history of a distributed run.

Increase Unicast Buffer Size on Linux Platforms

On Linux platforms, execute the following commands as the root user to increase the unicast buffer size:
sysctl -w net.core.rmem_max=1048576
sysctl -w net.core.wmem_max=1048576

Disable SYN Cookies on Linux Platforms

Many default Linux installations use SYN cookies to protect the system against malicious attacks that flood TCP SYN packets. The use of SYN cookies dramatically reduces network bandwidth, and can be triggered by a running SQLFire distributed system.

If your SQLFire distributed system is otherwise protected against such attacks, disable SYN cookies to ensure that SQLFire network throughput is not affected.

To disable SYN cookies permanently:
  1. Edit the /etc/sysctl.conf file to include the following line:
    net.ipv4.tcp_syncookies = 0

    Setting this value to zero disables SYN cookies.

  2. Reload sysctl.conf:
    sysctl -p

Client Requirements

SQLFire supports two JDBC drivers: a thin client JDBC driver and a peer JDBC driver. SQLFire server instances and the peer driver are supported only with Java SE 6. You can download Java from

SQLFire provides a managed ADO.NET driver that you can use for developing non-Java client applications. The ADO.NET driver uses IKVM technology to translate SQLFire JDBC core libraries to .NET MSIL. The ADO.NET driver is supported for applications built using the Microsoft .NET 2.0 SP1 or higher framework.