Microsoft sql, Mysql, Oracle – HP 3PAR System Reporter Software User Manual

Page 31: Microsoft sql mysql oracle

the sampler or the Web server can time out. Furthermore, database compaction (see

) 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

Oracle

MySQL

Microsoft SQL

SQLite

Comment

Yes

Included with System
Reporter?

Yes

Sample more than one
HP 3PAR StoreServ
Storage?

Yes

Supports Adaptive
Optimization?

Yes

Can have remote
database server?

Installing the Database Server