MariaDB ColumnStore Administrative Console

The MariaDB ColumnStore Management Console allows you to configure, monitor, and manage the MariaDB ColumnStore system and servers. Once you have a running ColumnStore cluster, you can invoke the console from any of the UM or PM nodes. The console utility is called mcsadmin

[myuser@srv1~]# mcsadmin
MariaDB Columnstore Admin Console
   enter 'help' for list of commands
   enter 'exit' to exit the MariaDB Columnstore Command Console
   use up/down arrows to recall commands
Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
Critical Active Alarms:

mscadmin> quit

You can use one of the following commands in the console

Command                           Description
------------------------------    --------------------------------------------------------
?                                 Get help on the Console Commands
addDbroot                         Add DBRoot Disk storage to the MariaDB Columnstore System
addModule                         Add a Module within the MariaDB Columnstore System
alterSystem-disableModule         Disable a Module and Alter the InfiniDB System
alterSystem-enableModule          Enable a Module and Alter the MariaDB Columnstore System
assignDbrootPmConfig              Assign unassigned DBroots to Performance Module
assignElasticIPAddress            Assign Amazon Elastic IP Address to a module
disableLog                        Disable the levels of process and debug logging
disableMySQLReplication           Disable MySQL Replication functionality on the system
enableLog                         Enable the levels of process and debug logging
enableMySQLReplication            Enable MySQL Replication functionality on the system
exit                              Exit from the Console tool
getActiveAlarms                   Get Active Alarm list
getActiveSQLStatements            Get List Active SQL Statements within the System
getAlarmConfig                    Get Alarm Configuration Information
getAlarmHistory                   Get system alarms
getAlarmSummary                   Get Summary counts of Active Alarm
getLogConfig                      Get the System log file configuration
getModuleConfig                   Get Module Name Configuration Information
getModuleCpu                      Get a Module CPU usage
getModuleCpuUsers                 Get a Module Top Processes utilizing CPU
getModuleDisk                     Get a Module Disk usage
getModuleHostNames                Get a list of Module host names (NIC 1 only)
getModuleMemory                   Get a Module Memory usage
getModuleMemoryUsers              Get a Module Top Processes utilizing Memory
getModuleResourceUsage            Get a Module Resource usage
getModuleTypeConfig               Get Module Type Configuration Information
getProcessConfig                  Get Process Configuration Information
getProcessStatus                  Get MariaDB Columnstore Process Statuses
getSoftwareInfo                   Get the MariaDB Columnstore Package information
getStorageConfig                  Get System Storage Configuration Information
getStorageStatus                  Get System Storage Status
getSystemConfig                   Get System Configuration Information
getSystemCpu                      Get System CPU usage on all modules
getSystemCpuUsers                 Get System Top Processes utilizing CPU
getSystemDisk                     Get System Disk usage on all modules
getSystemInfo                     Get the Over-all System Statuses
getSystemMemory                   Get System Memory usage on all modules
getSystemMemoryUsers              Get System Top Processes utilizing Memory
getSystemNetworkConfig            Get System Network Configuration Information
getSystemResourceUsage            Get System Resource usage on all modules
getSystemStatus                   Get System and Modules Status
help                              Get help on the Console Commands
monitorAlarms                     Monitor alarms in realtime mode
movePmDbrootConfig                Move DBroots from one Performance Module to another
quit                              Exit from the Console tool
removeDbroot                      Remove DBRoot Disk storage from the MariaDB Columnstore System
removeModule                      Remove a Module within the MariaDB Columnstore System
resetAlarm                        Resets an Active Alarm
restartSystem                     Restarts a stopped or shutdown MariaDB Columnstore System
resumeDatabaseWrites              Resume performing writes to the MariaDB Columnstore Database
setAlarmConfig                    Set a Alarm Configuration parameter
setModuleTypeConfig               Set a Module Type Configuration parameter
setProcessConfig                  Set a Process Configuration parameter
setSystemConfig                   Set a System Configuration parameter
shutdownSystem                    Shuts down the MariaDB Columnstore System
startSystem                       Starts a stopped or shutdown MariaDB Columnstore System
stopSystem                        Stops the processing of the MariaDB Columnstore System
suspendDatabaseWrites             Suspend performing writes to the MariaDB Columnstore Database
switchParentOAMModule             Switches the Active Parent OAM Module to another Performance Module
system                            Execute a system shell command
unassignDbrootPmConfig            Unassign DBroots from a Performance Module
unassignElasticIPAddress          Unassign Amazon Elastic IP Address