Ad Widget

Collapse

Upgrading Zabbix 2.4 with partitioned DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ged0
    Junior Member
    • Jan 2018
    • 8

    #1

    Upgrading Zabbix 2.4 with partitioned DB

    Hello,

    I got a situation with Zabbix upgrade and I need your expertise on this.

    Currently, I'm running Zabbix 2.4 with MySQL (Percona server 5.7.27-30.1.el7).
    Zabbix DB size is around 1TB. Any failure costs at least 2h of copying the backup to the DB server.

    I'm struggling with Zabbix upgrade. I have tried to upgrade to Zabbix 3.0 directly but got issues with DB upgrade.
    Once DB is upgraded my history data missing. Only data of the last partition is available.
    As I understand upgrade script modifies only one of many partitions.

    Partitioned table list:
    - history
    - history_log
    - history_str
    - history_text
    - history_uint
    - trends
    - trends_uint

    Have someone ran into this? How I could perform a complete upgrade?
    Is it possible to upgrade Zabbix with partitioned tables?
  • ged0
    Junior Member
    • Jan 2018
    • 8

    #2
    Hello,

    I want to share with you how my issue was resolved.

    I had an issue with data after Zabbix upgrade. I was complaining DB partitioning.
    The real issue was me. I was checking screens, which, had new items. New items didn't have long history data.

    I was thinking that I have lost data, but everything was there. I had to take a better look.

    I hope you don't run into same situation

    Comment

    Working...