InfoScale™ 9.0 SmartIO for Solid-State Drives Solutions Guide - Solaris

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Solaris
  1. Introducing SFHA Solutions SmartIO
    1.  
      About SmartIO for solid-state drives
    2.  
      About SmartIO in an SFHA environment
    3.  
      About SmartIO in an Active/Active cluster environment
    4. About SmartIO in the Solaris virtualized environments
      1.  
        Performing live migration between LDOMs in the SmartIO environment
    5.  
      About the SmartIO caching profiler tool
  2. Using the SmartIO feature: use cases
    1. About SmartIO read caching for applications running on VxVM volumes
      1.  
        Required configuration for SmartIO read caching for VxVM volumes
      2.  
        Automatic caching for VxVM volumes
      3.  
        Setting up SmartIO read caching for VxVM volumes
      4.  
        Verifying the VxVM cache area and monitoring the caching
    2. About SmartIO read caching for applications running on VxFS file systems
      1.  
        Required configuration for SmartIO read caching for a VxFS file system
      2.  
        Automatic caching for VxFS file systems
      3.  
        Setting up SmartIO read caching for VxFS file systems
      4.  
        Verifying the VxFS cache area and monitoring the caching
      5.  
        Customizing the caching behavior
    3. About SmartIO caching on SSD devices exported by FSS
      1.  
        Status of cache areas when nodes leave or join the cluster
      2.  
        Setting up cache areas using SSDs exported by FSS
    4. About SmartIO write-back caching for applications running on VxFS file systems
      1.  
        Required configuration for SmartIO write-back caching for a VxFS file system
      2.  
        Setting up SmartIO write-back caching for VxFS file systems
      3.  
        Verifying the VxFS cache area and monitoring the caching (writeback mode)
    5. About multiple SmartIO cache areas for read and write-back caching on VxFS file systems
      1.  
        About the smartiocache option
      2.  
        Converting VxFS cache areas from one type to another
      3.  
        Setting up multiple cache areas on a system
      4.  
        Verifying the VxFS cache areas
    6. About SmartIO caching for Oracle databases on VxFS file systems
      1.  
        Prerequisites and configuration for using the SmartIO plug-in for Oracle
      2.  
        Setting default SmartIO caching policies for a database running on a VxFS file system
      3.  
        Setting SmartIO caching policies for database objects
      4.  
        Pinning and unpinning database objects
      5.  
        Enabling and disabling caching for the database
      6.  
        Listing cache policy details for the database
      7.  
        Listing cache statistics for the database
    7. About SmartIO caching for databases on VxVM volumes
      1.  
        Applying a SmartIO database caching template for a VxVM volume
  3. Administering SmartIO
    1.  
      Creating a cache area
    2.  
      Displaying information about a cache area
    3. Enabling or disabling caching for a data object
      1.  
        Enabling or disabling caching for a file system
      2.  
        Enabling or disabling caching for a data volume
    4.  
      Adding a device to the cache area
    5.  
      Pausing caching from a volume to a cache area
    6.  
      Removing a device from the cache area
    7.  
      Destroying a cache area
    8.  
      Setting the attributes of the VxVM cache area
    9.  
      Setting or changing the caching mode for a VxFS cache area
    10.  
      Flushing dirty data from a writeback cache area
    11.  
      Tuning the writeback caching
    12. Viewing the SmartIO cache statistics
      1.  
        Viewing the detailed caching stats for a VxVM cache area
      2.  
        Viewing the detailed caching stats for a VxFS cache area
  4. Troubleshooting and error handling
    1. Support for a persistent or 'warm' VxVM cache
      1.  
        Primary volume failure with a stale cache could cause possible data corruption
      2.  
        Migrating a cache during HA failover is not supported
    2.  
      Cache area is lost after a disk failure (3158482)
    3.  
      Cache is not online after a reboot
    4.  
      Recovering the write-back cache after a node failure
  5. Appendix A. Command reference
    1.  
      SmartIO command reference

Setting default SmartIO caching policies for a database running on a VxFS file system

SmartIO provides application templates to optimize caching for databases running on VxFS file systems. SmartIO uses the templates to apply policies to particular types of files in the database. For example, caching policies for index files and data files.

