Get real-time analytics in your application by replicating your transactional table to an analytical table running DexterityDB. Automatically route your application's read/analytical queries to this table for quick answers to the questions that will make your application run more smoothly and effectively. Use with a single machine or multi-machine setup.
OLTP Configuration (InnoDB) -> Master-Slave Replication -> OLAP Configuration (DexterityDB)
Write Query -> ProxySQL -> InnoDB
Read Query -> ProxySQL -> DexterityDB
Set up logging on your biggest systems with confidence. Replace your current databases storage engine with DexterityDB to achieve quick ingestion that eliminates the need to slow down your operations so that your database can catch up. When it's time to look back, search and analyze logs quickly and efficiently with powerful filtering technology. Smart partitioning reduces locks so logging won't slow down while you search.
External Operations -> Logging Configuration (DexterityDB) -> (Optional) Search and Analysis tools
Quicker report generation allows for more agility in your business, and the ability to incorporate even more data into your analytics means better quality decision-making. DexterityDB was designed to handle intensive OLAP jobs such as large reports that require complex queries and massive datasets supplied by OLTP configurations and an ETL process.
OLTP Configuration (InnoDB) -> ETL Process -> OLAP Configuration (DexterityDB) -> Report Generation Tool