> 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) --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## 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.