> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://ocient.ferndocs.com/guides/system-administration/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server. # System Administration ## Docs - [System Administration](https://ocient.ferndocs.com/guides/system-administration/system-administration.md): This page provides guidance on installing and maintaining the Ocient System, covering hardware/software requirements and ongoing maintenance tasks. It includes tutorials for installation, managing system performance, monitoring, and system configuration. - [Air-Gapped Environment with an Ocient System](https://ocient.ferndocs.com/guides/system-administration/air-gapped-environment-with-an-ocient-system.md): An air gap is a security measure that physically isolates a computer or network from all external connections to protect sensitive data used by governments and other critical infrastructure operators. Ocient supports this without special configuration. - [Amazon Web Services Ocient Installation](https://ocient.ferndocs.com/guides/system-administration/amazon-web-services-ocient-installation.md): Set up an Ocient system on AWS, utilizing cloud infrastructure for scalable and efficient data warehousing. - [Configure Storage Spaces](https://ocient.ferndocs.com/guides/system-administration/configure-storage-spaces.md) - [Install an Ocient System](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system.md): Follow this guide to install an Ocient system, covering the setup steps needed for deploying high-performance data warehousing. - [Maintenance Overview](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview.md): Learn about regular maintenance procedures for Ocient, ensuring system stability and longevity. - [Multiple Storage Clusters for Loading Data](https://ocient.ferndocs.com/guides/system-administration/multiple-storage-clusters-for-loading-data.md): Set up multiple storage clusters for efficient data loading in Ocient, enabling high-speed data handling. - [Ocient Software Upgrade](https://ocient.ferndocs.com/guides/system-administration/ocient-software-upgrade.md): Follow best practices for upgrading Ocient software, ensuring minimal disruption and maximum performance. - [Secure Connections Using TLS](https://ocient.ferndocs.com/guides/system-administration/secure-connections-using-tls.md): Implement TLS for secure connections in Ocient, safeguarding data from unauthorized access. - [Installation Reference](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference.md): Access a detailed reference for installing Ocient, covering all necessary configurations and setup options. - [Ocient Application Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-application-configuration.md): Configure the Ocient application for optimized performance, with settings tailored to your specific data and operational needs. - [Ocient Application Installation](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-application-installation.md): Learn about installing the Ocient application, ensuring a smooth deployment for high-speed data processing. - [Ocient System Bootstrapping](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-system-bootstrapping.md): Discover the steps required to bootstrap an Ocient system, ensuring it is correctly initialized for large-scale data handling. - [Checking System After Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/checking-system-after-configuration.md): Verify your system setup post-configuration to confirm that Ocient operates correctly and meets performance benchmarks. - [Checking System Configuration Before Bootstrapping](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/checking-system-configuration-before-bootstrapping.md): Ensure your system is configured correctly before bootstrapping Ocient, reducing errors and enhancing stability. - [Node Bootstrapping Reference](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/node-bootstrapping-reference.md): Access reference documentation for bootstrapping individual nodes in an Ocient system, optimizing for scalability and reliability. - [Ocient System Hardware Specifications](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-hardware-specifications.md): The Ocient System can run on Ocient-branded hardware or suitable generic hardware. It consists of Foundation Nodes, Loader Nodes, and SQL Nodes, each with specific components and performance specs. - [Ocient System Requirements](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-requirements.md): Review the hardware and software requirements needed to run an Ocient system, ensuring compatibility and performance. - [Ocient System Sizing](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-sizing.md): To size your Ocient System for data and query needs, gather the uncompressed size of your data and consider its format and compression. Calculate data loading rates, transformation levels, and query types. - [Operating System Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/operating-system-configuration.md): Learn about configuring your operating system to optimize performance and compatibility with Ocient. - [Alter Default Data Pipeline Behavior](https://ocient.ferndocs.com/guides/system-administration/loading-administration/alter-default-data-pipeline-behavior.md): Data Administrators for an Ocient System can configure parameters using the `ALTER SYSTEM ALTER CONFIG` SQL command to adjust pipeline behavior. Key parameters include execution time, partition counts, and type inference. - [Configuration Settings for Data Pipelines](https://ocient.ferndocs.com/guides/system-administration/loading-administration/configuration-settings-for-data-pipelines.md) - [Configure Data Pipeline Logging](https://ocient.ferndocs.com/guides/system-administration/loading-administration/configure-data-pipeline-logging.md): To troubleshoot Ocient data pipelines, log levels can be adjusted using SQL commands, impacting performance. Set the log level using `ALTER SYSTEM ALTER LOG LEVEL SET`, then configure specific logging parameters. - [Backup and Restore](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/backup-and-restore.md): Discover Ocient backup and restore methods to secure your data and facilitate disaster recovery. - [Expand and Rebalance System](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/expand-and-rebalance-system.md): Discover how to expand and rebalance an Ocient system to accommodate growing data demands while maintaining performance. - [Guide to Rebuilding Segments](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/guide-to-rebuilding-segments.md): Discover methods for rebuilding segments in Ocient, maintaining data integrity and system performance. - [Power Safety Recommendations](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/power-safety-recommendations.md): Follow Ocient power safety guidelines to protect your system from data loss and damage due to power fluctuation. - [Replace Nodes](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/replace-nodes.md): Learn the procedure for replacing nodes in an Ocient system, ensuring minimal disruption and optimal system performance. - [Startup and Shutdown Procedure](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/startup-and-shutdown-procedure.md): Learn the proper steps for starting and shutting down an Ocient system, safeguarding data and operational integrity. - [NVMe Drive Firmware Upgrade Process](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/nv-me-drive-maintenance/nv-me-drive-firmware-upgrade-process.md): Upgrade NVMe drive firmware in Ocient, enhancing system stability and performance. - [Replace an NVMe Node Drive](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/nv-me-drive-maintenance/replace-an-nv-me-node-drive.md): Learn the procedure for replacing NVMe drives in an Ocient node, ensuring data redundancy and fault tolerance. - [Log Monitoring](https://ocient.ferndocs.com/guides/system-administration/monitoring/log-monitoring.md): Understand how to monitor errors in Ocient to maintain system health and prevent issues. - [Monitor Segment Group Transfers](https://ocient.ferndocs.com/guides/system-administration/monitoring/monitor-segment-group-transfers.md): Learn to monitor segment group transfers in Ocient, ensuring data is transferred efficiently and accurately. - [Set Up System Monitoring with the TIG Stack and Kapacitor](https://ocient.ferndocs.com/guides/system-administration/monitoring/set-up-system-monitoring-with-the-tig-stack-and-kapacitor.md): Set up system monitoring in Ocient using the TIG stack and Kapacitor, providing comprehensive insights into system performance. - [Statistics Monitoring](https://ocient.ferndocs.com/guides/system-administration/monitoring/statistics-monitoring.md): Track and analyze key performance metrics within Ocient to ensure optimal database operation. - [System Information REST Endpoints](https://ocient.ferndocs.com/guides/system-administration/monitoring/system-information-rest-endpoints.md): Access system information in Ocient through REST endpoints, ideal for monitoring and automation. - [Inspect the Current Configuration](https://ocient.ferndocs.com/guides/system-administration/system-configuration/inspect-the-current-configuration.md): Review and verify the configuration of your Ocient system for optimal operation and performance. - [Manage the Network Configuration of an Ocient System](https://ocient.ferndocs.com/guides/system-administration/system-configuration/manage-the-network-configuration-of-an-ocient-system.md): Configure network settings for your Ocient system, optimizing for connectivity and performance. - [Node Configuration with the Administrator Role](https://ocient.ferndocs.com/guides/system-administration/system-configuration/node-configuration-with-the-administrator-role.md): Understand the key design considerations for deploying Ocient, ensuring scalability and efficiency.