HP 3PAR StoreServ 7000 Storage - Manual (Page 31)

the sampler or the Web server can time out. Furthermore, database compaction (see “Compacting
Databases” (page 114) ) cannot be done in parallel with sample insertion so there could be a large
gap in samples during database compaction.
Sampling of multiple HP 3PAR StoreServ Storage systems is not supported with an SQLite database,
either the Microsoft SQL Server, MySQL or the Oracle database servers should be used instead.
For large databases (over about 1 GB) or a large number of concurrent Web users, either the
MySQL, Microsoft SQL, or the Oracle database servers should be used instead.
NOTE: The optionally licensed Adaptive Optimization feature is not supported with the SQLite
database. Please consider another database if you plan on utilizing the storage optimization
capabilities provided by Adaptive Optimization.
Microsoft SQL
System Reporter supports Microsoft SQL version 2008 R2 database server but it is not included
and must be purchased separately. The Microsoft SQL server is not supported on Linux and does
not support data generated by System Reporter when installed on a Linux platform.
MySQL
A MySQL database server can be used with System reporter but is not included with it. You must
purchase it separately. MySQL is a good choice for System reporter because it supports MyISAM
tables. These tables do not support transactions (which are not required for System Reporter) and
are consequently somewhat higher performance than Oracle for sample insertion and deletion.
Oracle
System Reporter supports an Oracle 11g database server but it is not included with it. You must
purchase it separately. Compared with MySQL, Oracle is slightly slower and more resource
intensive for sample insertion and deletion. However, Oracle is also a good choice for large and
active System Reporter installation.
The Oracle database will have to be modified, with many insertions and deletions. Ideally, multiple
(small) file UNDO space and multiple (small) file tablespace is required for the data, resulting in
a size of approximately 100-200 MB, depending on the size of the HP 3PAR OS.
NOTE: System Reporter does not currently support Oracle RAC implementations.
NOTE: System Reporter requires the 32-bit Oracle client and does not support the 64-bit version.
NOTE: If you choose Oracle as the database, you cannot install System Reporter on a 64-bit
Linux system since it requires a 32-bit Oracle client which is not supported on 64-bit Linux. This
limitation does not apply to the 64-bit Windows version since the 32-bit Windows version of Oracle
Client works on 64-bit Windows platforms.
Table 5 (page 31) provides a comparison of features for the various database choices.
Table 5 Database Comparison
Oracle MySQL Microsoft SQL SQLite Comment
No No No Yes Included with System
Reporter?
Yes Yes Yes No Sample more than one
HP 3PAR StoreServ
Storage?
Yes Yes Yes No Supports Adaptive
Optimization?
Yes Yes Yes No Can have remote
database server?
Installing the Database Server 31