Storage for Analytics Database Configuration | Teradata VantageCore | EDW - Storage for Analytics Database Configuration - Teradata VantageCore VMware

Teradata® VantageCore powered by Dell Technologies - Enterprise Data Warehouse

Deployment
VantageCore
Edition
VMware
Product
Teradata VantageCore VMware
Published
April 2024
Language
English (United States)
Last Update
2024-04-24
dita:mapPath
csc1707954420061.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
csc1707954420061
Product Category
Cloud
The Dell PowerVault ME5 block storage array used by the Analytics Database was chosen based on its functional, performance, and availability attributes for use with the Teradata MPP architecture. The following high-level criteria were applied to the block storage solution:
  • Aligned to EDW storage model
  • Shared Storage, supporting connectivity for up to nine hosts (eight Active + one Hot Standby)
  • Fault-Tolerant through fully redundant storage subsystem components
  • Support for SCSI-3 command set, including persistent reservations
  • Sufficient READ & WRITE I/O throughput
  • Predictable I/O latency
  • Attractive cost/performance and cost/capacity economics
The Analytics Database uses the Dell PowerVault ME5 storage arrays with the following configuration:
  • Single 2U-24 PowerVault ME5024 storage enclosure per Array, each with the following:
    • Dual or redundant RAID controllers
    • Dual or redundant power supplies and fans
    • Within the ME5024: Twenty-two 3.84TB 3-DWPD or Twenty-two 7.68TB 1-DWPD SSDs (20 SSDs for RAID-1, plus 2 Hot Spare)
    • Four (of eight) 25GbE iSCSI ports connected to two 25GbE redundant fabrics
    • Two 1GbE management ports connected to both of the TOR management switches

PowerVault ME5024 RAID Array (Rear View)



PowerVault ME5024 RAID Array (front view)



  • Exactly (20) 3.84TB or 7.68TB SSDs per array to be used for database storage.
  • Exactly (2) Dynamic / Hot Spare SSD per array
  • Pool and Volume provisioning constructed in SSD drive pairs, from left to right, as outlined in the following image:


  • Controller ownership of pools is defined as follows:
    # show pools
    Name     Class   Blocksize Total Size   Avail   Disk Groups Volumes  Sec Fmt  Health
    
    dg01	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg02	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg03	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg04	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg05	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg06	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg07	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg08	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg09	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
    dg10	Linear   512       3836.7GB	36.7GB	     1	        1	512e	OK
  • Each volume constructed within each pool is configured as follows:
    • *size:
      3836 GB (if using 3.8TB 3-DWPD SSDs)
      7675 GB (if using 7.7TB 1-DWPD SSDs)
    • allocation: linear
    • *write policy: write-through*
    • cache optimization: standard-atomic-write
    • read ahead: adaptive
    • tier-affinity: no-affinity
    Items with "*" are different from the storage array default.
  • A single host group that includes the iSCSI initiator (iqn) for all Analytics Database VMs in the clique, with a Linux operating system.
  • Each volume mapped to all hosts in the clique are as follows:
    • The LUNs mapped to two ports on each controller (a0,a2,b0,b2)
    • The LUNs associated with the previously created host group, which has all the initiators of all VMs included.
  • The storage array is configured with the following advanced settings:
    Rec# show advanced settings
    Disk Group Background Scrub: Enabled
    *Disk Group Background Scrub Interval: 168* 
    Partner Firmware Upgrade: Enabled
    *Utility Priority: High* SMART: Enabled
    *Dynamic Spare Configuration: Enabled* 
    Enclosure Polling Rate: 5
    Host Control of Caching: Disabled 
    Sync Cache Mode: Immediate
    Missing LUN Response: Illegal Request
    *Controller Failure: Enabled* 
    Supercap Failure: Enabled 
    CompactFlash Failure: Enabled 
    Power Supply Failure: Disabled 
    Fan Failure: Disabled 
    Temperature Exceeded: Disabled 
    Partner Notify: Enabled
    Auto Write Back: Enabled
    Inactive Drive Spin Down: Disabled 
    Inactive Drive Spin Down Delay: 15
    
    Disk Background Scrub: Disabled 
    Managed Logs: Disabled
    Single Controller Mode: Disabled 
    Auto Stall Recovery: Enabled 
    Restart on CAPI Fail: Enabled 
    Large Pools: Disabled
    Items with "*" are different from the storage array default.