ITTIA has updated its lightweight, Linux-compatible SQL R-DBMS (relational database management system) with High Availability (HA) and replication features aimed at embedded applications. ITTIA DB SQL 4.1 has added support for two-phase commit, synchronous replication on commit, table snapshots, and distributed transactions, says the company.

In April, ITTIA announced a High Availability (HA) version of DB SQL. Now this capability has been rolled into the mainstream DB SQL 4.1 release, and updated with more advanced replication and HA functionality, says ITTIA.

ITTIA DB SQL replication functionality enables applications to automatically update other devices or backup storage media, without fear of component failure, says ITTIA. Applications can also use ad hoc replication to control the exchange of data, says the company.

If a synchronously replicated database is disconnected for some time, DB SQL can send snapshots of the tables from another database to quickly bring it back in line, says ITTIA. These table snapshots can also be used to synchronize two databases without configuring replication.

Distributed transactions

In addition, applications can use distributed transactions to commit changes to two or more database files at once, on the same device or over the network, says the company. A new two-phase commit feature is said to ensure that changes are safely stored to every database before any one database is irrevocably committed. As a result, it's said, it's now easier to move data safely between databases.

Other features in the HA version of DB SQ — which was previously based on DB SQL 3.3 — also appear to be available in DB SQL 4.1. These include bidirectional data exchange between peer databases as well as online backup, which supplements built-in crash recovery with backup technology. Online backup does not interrupt access to the database, either for reading and writing, says ITTIA.

Stated Sasan Montaseri, ITTIA President, "ITTIA DB SQL offers great high availability features, including replication, mirroring and on-line back-up, to help application developers of embedded systems and devices to build a scalable data management foundation."

Availability

ITTIA DB SQL 4.1 is available now at an undisclosed price. Evaluation copies are available for Linux X86 and ARM platforms, as well as Windows 32, and DB SQL 4.0 evaluation copies are available for Linux x86, Windows Mobile, Windows CE, and QNX ARM and x86 platforms, at ITTIA's DB Evaluation Center.

This article was originally published on LinuxDevices.com and has been donated to the open source community by QuinStreet Inc. Please visit LinuxToday.com for up-to-date news and articles about Linux and open source.