Ad Widget

Collapse

Upgrade from 2.2 to 3.0 with table partitioning.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • IvanBayan
    Junior Member
    • Dec 2014
    • 21

    #1

    Upgrade from 2.2 to 3.0 with table partitioning.

    Hello.
    Is it possible to upgrade zabbix from 2.2 to 3.0 if i use table partitioning?
    I read upgrade notes and found that zabbix server will upgrade DB by yourself, but what will happen when it will found that some tables was altered?
  • IvanBayan
    Junior Member
    • Dec 2014
    • 21

    #2
    Yesterday i made DB backup and tried to upgrade zabbix with success. Altering tables for mysql partitioning did not broke upgrade process.

    Comment

    • xanadu
      Member
      • Sep 2014
      • 62

      #3
      Originally posted by IvanBayan
      Yesterday i made DB backup and tried to upgrade zabbix with success. Altering tables for mysql partitioning did not broke upgrade process.
      It would be nice if you could list your upgrade steps and which method of partitioning you used. Are you using PostgresQL or Mariadb?

      Comment

      • IvanBayan
        Junior Member
        • Dec 2014
        • 21

        #4
        Hello.
        I just backup my DB, changed repository and upgraded zabbix packages.
        I use mysql with partitioning for history and trends tables by datetime field, i remember that i dropped some indexes for tables and because of that i worried that zabbix will not upgrade DB.
        PS
        I had a plan 'b' if zabbix couldn't upgrade db, i wanted to export data from db, drop it and create db with standard zabbix scheme, import data back, let zabbix to upgrade db and make partitioning again, but it was not necessary.

        Comment

        Working...