# 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. - [Building ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/deployment/building-columnstore-in-mariadb.md): Build MariaDB ColumnStore from source for local development and debugging, with dependency installation steps for CentOS and instructions for fetching and compiling the codebase. - [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. - [Configuring ColumnStore Cross-Engine Joins](https://mariadb.com/docs/analytics/mariadb-columnstore/management/managing-columnstore-database-environment/configuring-columnstore-cross-engine-joins.md): Configure MariaDB ColumnStore to perform cross-engine joins with non-ColumnStore tables (InnoDB, MyISAM) by setting CrossEngineSupport connection details in ColumnStore.xml. - [Managing ColumnStore System](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system.md): Day-to-day management tasks for a MariaDB ColumnStore system, covering operational procedures, backup and restore workflows, and routine maintenance for production deployments. - [ColumnStore Audit Plugin](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/columnstore-audit-plugin.md): The MariaDB Audit Plugin can be enabled for MariaDB ColumnStore to log user access and SQL statements; install via INSTALL PLUGIN server\_audit and persist through ColumnStore's my.cnf. - [ColumnStore Configuration File Update and Distribution](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/columnstore-configuration-file-update-and-distribution.md): Update and distribute MariaDB ColumnStore configuration files: edit ColumnStore.xml on PM1, then run mcsadmin distributeconfigfile to propagate changes to other nodes. - [ColumnStore Redistribute Data](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/columnstore-redistribute-data.md): Redistribute data across MariaDB ColumnStore Performance Modules after adding capacity, using mcsadmin redistributeData; operates at partition granularity with a 64M-row table minimum. - [ColumnStore System Monitoring Configuration](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/columnstore-system-monitoring-configuration.md): MariaDB ColumnStore system monitoring uses ProcMon and ProcMgr for self-healing; ColumnStore.xml SystemConfig settings tune heartbeat, restart, and PM failover behavior. - [MariaDB ColumnStore Backup and Restore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/mariadb-columnstore-backup-and-restore.md): Backup and restore documentation for MariaDB ColumnStore, organized by version (1.0.x and 1.1.0) with end-to-end procedures for backing up and restoring ColumnStore deployments. - [Backup and Restore for MariaDB ColumnStore 1.0.x](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/mariadb-columnstore-backup-and-restore/backup-and-restore-for-mariadb-columnstore-10x.md): Backup and restore for MariaDB ColumnStore 1.0.x: suspend writes, back up MariaDB Server data files via mysqldump or directory copy, then back up ColumnStore data files and resume. - [Backup and Restore for MariaDB ColumnStore 1.1.0](https://mariadb.com/docs/analytics/mariadb-columnstore/management/columnstore-system/mariadb-columnstore-backup-and-restore/backup-and-restore-for-mariadb-columnstore-110.md): Backup and restore for MariaDB ColumnStore 1.1.0 using the MariaDB ColumnStore Tools package, available as RPM, DEB, or binary download from the MariaDB AX tools repository. - [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. - [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. - [System Troubleshooting MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/management/system-troubleshooting-mariadb-columnstore.md): Troubleshooting reference for MariaDB ColumnStore, including the alias commands defined during install (mcsmysql, mcsadmin, cpimport) and common diagnostic workflows. - [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) --- # 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.