The oracle template sets the default policy for the Oracle database, as follows:

  • Turns off caching (nocache mode) for ARCHLOG files

  • Sets read caching (read mode) for TEMPFILEs

  • For OLTP database, sets read caching to the datafiles with the most frequent reads.

    For OLAP database, sets read caching to all datafiles that contain INDEXes.

To set the default SmartIO caching policies for a database, run the following command as ORACLE user:

# sfcache app [cachearea=cachearea_name] oracle -S $ORACLE_SID \
   -H $ORACLE_HOME -o setdefaults --type={OLTP | OLAP}

Where:

$ORACLE_HOME and $ORACLE_SID are mandatory and uniquely identify the database.

OLAP or OLTP indicates the type of application load. OLAP, or Online Analytical Processing, applications process workloads intended for multi-dimensional analytical queries. OLTP, or Online Transaction Processing, applications process transaction-oriented workloads, such as for data entry and retrieval transaction processing.

Example of an OLTP database:

$ sfcache app cachearea=sfcachearea_1 oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o setdefaults --type=oltp

INFO: Oracle Instance tpcc is running
INFO: Store DB details at /tpccdata/.CACHE_INFO
INFO: Setting oltp policies
INFO: Setting nocache mode to /tpccdata

INFO: Setting nocache mode to /tpcclog

INFO: Setting nocache mode to /tpcclog/log_1_1
INFO: Setting nocache mode to /tpcclog/log_1_2
INFO: Setting nocache mode to /tpcclog/log_1_3
INFO: Setting nocache mode to /tpcclog/log_1_4

INFO: Setting nocache mode to /home/oracle/app/oracle/product/11.2.0
/dbhome_1/dbs/arch
INFO: Setting read mode to /tpccdata/temp_0_0
INFO: Setting read mode to /tpccdata/temp_0_2
INFO: Setting read mode to /tpccdata/temp_0_1
INFO: Setting read mode to /tpccdata/temp_0_4

AWR snapid range min=1 max=7

INFO: Setting read mode to /tpccdata/stok_0_25
INFO: Setting read mode to /tpccdata/stok_0_24
INFO: Setting read mode to /tpccdata/stok_0_20
INFO: Setting read mode to /tpccdata/stok_0_29
INFO: Setting read mode to /tpccdata/stok_0_23
INFO: Setting read mode to /tpccdata/stok_0_22
INFO: Setting read mode to /tpccdata/cust_0_5

Example of an OLAP database:

$ sfcache app cachearea=sfcachearea_1 oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o setdefaults --type=olap
INFO: Oracle Instance tpcc is running
INFO: Store DB details at /tpccdata/.CACHE_INFO
INFO: Setting olap policies
INFO: Setting nocache mode to /tpccdata

INFO: Setting nocache mode to /tpcclog

INFO: Setting nocache mode to /tpcclog/log_1_1
INFO: Setting nocache mode to /tpcclog/log_1_2
INFO: Setting nocache mode to /tpcclog/log_1_3
INFO: Setting nocache mode to /tpcclog/log_1_4

INFO: Setting nocache mode to /home/oracle/app/oracle/product/11.2.0
/dbhome_1/dbs/arch
INFO: Setting read mode to /tpccdata/temp_0_0
INFO: Setting read mode to /tpccdata/temp_0_2
INFO: Setting read mode to /tpccdata/temp_0_1
INFO: Setting read mode to /tpccdata/temp_0_4

INFO: Setting read mode to /tpccdata/icust2_0_30
INFO: Setting read mode to /tpccdata/ordr_0_32
INFO: Setting read mode to /tpccdata/iordr2_0_44
INFO: Setting read mode to /tpccdata/iordr2_0_29
INFO: Setting read mode to /tpccdata/iordr2_0_47
INFO: Setting read mode to /tpccdata/icust2_0_49
INFO: Setting read mode to /tpccdata/icust1_0_2
INFO: Setting read mode to /tpccdata/istok_0_1
INFO: Setting read mode to /tpccdata/ordr_0_33
INFO: Setting read mode to /tpccdata/ordr_0_37
INFO: Setting read mode to /tpccdata/iordr2_0_37