zabbix upgrade + OS upgrade + DB upgrade + move DB to dedicated server

[thijz]

Hi All,

I'm facing a rather complicated upgrade :

I currently have Zabbix 5.0 on a Ubuntu server 18.05 VM that also runs the DB (Ver 15.1 Distrib 10.1.48-MariaDB)
yeah ...

The goal :
- upgrade the OS to OracleLinux 8.7 (=new VM)
- upgrade Zabbix to 6.0
- upgrade MariaDB + move the DB to a dedicated new VM
- set up a proxy in remote location (not too worried about this)




This is what i have done already :
- set up new OracleLinux8.7 VM for DB
- install MariaDB, tweak config
- use mysqldump to get the existing data from the original server
- set up new OracleLinux8.7 VM for Zabbix server+frontend
..

but then i'm a bit stuck :
Should i
- install Zabbix5.0 on the Zabbix VM
- set it up tu use my new DB (on dedicated VM)
- do the the initial DB config (create DB)
- import the old data
- check if everything works
- partition the tables
- upgrade zabbix5.0 to 6.0

Or should i be doing it in a different order ?


All help is much appreciated !

[LenR]

First, what I did different. I moved all of /var/lib/mysql with rsync instead of mysqldump, it's faster and moved the partitions. But you have to stop zabbix and mysql on the old server for a clean backup.

If you just run the partitioning script now, I think all your old data will be in one partition (It will create the future partitions), it was in daily or monthly partitions before. That will cause retention and space usage changes, if it matters.

Your restore from the old server will completely wipe your Zabbix database, so there isn't really any need to install Zabbix 5 and load it's database, from where you are, you just need the Zabbix users and permissions.

From where you are, I think you can:

1) Setup mysql zabbix users
2) restore the data
3) partition setup
4) install Zabbix 6 but don't do the "create database" part.
5) when you start the zabbix server, check that it upgrades the database sucessfully.

[thijz]

Thank you very much for the feedback LenR !
I will try this approach and see how far i get :-) Luckily these are all VM's that i can clone so i can mess around without doing too much harm :-)

Thnx !