mamonsu 3.0.0

NOTE: Mamonsu 3.0.0 is incompatible with previous versions.

Compatibility Considerations

If you want to upgrade mamonsu to a version that is not compatible with the previous one, what you must do to continue using the application depends on whether you need to retain the metrics data collected.

If you need to retain the collected data, do the following:

1. Install the new version of mamonsu.
2. Generate a new template for the Zabbix server.
3. If you performed a bootstrap using the previous version of mamonsu, run the bootstrap command again.
4. Upload the new template to the Zabbix server.
5. Rename the host for which you want to retain the collected data and leave the old template linked to that host.
6. Create a new host for the same system and link the new template to it.
7. Restart mamonsu. It will collect data for the new host. The old host will no longer be used, but the data collected will be available.

If you do not need to retain the collected data, do the following:

1. Install the new version of mamonsu.
2. Generate a new template for the Zabbix server.
3. If you performed a bootstrap using the previous version of mamonsu, run the bootstrap command again.
4. Upload the new template to the Zabbix server.
5. In the settings of the Zabbix host, link the new template to the host instead of the old one.
6. Restart mamonsu. It will start collecting data. All the data collected earlier will be lost.

Changelog

• Template name changed from PostgresPro-[PLATFORM] to Mamonsu PostgreSQL [PLATFORM];
• Changed PostgreSQL uptime metric type to unixtime (date and time of service start);
• Changed Cache Hit Ratio metric calculation: now it evaluates via Zabbix calculated item;
• Changed Archive Command plugin metrics: now they evaluate without accessing the FS;
• Metric name pgsql.transactions [total] changed to pgsql.transactions [committed];
• Added new PG14 metrics based on pg_stat_wal and pg_stat_statements_info:
  • pgsql.wal.records.count;
  • pgsql.wal.fpi.count;
  • pgsql.wal.buffers_full;
  • pgsql.wal.write_time;
  • pgsql.wal.sync_time;
  • pgsql.wal.sync_duty;
  • pgsql.stat_info[dealloc];
  • pgsql.stat_info[stats_reset];
• Removed graphs representing only one metric (since this duplicates the functionality of Zabbix simple graphs);
• Added new graphs:
  • PostgreSQL bgwriter buffers;
  • PostgreSQL bgwriter write/sync;
  • PostgreSQL checkpoint count;
  • PostgreSQL checkpoint write/sync;
• Added screens: Overview, PostgreSQL Instance, PostgreSQL WAL, PostgreSQL Locks, PostgreSQL Transactions, System;
• Fixed support for different Zabbix versions (3.0-5.4):
• Added new bootstrap flag x/--create-extensions to optionally create extensions;
• Added default mamonsu user creation to bootstrap tool;
• Added mamonsu own schema creation to bootrtap tool;
• Changed mamonsu plugin structure: added new parameter for Zabbix screens;
• Fixed #159;