MySQL Users Require a Solution for Big Data Analytics
While MySQL has now become one of the most prevalent databases in use today, DBAs and system architects have often noted its inability to scale well with large data volumes when complex analytic queries are required. This is because it was designed for transaction style workloads, as opposed to analytic workloads.
MySQL deployments for Big Data analytics are often challenged by a high volume of reads across many rows of data and encounter scalability and performance problems due to a lack of:
- Transparent, distributed scaling
- Distributed, parallel table scans
- Distributed hash joins
- Parallel SQL, DML, or load capabilities
InfiniDB – Scalable Analytic Engine for MySQL Environments
Fortunately, MySQL users have a way to scale their data environments for BI and analytics. Calpont InfiniDB Enterprise is an analytic engine specifically designed to handle deep analytics and deliver extremely fast performance for analytic data warehouses.
InfiniDB uses MySQL as a front end for SQL creation, parsing, security, and some 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.
Optimal Design for Big Data Analytics while Leveraging 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 analytic engine that leverages MySQL to offer distributed massive parallel processing (MPP) capabilities for analytics. 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 results 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 to InfiniDB using InfiniDB’s high speed data loading tool