Smart Transactions

MariaDB SkySQL includes MariaDB Platform for Smart Transactions.

MariaDB Platform for Smart Transactions optimizes MariaDB Enterprise Server for a combined transactional and analytical workload by using both the MariaDB ColumnStore and InnoDB storage engines, and by using HTAP Replication to replicate between them.

Smart transactions are known by many names – augmented transactions, Translytical, Hybrid Transactional-Analytical Processing or HTAP, Hybrid Operational-Analytical Processing or HOAP. Whatever they are called, smart transactions are standard transactions enriched by analytics to provide a better customer experience.

Some examples:

  • Flagging a fraudulent credit card transaction that is outside the norm for a specific account

  • Using a predictive needs analysis on a checking account to alert customers and help them avoid overdraft fees

  • Using historical data to predict the likelihood of a particular flight being on time and provide that information in real time to the customer who is booking a flight.

Providing that kind of enriched customer experience, requires both transactional and analytical processing working seamlessly together. By combining row and columnar formats as well as block and object storage, MariaDB Platform for Smart Transactions is the first database built to perform high-performance transactions and low-cost analytics in the cloud – together.

MariaDB Platform for Smart Transactions on SkySQL delivers the following features:

Topology

Storage Engine

Number of Instances

Replication

Columnar Storage

Object Storage
(Grows Infinitely)

Production-Ready

Development/UAT-Ready

HTAP

InnoDB (Transactions)
ColumnStore (Analytics)

1

HTAP Replication

Yes (Analytics)

Yes (Analytics)

Yes

Yes

Provision your service now.