Comments - MariaDB Columnstore Health & Performance
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
You still have the Admin Console command, mcsadmin. You can run commands like 'getSystemInfo' that will show the status of the system. You have have commands like 'getSystemResourceUsage' which show the local server/node resource usage, like memory, cpu, and disk. Local system alarms are still detected and reported and those can be shown by the command 'getActiveAlarms'.
We decided to remove the snmp capability as it added a lot of complexity to the system and 80% of what it does can be covered by a standard monitoring tool setup. To monitor the columnstore system health use the getSystemInfo call and wrap that in your monitoring tool. I have a simple reference implementation if you need some pointers.
Thank you for the quick response! If you don't mind sharing the simple example that would be awesome!
I added it here: https://mariadb.com/kb/en/mariadb/columnstore-system-operations/#simple-external-monitoring-script. If you have any suggestions or improvements let me know and we can add to the source tree.