Ad Widget

Collapse

Are Zabbix configured hosts saved in MySQL databases?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • faresjan
    Junior Member
    • Sep 2023
    • 2

    #1

    Are Zabbix configured hosts saved in MySQL databases?

    Hello I have ran into an issue and posted about it 1-2 days ago. This issue is that Zabbix is showing that hosts are down mistakenly. My fellow Zabbix redditors concluded that this issue is related to slow database reading that are hosted on HDD. I was advised to move my Ubuntu virtual machine to SSD hard drive.


    I moved my VHDX file from HDD hard disk to SSD so my virtual machine can use SSD. After that I turned on my Ubuntu server my IP address for the server changed, even though I had it reserved in DHCP. I reconfigured DHCP to give my IP the previous IP that I had earlier which made me think that it will help Zabbix work again.


    I was wrong and now I can see error Database error No such file or directory. I tried to see if Mysql is working on my Ubuntu server and it seems its not working.


    If I reinstall MySQL on my server which will delete my existing Zabbix database, will I need to reconfigure my added hosts in Zabbix?

    Please help my mind is melting,

    Thank you!
  • tim.mooney
    Senior Member
    • Dec 2012
    • 1427

    #2
    Originally posted by faresjan
    If I reinstall MySQL on my server which will delete my existing Zabbix database, will I need to reconfigure my added hosts in Zabbix?
    All hosts, host groups, alerting actions, templates, users, etc. are stored in the database. If you delete your existing Zabbix database, you will lose all of that existing information, including historical and trend data for all your current hosts.

    Comment

    • faresjan
      Junior Member
      • Sep 2023
      • 2

      #3
      is there a way to reinstall MySQL without deleting my database?

      Comment

      Working...