Manuals / Brands / Computer Equipment / Software / HP / Computer Equipment / Software

HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 3.8.2.1 Installing MySQL Server

1 378

Download 378 pages, 2.5 Mb

System Reporter 2.8

3PAR System Reporter User’s Guide

3.8.2.1 Installing MySQL Server

To use MySQL for the 3PAR System Reporter database, obtain a software license and a copy of MySQL Database Server, version 5.1. See www.mysql.com for licensing and download instructions.

NOTE: Beginning with the 2.2 release, System Reporter can use a MySQL database on a remote server. The MySQL installation and configuration steps are the same for the remote server. See section 3.9 Installing or Upgrading the System Reporter Tools on page 3.24 for configuring System Reporter to use a remote MySQL database.

After downloading the MySQL executable, use the MySQL Server Setup Wizard to set up and configure MySQL as follows:

1Open the MySQL executable.

2When prompted, click Next.

3Choose a Typical installation and click Next.

4Click Install.

5Click Skip Sign-Upthen click Next.

6Make sure that Configure MySQL Server now is checked and then click Finish. The MySQL Server Instance Configuration Wizard appears.

Installing the Database Server

3.17

Contents

3PAR® System Reporter 2.8 User’s Guide Page Page Page Page Page Page Page Page Page Table of Contents 1 Introduction 2 Overview and Features 3 Installation, Configuration, Update, and Removal 4 Getting Started 5 Accessing and Creating Reports Page Page 6 Interpreting Report Metrics 7 Configuring the System Reporter Policy Settings 8 Web Queries Page Page 9Using Adaptive Optimization 10 Database Schema 11 Troubleshooting IX Index RH Revision History Page 1 Introduction 1.1 Audience 1.2 User Interfaces 1.3Related Documentation 1.4 Organization 1.5 Typographical Conventions 1.6 Advisories Overview and Features 2.1 About 3PAR System Reporter 2.2Configuring System Reporter Policy Settings 2.3 Choosing a Method for Accessing Reports 2.4 Creating Customized Reports Page 2.5 Formatting Reports for Presentation 2.6 Customizing the Reporting Format 2.7 Generating Email Alerts 2.8 Accessing Report Data using Web Queries 2.9 Using the Database Schema to Build Custom Reports 2.10 Analyzing and Optimizing Storage Utilization Installation, Configuration, Update, and Removal 3.1 Before You Begin 3.2 System Reporter CD Contents Page 3.3 System Requirements Page 3.4 Using the System Reporter Sizing Spreadsheet Page Page 3.5 System Reporter Components Page 3.6 Installing the System Reporter Components Page 3.7 Installing the Web Server 3.8 Installing the Database Server 3.8.1 Choosing the Appropriate Database 3.8.1.1 SQLite 3.8.1.2 MySQL 3.8.1.3 Oracle 3.8.2 Installing and Setting Up the MySQL Database (Optional) 3.8.2.1 Installing MySQL Server 3.8.2.2 Configuring the MySQL Database 3.8.2.3 Setting the max_allowed_packet parameter 3.8.2.4 Creating MySQL Users and Schema 3.8.3 Setting Up the Oracle Database (Optional) 3.8.3.1 Creating an Oracle database 3.8.3.2 Creating the Oracle Users for System Reporter 3.8.3.3 Creating the Oracle Net Service 3.9 Installing or Upgrading the System Reporter Tools 3.9.0.1 Installing or Upgrading System Reporter Tools on Windows Page Page Page 3.9.0.2 Installing System Reporter Tools on Linux Page Page 3.9.1 Adding InServ Systems 3.9.1.1 Setting File Permissions (Optional) 3.9.1.2 Verifying Installation 3.10 Installing the Excel Client (Optional) 3.11 About Apache HTTP Server Authorization and Access Control Page 3.12 Removing the System Reporter Components 3.12.1 Removing the System Reporter Tools on Windows 3.12.2Removing the System Reporter Tools on Linux 3.12.3Removing the MySQL Database (Optional) Page Getting Started 4.1 Accessing the Main System Reporter Interface Page 4.2 System Reporter Main Menu Window 4.3 Getting Help 4.4 Using the Object Selection Controls 4.4.1 Simple Selection List 4.4.2 Filtered Multi-SelectionControl 4.5 Accessing the Optional Excel Client 4.5.1 Starting the System Reporter Excel Client 4.5.2 Setting the Security Level for Excel 4.5.2.1 Setting the Security for Excel Page Page 4.5.2.2 Setting the Security Level for Excel Page 4.5.3 Connecting to the Web Server from the Excel Client Page 4.6 Changing the Excel Client Server and Resetting the Workbook 4.6.1 Changing the Web Server 4.6.2Resetting the Workbook 4.7Accessing the Excel Client Query Log 4.8 Deleting Excel Sheets 4.8.1 Deleting Menu Sheets 4.8.2Deleting Data Sheets 4.8.3Deleting the Query Log 4.9Saving and Exiting the Excel Client Page Accessing and Creating Reports 5.1 Accessing Quick Reports 5.2 Accessing Scheduled Reports 5.3 Creating Custom Reports 5.3.1 Building the Report Menu 5.3.1.1 Sample Resolution 5.3.1.2 Report Page 5.3.1.3 Select Systems 5.3.1.4 Select Domains 5.3.2 Generating the Report Page Page Page 5.3.3 Controls Available by Report Page Page 5.3.4 Report Selection 5.3.4.1 Standard Report Types Page Page Page Page Page 5.3.4.2 Select Summary Columns 5.3.4.3 Compare 5.3.4.4 Select Peak 5.3.4.5 Group By Page Page 5.3.4.6 Order By Page 5.3.4.7 Low Bucket 5.3.4.8 High Bucket 5.3.4.9 Sum End Buckets 5.3.5Time Selection 5.3.5.1Reload After (mins) 5.3.5.2 Begin/At Time 5.3.5.3 End Time 5.3.5.4 Count 5.3.6 Object Selection 5.3.6.1 Select PDIDs 5.3.6.2 Include Chunklets 5.3.6.3 Select Cage IDs 5.3.6.4 Select Disk Types 5.3.6.5 Select Disk Speed 5.3.6.6Include PDs in States 5.3.6.7 Select Usr CPGs 5.3.6.8 Select Snp CPGs 5.3.6.9 Select CPGs 5.3.6.10 Select LDs 5.3.6.11 Select RAID Types 5.3.6.12 Select LD Usage 5.3.6.13 Select VVs 5.3.6.14 Select Prov Types 5.3.6.15 Select VV Types 5.3.6.16Select Ports (n:s:p) 5.3.6.17 Select Port Types 5.3.6.18 Select Hosts 5.3.6.19 Select Nodes 5.3.6.20 Select To Nodes 5.3.6.21 Select Queues 5.3.7 Format Selection (Web interface only) 5.3.7.1 Report Information 5.3.7.2 Chart Types Page Page Page 5.3.7.3 Chart X Pixels 5.3.7.4 Chart Y Pixels 5.3.7.5 Time Labels 5.3.7.6 Legend Position 5.3.7.7 Time Format 5.3.7.8 Select Space Unit 5.4 Working with Excel Charts 5.4.1 Choosing a Chart Type 5.4.2 Refreshing Charts Page 5.4.3Retaining Charts 5.4.4Exporting Executable Reports 5.4.5Customizing Excel Reports 5.4.5.1 Adding Custom Columns to a Data Sheet 5.4.5.2 Creating a Custom Chart Page 5.4.5.3 Saving Customized Settings Interpreting Report Metrics 6.1 Summary Report Page Page Page Page 6.2 Space Reports 6.2.1 PD Space Reports 6.2.2 LD Space Reports 6.2.3 VV Space Reports Page Page 6.3 Performance Reports 6.3.1 Common Performance Metrics Page 6.3.2 VV Cache Performance Reports 6.3.3 Node Cache Performance Reports 6.3.4 CPU Performance Reports 6.3.5 Link Performance Reports 6.4 Adaptive Optimization Reports 7.1 Accessing the System Reporter Policies 7.2 Configuring Sampling Policies 7.2.1 Compacting Databases 7.2.2 Editing Sampling Policies Page 7.3Adding, Removing and Re-ConfiguringInServ Storage Systems 7.3.1Adding a Storage Server 7.3.2 Verifying Addition of a Storage Server 7.3.3 Removing a Storage Server 7.3.4 Re-Configuringa Storage Server Sampling 7.4 Configuring Rules for Email Alerts 7.4.1 Adding an Alert Rule 7.4.2Changing an Alert Rule 7.4.3Removing an Alert Rule 7.4.4Alert Rule Parameters 7.4.4.1 Data Table 7.4.4.2 Resolution 7.4.4.3 System 7.4.4.4 Metric Page Page 7.4.4.5 Direction 7.4.4.6 Limit Value 7.4.4.7 Limit Count 7.4.4.8 Condition 7.4.4.9 Condition Value 7.4.5 Example of an Alert Rule 7.5 Scheduling Reports 7.5.1 Adding a Scheduled Report 7.5.2 Changing a Scheduled Report 7.5.3 Removing a Scheduled Report 7.6 Configuring Adaptive Optimization 7.7 About File Permissions 7.8 Modifying the Apache HTTP Server Configuration Files Page Web Queries 8.1 About Web Queries 8.2 Data Format Version Report Page 8.3 About Reports and Options 8.4 Report Options 8.4.1 category 8.4.1.1 example: 8.4.2 compare 8.4.2.1 values: Page 8.4.2.2 example: 8.4.3 comparesel 8.4.3.1 values: 8.4.4 table 8.4.4.1 values: 8.4.4.2 example: 8.4.5 refresh 8.4.5.1 values: 8.4.5.2 example: 8.4.6 charttab 8.4.6.1 values: 8.4.7 charttype 8.4.7.1 values: 8.4.7.2 example: 8.4.8 graphx 8.4.8.1 value: 8.4.8.2 example: 8.4.9 graphy 8.4.9.1 value: 8.4.10 graphlegpos 8.4.10.1 value: 8.4.10.2 example: 8.4.11 tableformat 8.4.11.1 value: 8.4.12 alllabels 8.4.12.1 values: 8.4.12.2 example: 8.4.13 timeform 8.4.13.1 values: 8.4.13.2 example: 8.4.14 begintsecs 8.4.14.1 value: 8.4.15 endtsecs 8.4.15.1 value: 8.4.15.2 example: 8.4.16 groupby 8.4.16.1 values: Page 8.4.16.2 example: 8.4.17 orderby 8.4.17.1 values: Page Page Page 8.4.17.2 example: 8.4.18 histbegin 8.4.18.1 values: 8.4.18.2 example: 8.4.19 ldspaceunit 8.4.19.1 values: 8.4.20 pdspaceunit 8.4.20.1 values: 8.4.20.2 examples: 8.4.21 vvspaceunit 8.4.21.1 values: 8.4.21.2 examples: 8.4.22 selcageid 8.4.22.1 value: 8.4.22.2 examples: 8.4.23 selchunks 8.4.23.1 values: 8.4.23.2 example: 8.4.24 selcpg 8.4.24.1 value: 8.4.24.2 example: 8.4.25 selusrcpg 8.4.26 selsnpcpg 8.4.28 seldiskspeed 8.4.28.1 value: 8.4.28.2 example: 8.4.29 seldomain 8.4.29.1 value: 8.4.29.2 example: 8.4.30 selhost 8.4.30.1 value: 8.4.30.2 example: 8.4.31 selld 8.4.31.1 value: 8.4.31.2 example: 8.4.32 sellduse 8.4.32.1 values: 8.4.33 selnode 8.4.33.1 value: 8.4.33.2 example: 8.4.34 selnsp 8.4.34.1 value: 8.4.34.2 example: 8.4.35 selpdid 8.4.35.1 value: 8.4.35.2 example: 8.4.36 selpdstate 8.4.36.1 values: 8.4.36.2 example: 8.4.37 selporttype 8.4.37.1 values: 8.4.38 selraidtype 8.4.38.1 values: 8.4.38.2 example: 8.4.39 selsys 8.4.39.1 values: 8.4.39.2 example: 8.4.40 selvv 8.4.40.1 values: 8.4.40.2 example: 8.4.41 selvvtype 8.4.41.1 values: 8.4.42 selprovtype 8.4.42.1 values: 8.5 Report Types 8.6Summary Report 8.6.1 summary 8.6.1.1 example: 8.7 Space Reports 8.7.1 pd_space_time 8.7.3 ld_space_time 8.7.3.1 example: 8.7.4 ld_space_group 8.7.4.1 example: 8.7.5 vv_space_time 8.8 Performance Reports 8.8.1pd_perf_time 8.8.1.1 example: 8.8.2 pd_perf_group 8.8.2.1 example: 8.8.3 pd_svt_hist 8.8.3.1 example: 8.8.4 pd_svt_histvstime 8.8.4.1 example: 8.8.5 port_perf_time 8.8.5.1 example: 8.8.6 port_perf_group 8.8.7 port_svt_hist 8.8.7.1 example: 8.8.8 port_svt_histvstime 8.8.8.1 example: 8.8.9 ld_perf_time 8.8.10 ld_perf_group 8.8.10.1 example: 8.8.11 ld_svt_hist 8.8.11.1 example: 8.8.12 ld_svt_histvstime 8.8.13 vlun_perf_time 8.8.13.1 example: 8.8.14 vlun_perf_group 8.8.14.1 example: 8.8.15 vlun_svt_hist 8.8.16 vlun_svt_histvstime 8.8.16.1 example: 8.8.17 vv_cmp_time 8.8.17.1 example: 8.8.18 vv_cmp_group 8.8.19 cpu_perf_time 8.8.19.1 example: 8.8.20 cpu_perf_group 8.8.20.1 example: 8.9 Adaptive Optimization Reports 8.9.1 regiodensity 8.9.1.1 regiondensity example 8.9.2 regmoves 8.9.2.1 regmoves example 8.10 Options Available by Report Page Page Page Page 8.11 Objects Present Reports Page Page Page 8.11.1 objectpres= cageid 8.11.1.1 example: 8.11.1.2 output: 8.11.2 objectpres= cpg_name 8.11.2.1 example: 8.11.2.2 output: 8.11.3 objectpres= diskspeed 8.11.3.1 example: 8.11.3.2 output: 8.11.4objectpres= disktype 8.11.4.1 example: 8.11.4.2 output: 8.11.5 objectpres= domain_name 8.11.5.1 example: 8.11.5.2 output: 8.11.6objectpres= host_name 8.11.6.1 example: 8.11.7 objectpres= ld_name 8.11.7.1 example: 8.11.7.2 output: 8.11.8 objectpres=node 8.11.8.1 example: 8.11.8.2 output: 8.11.9 objectpres=pdid 8.11.9.1 example: 8.11.9.2 output: 8.11.10 objectpres=port 8.11.10.1 example: 8.11.10.2 output: 8.11.11 objectpres= system 8.11.11.1 example: 8.11.11.2 output: 8.11.12 objectpres= vv_name 8.11.12.1 example: 8.11.12.2 output: 8.11.13 objectpres= vv_name_nosnap 8.11.13.1 example: 8.11.13.2 output: 8.11.14 objecctpres= porttype 8.11.14.1 example: 8.11.14.2 output: 8.11.15 sample_times 8.11.15.1 example: 8.11.15.2 output: Page Page Using Adaptive Optimization 9.1 Overview Page 9.2 Selecting an InServ for Adaptive Optimization 9.3 Configuring Adaptive Optimization Page 9.3.1Tier Definition (CPG Name and GiB) Page Page 9.3.2 Schedule 9.3.3 Measurement Hours 9.3.4 Adaptive Optimization Mode 9.3.5 Adaptive Optimization Active 9.3.6 Adding an Adaptive Optimization Configuration 9.3.7 Changing an Adaptive Optimization Configuration 9.3.8 Removing an Adaptive Optimization Configuration 9.4 Adaptive Optimization Reports 9.4.1 Region IO Density Report Page Page 9.4.2 VV Tiers Report 9.4.3 Adaptive Optimization Space Moved Report 9.5 The showvvcpg CLI extension Page Page Database Schema 10.1 Using The Database Schema 10.2 Table Versions and Naming Conventions 10.3 Administrative Tables 10.3.1 The policy Table 10.3.2 The sampleinserv Table 10.3.3 The system Table 10.3.4 The alertconfig Table Page 10.3.5 The scheduled_report Table Page 10.3.6 The scheduled_report_log Table 10.3.7 The adprovconfig Table Page 10.3.8 The adprov_log Table 10.3.9 The ldrgmoves Table Page 10.3.10 The recentsample Table 10.4 The Sample Data and Inventory Tables 10.4.1 The pdspace Table Page Page 10.4.2 The pdspaceinv Table 10.4.3 The ldspace Table Page 10.4.4 The ldspaceinv Table 10.4.5 The vvspace Table Page Page 10.4.6 The vvspaceinv Table Page 10.4.7 The cpgspace Table Page 10.4.8 The cpgspaceinv Table 10.4.9 Common Performance Table Columns Page Page Page Page 10.4.9.1 Calculating Common Performance Metrics 10.4.9.2 Service Time Histogram Buckets 10.4.9.3 IO Size Histogram Buckets 10.4.10 The statpd Table Page 10.4.11 The statpdinv Table 10.4.12 The statld Table 10.4.13 The statldinv Table 10.4.14 The statport Table 10.4.15 The statportinv Table Page 10.4.16 The statvlun Table 10.4.17 The statvluninv Table 10.4.18 The statvvcmp Table Page 10.4.19 The statvvcmpinv Table 10.4.20 The statcpu Table Page 10.4.21 The statcpuinv Table 10.4.22 The statlink Table Page 10.4.23 The statlinkinv Table 10.4.24 The statldrg Table 10.4.25 The statldrg_timeinv Table 10.4.26 The perf_timeinv Table 10.4.27 The space_timeinv Table Page 11 Troubleshooting 11.1 Troubleshooting Overview 11.2 Troubleshooting the Sampling Components 11.2.1 Sampling Component Log Files 11.2.2 Installation Configuration 11.2.3 InServ Sampling Errors 11.2.3.1 Errors incurred by the inservsample process 11.2.3.2 Errors incurred by the CLI sampler process 11.2.4 Sampler Service/Daemon Errors 11.3 Troubleshooting Adaptive Optimization Components 11.4 Troubleshooting the Web Server Components 11.5 Troubleshooting the Excel Client 11.6 Extracting Data from the Database with sysbck Page 11.6.1 Examples of Using sysbck for Various Databases Page Page Page 11.7 Dumping the Entire Database 11.7.1 Dumping the Entire SQLite Database 11.7.2 Dumping the Entire MySQL Database Page Index IX.2 Index Page IX.4 Index Page IX.6 Index Revision History RH.1 RH.2 RH.3 RH.4 RH.5 RH.6 RH.7 RH.8