# Managing ColumnStore - [Deployment](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment.md) - [Installing ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide.md): This section provides instructions for installing and configuring MariaDB ColumnStore. It covers various deployment scenarios, including single- and multi-node setups with both local and S3 storage. - [Single-Node Localstorage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage.md): This guide provides steps for deploying a single-node ColumnStore, setting up the environment, installing the software, and bulk importing data for online analytical processing (OLAP) workloads. - [Step 1: Prepare Systems for Enterprise ColumnStore Nodes](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-1-prepare-systems-for-enterprise-columnstore-nodes.md): Step 1: Prepare Systems for Enterprise ColumnStore Nodes - [Step 2: Install Enterprise ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-2-install-enterprise-columnstore.md): Step 2: Install Enterprise ColumnStore - [Step 3: Start and Configure Enterprise ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-3-start-and-configure-enterprise-columnstore.md): Step 3: Start and Configure Enterprise ColumnStore - [Step 4: Test Enterprise ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-4-test-enterprise-columnstore.md) - [Step 5: Bulk Import of Data](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-5-bulk-import-of-data.md): Step 5: Bulk Import of Data - [Multi-Node Localstorage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage.md): This guide provides steps for deploying a multi-node ColumnStore, setting up the environment, installing the software, and bulk importing data for online analytical processing (OLAP) workloads. - [Step 1: Prepare ColumnStore Nodes](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-1-prepare-columnstore-nodes.md): Step 1: Prepare ColumnStore Nodes - [Step 2: Configure Shared Local Storage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-2-configure-shared-local-storage.md): Step 2: Configure Shared Local Storage - [Step 3: Install MariaDB Enterprise Server](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-3-install-mariadb-enterprise-server.md): Step 3: Install MariaDB Enterprise Server - [Step 4: Start and Configure MariaDB Enterprise Server](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-4-start-and-configure-mariadb-enterprise-server.md): Step 4: Start and Configure MariaDB Enterprise Server - [Step 5: Test MariaDB Enterprise Server](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-5-test-mariadb-enterprise-server.md): Step 5: Test MariaDB Enterprise Server - [Step 6: Install MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-6-install-mariadb-maxscale.md): Step 6: Install MariaDB MaxScale - [Step 7: Start and Configure MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-7-start-and-configure-mariadb-maxscale.md): Step 7: Start and Configure MariaDB MaxScale - [Step 8: Test MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-8-test-mariadb-maxscale.md): Step 8: Test MariaDB MaxScale - [Step 9: Import Data](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-9-import-data.md): Step 9: Import Data - [Single-Node S3](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3.md): This guide provides steps for deploying a single-node S3 ColumnStore, setting up the environment, installing the software, and bulk importing data for online analytical processing (OLAP) workloads. - [Step 1: Prepare ColumnStore Nodes](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-1-prepare-columnstore-nodes.md): Step 1: Prepare ColumnStore Nodes - [Step 2: Configure Shared Local Storage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-2-configure-shared-local-storage.md): Step 2: Configure Shared Local Storage - [Step 3: Install MariaDB Enterprise Server](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-3-install-mariadb-enterprise-server.md): Step 3: Install MariaDB Enterprise Server - [Step 4: Start and Configure MariaDB Enterprise Server](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-4-start-and-configure-mariadb-enterprise-server.md): Step 4: Start and Configure MariaDB Enterprise Server - [Step 5: Test MariaDB Enterprise Serverd](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-5-test-mariadb-enterprise-server.md): Step 5: Test MariaDB Enterprise Server - [Step 6: Install MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-6-install-mariadb-maxscale.md): Step 6: Install MariaDB MaxScale - [Step 7: Start and Configure MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-7-start-and-configure-mariadb-maxscale.md): Step 7: Start and Configure MariaDB MaxScale - [Step 8: Test MariaDB MaxScale](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-8-test-mariadb-maxscale.md): Step 8: Test MariaDB MaxScale - [Step 9: Import Data](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-9-import-data.md): Step 9: Import Data - [Multi-Node S3](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3.md): This guide provides steps for deploying a multi-node S3 ColumnStore, setting up the environment, installing the software, and bulk importing data for online analytical processing (OLAP) workloads. - [Upgrading ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades.md) - [Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades/upgrade-multi-node-mariadb-enterprise-columnstore-from-6-to-23.10.md) - [Major Release Upgrades for MariaDB Enterprise ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades/major-release-upgrades-for-mariadb-enterprise-columnstore.md) - [Managing ColumnStore Database Environment](https://mariadb.com/docs/analytics/mariadb-columnstore/management/managing-columnstore-database-environment.md): Managing MariaDB ColumnStore means deploying its architecture, scaling modules, and maintaining performance through monitoring, optimization, and backups. - [ColumnStore Partition Management](https://mariadb.com/docs/analytics/mariadb-columnstore/management/managing-columnstore-database-environment/columnstore-partition-management.md) - [Node Maintenance for MariaDB Enterprise Columnstore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore.md) - [Adding a Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/add-a-node.md): Adding a Node to MariaDB Enterprise ColumnStore - [Rejoining a Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/rejoin-a-node.md) - [Removing a Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/remove-a-node.md) - [Setting a Node to Maintenance Mode](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/set-a-node-to-maintenance-mode.md) - [Switchover of the Primary Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/switchover-primary-node.md) - [View and Clear Table Locks](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/view-clear-table-locks.md) - [ColumnStore System Variables](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system-variables.md) - [Backup & Restore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore.md): MariaDB ColumnStore backup and restore manage distributed data using snapshots or tools like mariadb-backup, with restoration ensuring cluster sync via cpimport or file system recovery. - [Backup and Restore Overview](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/backup-and-restore-with-mariadb-enterprise-columnstore.md) - [Backup and Restore with Object Storage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/mariadb-enterprise-columnstore-backup-and-restore-with-object-storage.md) - [Backup and Restore with Shared Local Storage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/mariadb-enterprise-columnstore-backup-and-restore-with-shared-local-storage.md) - [MCS backup and restore commands](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/mcs-backup-and-restore-commands.md) - [Extent Map Backup & Recovery](https://mariadb.com/docs/analytics/mariadb-columnstore/management/extent-map-backup-recovery.md) - [Upgrading MariaDB Enterprise ColumnStore (Alpha)](https://mariadb.com/docs/analytics/mariadb-columnstore/management/upgrades.md) - [ColumnStore and Recursive CTE Limitations](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-and-recursive-cte-limitations.md) - [ColumnStore Table Size Limitations](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-table-size-limitations.md) - [Optimizing Linux Kernel Parameters for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/optimizing-linux-kernel-parameters-for-mariadb-columnstore.md): This page provides information on optimizing Linux kernel parameters for improved performance with MariaDB ColumnStore. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/analytics/mariadb-columnstore/management.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.