Scaling MySQL for Analytics and Data Warehousing - Leveraging BI tools
Infobright's integration with MySQL provides MySQL users the ideal solution for scalable analytics and data warehousing - to 50TB and beyond. With outstanding query performance, very fast load speed and massive data compression, Infobright delivers the performance you need for analytics and BI as the amount of data you want to keep grows. In addition, the familiar MySQL user interface means you won't need to learn how to manage Infobright, you already know!
Infobright's software includes MySQL as part of the distribution, so no separate download is needed.
If you are looking to upgrade from MySQL to Infobright to achieve faster performance for queries, reporting and analysis, you will find it easy to do. Download this short Migration Guide that provides a step-by-step guide to the transition. How_To_Migrate_from_MyISAM.pdf.
Interested in seeing how Infobright compares to MySQL/InnoDB for analytics? Read the results of some testing that an Infobright Community Edition user performed.
Integration with MySQL enables Infobright users to choose from the world's leading business intelligence tools for their analytic needs. Infobright and MySQL: the perfect combination.
MySQL is the world's most popular open source database software, with over 11 million active installations. Infobright brings scalable analytics to MySQL users through its integration as a MySQL storage engine. If your MySQL database is growing and query performance is suffering, Infobright is the ideal choice.
In the data warehouse marketplace, the database must integrate with a variety of tools. By integrating with MySQL, Infobright leverages the extensive tool connectivity provided by MySQL connectors (C, JDBC, ODBC, .NET, Perl, etc.).
It also enables MySQL users to leverage the mature, tested BI tools with which they're already familiar. You'll also benefit from MySQL's legendary ease of use and low maintenance requirements.
Infobright-MySQL integration includes the following features:
- Industry standard interfaces that include ODBC, JDBC, C API, PHP, Visual Basic, Ruby, Perl and Python;
- Comprehensive management services and utilities;
- Robust connectivity with BI tools such as Actuate/BIRT, Business Objects, Cognos, Microstrategy, Pentaho, Jaspersoft and SAS.
The challenge that JDSU put before Infobright was to capture and enable near real-time analysis of huge volumes of data traversing some of the world's largest carrier networks, at lower…
A New Approach
The Analytic Data Warehouse
Traditional data warehouse products put a tremendous burden on IT in order to create and maintain an environment that will allow users to query against large volumes of data.