ColumnStore Configuration File Update and Distribution

Update and distribute MariaDB ColumnStore configuration files: edit ColumnStore.xml on PM1, then run mcsadmin distributeconfigfile to propagate changes to other nodes.

In case where an entry in the MariaDB ColumnStore's configuration needs to be updated and distributed, this can be done from the command line from Performance Module #1. All changes made to MariaDB ColumnStore's configuration file need to be applied on PM1.

mcsadmin distributeconfigfile only needs to be run if the system is active. If the system is down, then just make the change, and when the system is started, the update will get distributed.

Here is an example:

/usr/local/mariadb/columnstore/bin/configxml.sh setconfig SystemConfig SystemName mcs-1
mcsadmin distributeconfigfile

In the cases where MariaDB ColumnStore's configuration files get out of sync with the PM1 copy, run the following to get MariaDB ColumnStore's configuration file redistribute to the other nodes.

To do this run the following on PM1:

mscadmin distributeconfigfile

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}