Skip navigation links

Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Asia Pacific: +81 3 5843 1140

Contact Us Online »

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

MySQL Data Warehouse

Infobright

One of the top use cases for the MySQL Server is data warehousing and analytics. By offloading operational data onto MySQL data warehouses, IT professionals can run all their key business intelligence operations at a much lower cost than those charged by expensive proprietary vendors.

Download the White Paper: Enterprise Data Warehousing with MySQL »

With its unique pluggable storage engine architecture, MySQL offers several server solutions for those wanting to experience the benefits of open source data warehousing:

Native MySQL Storage Engines

MySQL offers a number of internally developed storage engines that are well-suited for data warehouses, with the most popular being the default MyISAM storage engine. The MyISAM engine delivers rapid data loading capabilities, fast read times, and much more for data warehousing users. Typical MyISAM support for data warehouse volumes range up to 1TB comfortably. MySQL offers other storage engines that can also be used for data warehousing as well. MySQL supports these key data warehousing features:

  • Data/Index partitioning (range, hash, key, list, composite) in MySQL 5.1 and above
  • No practical storage limits with automatic storage management
  • Built-in Replication
  • Strong indexing support (B-tree, fulltext, clustered, hash, GIS)
  • Multiple, configurable data/index caches
  • Pre-loading of data into caches
  • Unique query cache (caches result set + query; not just data)
  • Parallel data load
  • Multi-insert DML
  • Read-only tables
  • Cost-based optimizer
  • Wide platform support

Infobright

Infobright offers a storage engine for the MySQL Server that is tailor-made for large scale, analytic-styled data warehousing. Infobright enables MySQL users to move up to data warehouses that support data volumes of 1-10TB or more with these key capabilities:

  • Column-oriented design
  • High data compression capabilities
  • Advanced optimizer with "Knowledge Grid"
  • High-speed loader

Learn more »

Download the White Paper: Infobright Technology White Paper »

Additional Resources

On-Demand Webinars

Discussion Forums