
the sampler or the Web server can time out. Furthermore, database compaction (see “Compacting
Databases” (page 116)) 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 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 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 4 (page 31) provides a comparison of features for the various database choices.
Table 4 Database Comparison
OracleMySQLMicrosoft SQLSQLiteComment
NoNoNoYesIncluded with System
Reporter?
YesYesYesNoSample more than one
HP 3PAR StoreServ
Storage?
YesYesYesNoSupports Adaptive
Optimization?
YesYesYesNoCan have remote
database server?
Installing the Database Server 31
Comentários a estes Manuais