MariaDB ColumnStore System Administration
Contents
System Status
Viewing system status The system status shows the status of the system and all equipped servers. To view the system status, use getSystemStatus command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin getSystemStatus from the operating system prompt. The table below shows the available system and server statuses.
| Status | Definition |
|---|---|
| Active | The system, server, or Network Interface Card (NIC) is available to process database requests |
| Auto Disabled | Disabled as a result of a server failure. |
| Auto Init | Auto initialization mode during a fault recovery. |
| Auto Offline | The system or server is offline due to a fault. |
| Busy_Init | The module/system is performing an initialization task at startup time before going to the ACTIVE state. |
| Degraded | The server is active, but the performance is degraded. A server is degraded when a NIC is not working. |
| Down | Communication failure. |
| Failed | A stop/start/restart request for the system or a server failed. |
| Initial | Initial state after a system reboot or install and before any action is taken. |
| Man Disabled | Disabled as a result of executing the altersystem-disableModule command. |
| Man Init | Manual initialization mode during a start or restart command. |
| Man Offline | The system or server was taken offline with the stop or shutdown command. |
| Up | Successfully communicating. |
When all servers are active, then the system status is active. If one server is Man OSystemffline and the others are active, the system is Man Offline. All equipped servers must be active before the system is shown as active.
Operations
Stopping the system
To stop the system use, stopSystem command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin stopSystem from the operating system prompt.
Stopping the system stops the storage engine database processes. The process that supports the Management Console and System Alarms remain active.
Starting the system or modules
To start the system, use startSystem command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin startSystem from the operating system prompt
Restarting the system
To restart the system, use restartSystem command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin restartSystem from the operating system prompt
Shutting down the system
To shut down the system completely including storage engine database processes as well as the process that supports management console and System Alarms, use shutdownSystem command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin shutdownSystem from the operating system prompt
Disabling System Modules
A System Module can be disabled when is system is ACTIVE or OFFLINE. To disable a module, use alterSystem-disableModule module_id command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin alterSystem-disableModule module_id from the operating system prompt.
Example: mcsadmin alterSystem-disablemodule PM2, PM3
The modules PM2 and PM3 will be stopped and disabled.
_Note_: Disabling a module may result in data loss if the data is local to the PM. If the data is SAN mounted, the dbroots would need to be moved to other PMs. Please see “Moving DBRoots” of this guide for more information on moving DBRoots.
Enabling System Modules
To enable a module, use alterSystem-enableModule module_id command in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin alterSystem-enableModule module_id from the operating system prompt.
Example: mcsadmin alterSystem-enablemodule PM2, PM3
The modules PM2 and PM3 will be enabled and started.
Switch Parent OAM Module
Parent OAM Module is the Performance Module that monitors the over all system including all the UM and PM nodes and their status, as well as handle PM node failover. In a running system with more than 1 PM node there will be 2 Parent OAM Module - an Active Parent and a Standby Parent.
To switch a module to the Standby Parent, use switchParentOAMModule in [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin switchParentOAMModule from the operating system prompt. The Standby Parent OAM Module shall become active.
To switch a module to a specific module: use switchParentOAMModule module_id on [mariadb-columnstore-administrative-console|mcsadmin], or simply use mcsadmin switchParentOAMModule module_id from the operating system prompt.
Example: switchParentOAMModule pm3
The Performance-Module 3 will become the active Parent OAM Module
