Ad Widget

Collapse

Backup and restore of zabbix database in Gui

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fredrik Developer
    Junior Member
    • Nov 2016
    • 1

    #1

    Backup and restore of zabbix database in Gui

    It would be really good to be able to do a backup & restore of the zabbix database directly in the GUI.

    Then you could to a backup and add a new version of zabbix thru appliance and restore the database and be up and running again with a new refresh version of Zabbix

    Also to have a scheduled backup and ftp the zip to another location.
  • kloczek
    Senior Member
    • Jun 2006
    • 1771

    #2
    Originally posted by Fredrik Developer
    It would be really good to be able to do a backup & restore of the zabbix database directly in the GUI.

    Then you could to a backup and add a new version of zabbix thru appliance and restore the database and be up and running again with a new refresh version of Zabbix

    Also to have a scheduled backup and ftp the zip to another location.
    Not possible.
    It would be working only in case relatively small databases.
    In most cases doing DB backup over SQL interface is incredibly slow.
    Doing any backups on main database instance even in case average databases even by reading all files and zip them may cause serious performance impact as doing such backup over VFS layer is trashing all MFU data.
    Only way to deal with above is cange DB from single instance to master<>slave and do binary backup on slave.
    http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
    https://kloczek.wordpress.com/
    zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
    My zabbix templates https://github.com/kloczek/zabbix-templates

    Comment

    Working...