HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 31
Microsoft SQL, MySQL, Oracle, Compacting, Databases Table 5
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 31 highlights
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 Comment Included with System Reporter? Sample more than one HP 3PAR StoreServ Storage? Supports Adaptive Optimization? Can have remote database server? SQLite Yes No No No Microsoft SQL No Yes Yes Yes MySQL No Yes Yes Yes Oracle No Yes Yes Yes Installing the Database Server 31