Pentaho Business Intelligence and MySQL on Sun Storage 7000 Unified Storage System

Krishnan Shankar, April 2009 ( Updated April 29, 2009)

Introduction

This paper demonstrates how the Sun Storage 7000 Unified Storage System can be used to share NFS and iSCSI file systems with Pentaho Business Intelligence and MySQL database servers deployed on Sun SPARC and x86 servers running the Solaris 10 Operating System.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• Objective
• Introduction
• Hardware Configuration
• Software Configuration
• Configuration Test Procedures
  • Configuring a Project on the Sun Storage 7000 Unified Storage System
  • Configuring for NFS on the Sun Storage 7000 Unified Storage System
  • Configuring for iSCSI on the Sun Storage 7000 Unified Storage System
  • Configuring for NFS on the Solaris Client
  • Configuring for iSCSI on the Solaris Client
  • Configuring MySQL on the Solaris Client
  • Configuring VNC Software on the Solaris Client
  • Configuring Apache Tomcat and the MySQL Connector on the Solaris Client
  • Configuring Pentaho Data Integration on the Windows Client
  • Configuring Pentaho Reports Designer on the Solaris Client
  • Configuring Mondrian OLAP Server on the Solaris Client
• Sun Storage 7000 Unified Storage System
• Other Sun Technologies (Solaris 10 OS, Sun Fire Servers, MySQL)
• Pentaho Business Intelligence
• Summary

For More Information

Here are some additional resources:

• Pentaho Open Source Business Intelligence web site
• Sun Storage 7000 Unified Storage System web site
• Fishworks Wiki
• Sun BluePrints wiki, with papers (registration required) such as:
  • MySQL Guide for Sun Storage 7000 Unified Storage System
  • Running MySQL Database in Solaris Containers
  • Improving MySQL Database Scalability
• Sun download site
• Sun training courses at http://www.sun.com/training/, for example, Sun Storage 7000 Unified Storage System Administration (NWS-6425)
• Sun forums such as:
  • Sun forums
  • BigAdmin Discussions collection
• Sun product documentation at http://docs.sun.com, such as:
  • Sun Storage 7110 Unified Storage System documentation
  • Sun Storage 7210 Unified Storage System documentation
  • Sun Storage 7410 Unified Storage System documentation
• Sun Documentation Center
• BigAdmin wiki:
  • Storage Tech Tips
  • Databases page
• Resources on BigAdmin, such as:
  • MySQL Resources for System Administrators
  • Database resource collection (includes community submissions)
  • Storage resource collection (includes community submissions)
• Support:
  • Sun resources:
    • Register your Sun gear
    • Services
    • SunSolve Online
  • Community system administration experts
• Events of interest to users of Sun products:
  • Worldwide Developer Events and Sun Tech Days
  • Current Events

Updates

April 29, 2009: Changed "Configuring Pentaho Data Integration on the Solaris Client" to "Configuring Pentaho Data Integration on the Windows Client".