• Deployment Guide
• 1. In This Guide
•  2. System Sizing
  • Installation Options
  •  Determine the Core Count
    • Hyper-threading
  •  How Much Memory Do I Need?
    • Sizing Execution Memory
    • Sizing the Column Buffer Manager (CBM) Memory
    • Operating System Considerations
  •  Sizing Disk Storage
    • I/O Performance Requirement
    • Spinning Disks
    • Solid State Drives (SSDs)
    • RAID Configuration
    • Storage Requirement
    • File System
•  3. Database Configuration
  • Database Configuration Overview
  •  Access to Data
    • Large Block I/O
    • Data Allocation
    • Column Buffer Manager (CBM) Memory
  • Storage Allocation
•  4. Schema Design
  • Schema Design Flexibility
  • Indexing
  • Constraints
•  5. Data Loading
  • Typical Data Loading Practices
  •  Initial Data Load
    • vwload Utility
    • COPY VWLOAD Statement
    • COPY Statement
    • SparkSQL
    • INSERT...SELECT
    • Batch Inserts
    • Third-party Tools
  •  Incremental Data Load
    • MODIFY...TO COMBINE Statement
    • DML and Memory Utilization
    • Constraints
    • Moving Window of Data
•  6. High Availability
  • Planned and Unplanned Outages
  • Hardware Protection
  •  Backup and Restore
    • Database Backup Utilities (ckpdb and rollforwarddb)
    • Full Operating System Database Backup
    • copydb/unloaddb Database Backup
    • Partial Database Backup
    • Database Reload
    • Hybrid Approach: Full Backup with Incremental Reload
  • Standby Configuration
  • Active-Passive Failover with Red Hat Cluster Suite

Actian Vector 5.0

Active-Passive Failover with Red Hat Cluster Suite