# Managing ColumnStore

- [Deployment](/docs/analytics/mariadb-columnstore/management/deployment.md)
- [Installing ColumnStore](/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](/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](/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](/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](/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](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-4-test-enterprise-columnstore.md)
- [Step 5: Bulk Import of Data](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multnode-localstorage/step-9-import-data.md): Step 9: Import Data
- [Single-Node S3](/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](/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](/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](/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](/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](/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](/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](/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](/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](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/single-node-s3/step-9-import-data.md): Step 9: Import Data
- [Multi-Node S3](/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.
- [Step 1: Prepare Systems for Enterprise ColumnStore Nodes](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-1-prepare-systems-for-enterprise-columnstore-nodes.md): Step 1: Prepare Systems for Enterprise ColumnStore Nodes
- [Step 2: Install Enterprise ColumnStore](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-2-install-enterprise-columnstore.md): Step 2: Install Enterprise ColumnStore
- [Step 3: Start and Configure Enterprise ColumnStore](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-3-start-and-configure-enterprise-columnstore.md): Step 3: Start and Configure Enterprise ColumnStore
- [Step 4: Test Enterprise ColumnStore](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-4-test-enterprise-columnstore.md): Step 4: Test Enterprise ColumnStore
- [Step 5: Bulk Import of Data](/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-5-bulk-import-of-data.md): Step 5: Bulk Import of Data
- [Upgrading ColumnStore](/docs/analytics/mariadb-columnstore/management/deployment/upgrades.md)
- [Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10](/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](/docs/analytics/mariadb-columnstore/management/deployment/upgrades/major-release-upgrades-for-mariadb-enterprise-columnstore.md)
- [Managing ColumnStore Database Environment](/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](/docs/analytics/mariadb-columnstore/management/managing-columnstore-database-environment/columnstore-partition-management.md)
- [Node Maintenance for MariaDB Enterprise Columnstore](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore.md)
- [Adding a Node](/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](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/rejoin-a-node.md)
- [Removing a Node](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/remove-a-node.md)
- [Setting a Node to Maintenance Mode](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/set-a-node-to-maintenance-mode.md)
- [Switchover of the Primary Node](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/switchover-primary-node.md)
- [View and Clear Table Locks](/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/view-clear-table-locks.md)
- [ColumnStore System Variables](/docs/analytics/mariadb-columnstore/management/columnstore-system-variables.md)
- [Backup & Restore](/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](/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/backup-and-restore-with-mariadb-enterprise-columnstore.md)
- [Backup and Restore with Object Storage](/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](/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](/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/mcs-backup-and-restore-commands.md)
- [Extent Map Backup & Recovery](/docs/analytics/mariadb-columnstore/management/extent-map-backup-recovery.md)
- [Upgrading MariaDB Enterprise ColumnStore (Alpha)](/docs/analytics/mariadb-columnstore/management/upgrades.md)
- [ColumnStore and Recursive CTE Limitations](/docs/analytics/mariadb-columnstore/management/columnstore-and-recursive-cte-limitations.md)
- [ColumnStore Table Size Limitations](/docs/analytics/mariadb-columnstore/management/columnstore-table-size-limitations.md)
- [Optimizing Linux Kernel Parameters for MariaDB ColumnStore](/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.