> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/management.md).

# Management

- [Deployment](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment.md): Deployment documentation for MariaDB ColumnStore, including the hardware sizing guide, build-from-source instructions, install-guide topology variants, and upgrade procedures.
- [Installing ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide.md): Installation guides for MariaDB ColumnStore across four deployment topologies: single-node with local storage, single-node with S3, multi-node with local storage, and multi-node with S3.
- [Single-Node Localstorage](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage.md): Single-node MariaDB ColumnStore deployment with local storage: minimal-footprint topology suitable for development and small production OLAP workloads, including data import.
- [Step 1: Prepare Systems for 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 ColumnStore Nodes
- [Step 2: Install ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-2-install-enterprise-columnstore.md): Step 2: Install ColumnStore
- [Step 3: Start and Configure 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 ColumnStore
- [Step 4: Test ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/singlenode-localstorage/step-4-test-enterprise-columnstore.md): Step 4 of the single-node MariaDB ColumnStore install with local storage: connect to MariaDB Server with the root account and verify that ColumnStore is operational.
- [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): Multi-node MariaDB ColumnStore deployment with shared local storage: cluster topology, Enterprise Server installation, MaxScale routing, and bulk data import procedures.
- [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): Single-node MariaDB ColumnStore deployment with S3-compatible object storage on Enterprise Server and MaxScale, including bulk data import and OLAP-ready configuration.
- [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): Multi-node MariaDB ColumnStore deployment with S3 object storage: HA topology with three or more nodes, MaxScale routing, CMAPI cluster management, and bulk data import.
- [Step 1: Prepare Systems for ColumnStore Nodes](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-1-prepare-systems-for-enterprise-columnstore-nodes.md): Step 1: Prepare Systems for ColumnStore Nodes
- [Step 2: Install ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-2-install-enterprise-columnstore.md): Step 2: Install ColumnStore
- [Step 3: Start and Configure ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-3-start-and-configure-enterprise-columnstore.md): Step 3: Start and Configure ColumnStore
- [Step 4: Test ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/install-guide/multinode-s3/step-4-test-enterprise-columnstore.md): Step 4: Test ColumnStore
- [Step 5: Bulk Import of Data](https://mariadb.com/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](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades.md): Upgrade procedures for MariaDB ColumnStore, including major-release upgrades and the multi-node upgrade path from Enterprise ColumnStore 6 to 23.10.
- [Upgrade Multi-Node MariaDB 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): Upgrade a multi-node MariaDB ColumnStore cluster from 6 to 23.10, with MaxScale-based replica maintenance mode, controlled service stops, and per-node upgrade steps.
- [Major Release Upgrades for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades/major-release-upgrades-for-mariadb-enterprise-columnstore.md): Major-release upgrade procedure for MariaDB ColumnStore (CS 5 to 22.08): full data backup, optional reuse of existing servers, and stage-by-stage migration to the new version.
- [Refined Multi-Node Upgrade Sequencing: 6.x to 23.10](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/upgrades/refined-multi-node-upgrade-sequencing-6.x-to-23.10.md)
- [Building ColumnStore from Source](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/building-columnstore-in-mariadb.md): Build MariaDB ColumnStore from source for development and debugging. Check out the MariaDB server source with submodules, then build and install ColumnStore with the bootstrap\_mcs.sh script.
- [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): MariaDB ColumnStore partition management: automatic horizontal partitioning, calShowPartitions for inspection, and disable/drop operations for data lifecycle management with caveats.
- [Node Maintenance for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore.md): Node maintenance procedures for MariaDB ColumnStore via MaxScale: rejoin, remove, set to maintenance mode, switchover the primary, and view or clear table locks.
- [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 ColumnStore
- [Rejoining a Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/rejoin-a-node.md): Rejoin a node to a MariaDB ColumnStore cluster through MaxScale's REST API, calling the mariadbmon module's rejoin command via MaxCtrl or another REST client.
- [Removing a Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/remove-a-node.md): Remove a node from a MariaDB ColumnStore cluster by unlinking the server object from the MaxScale service using maxctrl or another REST client.
- [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): Set a MariaDB ColumnStore node to maintenance mode in MaxScale using the maxctrl set server command, taking the node out of read-write rotation.
- [Switchover of the Primary Node](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/switchover-primary-node.md): Switch the primary node in a MariaDB ColumnStore cluster by calling the mariadbmon switchover command in MaxScale via maxctrl or another REST client.
- [View and Clear Table Locks](https://mariadb.com/docs/analytics/mariadb-columnstore/management/node-maintenance-for-mariadb-enterprise-columnstore/view-clear-table-locks.md): View and clear lingering table locks in MariaDB ColumnStore using viewtablelock and cleartablelock, useful when a failed DDL or bulk load leaves a table locked.
- [ColumnStore System Variables](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system-variables.md): Reference for MariaDB ColumnStore system variables, with each variable's scope, default, dynamic flag, and description — including insert-cache controls and other tuning options.
- [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 overview for MariaDB ColumnStore: system-of-record planning, full and incremental backup strategies, and the components that must be backed up together.
- [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 for MariaDB ColumnStore on S3 object storage: MariaDB data directory via mariadb-backup, the S3 bucket via vendor snapshot, and the Storage Manager directory.
- [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): Backup and restore for MariaDB ColumnStore on shared local storage (NFS): MariaDB data directory via MariaDB Backup, the Storage Manager directory, and each DB Root directory.
- [MCS backup and restore commands](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/mcs-backup-and-restore-commands.md): MCS backup and restore CLI for MariaDB ColumnStore: full and incremental backups across local, shared, and S3 storage with compression, parallelism, and DBRM workflows.
- [Emergency S3 Data Reset Procedure](https://mariadb.com/docs/analytics/mariadb-columnstore/management/column-store-backup-and-restore/emergency-s3-data-reset-procedure.md)
- [Extent Map Backup & Recovery](https://mariadb.com/docs/analytics/mariadb-columnstore/management/extent-map-backup-recovery.md): Backup and recovery for the MariaDB ColumnStore Extent Map, the in-memory metadata that maps data extents and minimum/maximum values; corruption can render the cluster unusable.
- [Upgrading MariaDB ColumnStore (Alpha)](https://mariadb.com/docs/analytics/mariadb-columnstore/management/upgrades.md): Upgrade MariaDB Enterprise Server and ColumnStore across a cluster with the unified mcs install\_es command (Alpha), automating service stops, repository setup, and CMAPI restart.
- [ColumnStore and Recursive CTE Limitations](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-and-recursive-cte-limitations.md): MariaDB ColumnStore does not support recursive Common Table Expressions on ColumnStore tables; the page documents three workarounds for cases requiring recursive query patterns.
- [ColumnStore Table Size Limitations](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-table-size-limitations.md): MariaDB ColumnStore tables have a 4096-column hard limit; .frm file size (64KB) and storage-engine row-size limits typically cap effective tables at around 2000 columns.
- [Optimizing Linux Kernel Parameters for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/optimizing-linux-kernel-parameters-for-mariadb-columnstore.md): Recommended Linux kernel parameters for MariaDB ColumnStore: vm.overcommit\_memory, dirty-page ratios, vfs\_cache\_pressure, network buffer sizes, and process limits in /etc/sysctl.conf.
- [Monitoring and Logs](https://mariadb.com/docs/analytics/mariadb-columnstore/management/monitoring-and-logs.md)
- [Capturing System-Level Process Dumps (Core Dumps)](https://mariadb.com/docs/analytics/mariadb-columnstore/management/monitoring-and-logs/capturing-system-level-process-dumps-core-dumps.md)
- [Diagnosing Unresponsive Processes and Startup Hangs](https://mariadb.com/docs/analytics/mariadb-columnstore/management/monitoring-and-logs/diagnosing-unresponsive-processes-and-startup-hangs.md)
- [Decoding ColumnStore Stack Traces](https://mariadb.com/docs/analytics/mariadb-columnstore/management/monitoring-and-logs/decoding-columnstore-stack-traces.md)
- [DBRM Recovery and Journal Management](https://mariadb.com/docs/analytics/mariadb-columnstore/management/dbrm-recovery-and-journal-management.md)