No account yet?
JA Control Panel drop down login

MySQL Wasn't Designed for Large Data Warehousing

While MySQL has now become one of the most prevalent databases in use today, DBAs and system architects have often been disappointed over its inability to scale well with large data volumes or when complex, analytic queries are required.  As such, it has not been adopted widely for data marts and data warehousing needs that underlie BI and analytic applications.

Analytic MySQL deployments are often challenged by a high volume of reads across many rows of data and encounter scalability and performance problems due to:

  • Lack of transparent, distributed scaling
  • Lack of distributed, parallel table scans
  • Lack of distributed hash joins
  • Lack of parallel SQL, DML, or load capabilities

InfiniDB - Scalable Data Engine for MySQL

Fortunately, MySQL users have a way to scale their data environments for BI and analytics.  Calpont InfiniDB Enterprise is an analytic database engine specifically designed to handle deep analytics and deliver very fast performance for data warehouses and read-intensive applications.

InfiniDB uses MySQL front end for in its User Module for basic SQL parsing, security, and other administrative tasks. All GUI and command line management and development tools, BI suites, application IDE’s, connectors, and drivers that work with MySQL will also work with InfiniDB, making InfiniDB a familiar user experience.

Distributed MPP for MySQL

However, the similarities quickly end there. Unlike MySQL, InfiniDB is a column database, not a row-based architecture, which enables scalability through a two-tiered distribution of work model that scales-out with the addition of commodity hardware, while keeping a linear performance output with data and user growth.

InfiniDB is the only MySQL solution that offers distributed, massive parallel processing MPP capabilities for data warehousing. InfiniDB does this through a software-only, modular architecture approach that allows a DBA or system architect to scale-out both at the concurrency layer (using InfiniDB’s User Modules) and at the I/O layer (with InfiniDB’s Performance Modules). InfiniDB’s MPP architecture result in linear performance gains when additional nodes are added to a system.

Benefits of InfiniDB Enterprise for MySQL environments

  • MPP provides the ability to scale for very large data volumes with the addition of commodity hardware.
  • Column-orientation enables extremely fast analytic query performance against the data, even as the data scales-out.
  • MySQL interface means no new learning curve.
  • Quick migration of MySQL data through InfiniDB’s high speed data loading tool

Try InfiniDB Free