I'm currently running Zabbix 2.2 with the history and trend tables partitioned.
I done the partitioning using the first guide that was on the wiki (Docs/howto/mysql partitioning).
Note I'm running Percona XtraDB Cluster (Galera) 5.6 with Zabbix as a high-available active-passive setup (2 nodes + Galera arbitrator).
I'm planning to upgrade Zabbix to 3.0 but I'm worried about the changes in the tables that could take too long (history table has over 500 million rows, each partition not so much, 440NVPS) or could break the database due to the partitioning.
Has anyone done this upgrade? What was the impact on the database level? Do the history and trend tables change?
I done the partitioning using the first guide that was on the wiki (Docs/howto/mysql partitioning).
Note I'm running Percona XtraDB Cluster (Galera) 5.6 with Zabbix as a high-available active-passive setup (2 nodes + Galera arbitrator).
I'm planning to upgrade Zabbix to 3.0 but I'm worried about the changes in the tables that could take too long (history table has over 500 million rows, each partition not so much, 440NVPS) or could break the database due to the partitioning.
Has anyone done this upgrade? What was the impact on the database level? Do the history and trend tables change?
Comment