PrimeBase Technologies - PBXT Storage Engine for MySQL

PrimeBase XT (PBXT) is a transactional storage engine for MySQL. As illustrated below, a MySQL storage engine responsible for the caching, indexing and storage management of MySQL table data.

On Creation of a table in MySQL, the storage engine may be specified. This determines the basic characteristics of the table. For example, the default storage engine is MyISAM, which can be used for non-transactional data that requires fast read access. A table which uses the MEMORY storage engine is held completely in RAM.

Tables that use the PBXT Storage engine have the following features:

• MVCC: Multi-version concurrency control, enables reading without locking.
• Transactional: support for BEGIN, COMMIT and ROLLBACK and recovery on startup.
• ACID compliant: Atomic, Consistent, Isolated, Durable (once committed changes cannot be lost).
• Row-level locking: updates use row-level locking allowing for maximum concurrency.
• Deadlock detection: immediate notification if client processes are deadlocked.
• Referential Integrity: foreign key support.
• Write-once: PBXT avoids double-writes by using a log-based architecture.

BLOB streaming: In combination with the BLOB Streaming engine.