Greetings,
I use xtrabackup to copy and restore the mysql databse. It's about 1 TB large.
I shut down zabbix-server and zabbix-web while restoring. I don't trust them to not keep some query lingering waiting to be executed, that isn't compatible with a restored database.
I let the proxies keep running though ... I have hundreds of them.
Here's what's unclear to me:
- when I start the server again, can it contain inconsistent caches somewhere, (e.g. as files, temporary files or local app data) that may corrupt the restored database or state?
- can proxies corrupt or mess up the database or state?
So my question about restoring backups are:
* Do I need to "reset" or re-install the server or do anyhing more than just shutting it down?
* Do I need to shut down proxies? Do I have to "reset" or re-install them potentially?
Are these things well documented and/or guaranteed?
I use xtrabackup to copy and restore the mysql databse. It's about 1 TB large.
I shut down zabbix-server and zabbix-web while restoring. I don't trust them to not keep some query lingering waiting to be executed, that isn't compatible with a restored database.
I let the proxies keep running though ... I have hundreds of them.
Here's what's unclear to me:
- when I start the server again, can it contain inconsistent caches somewhere, (e.g. as files, temporary files or local app data) that may corrupt the restored database or state?
- can proxies corrupt or mess up the database or state?
So my question about restoring backups are:
* Do I need to "reset" or re-install the server or do anyhing more than just shutting it down?
* Do I need to shut down proxies? Do I have to "reset" or re-install them potentially?
Are these things well documented and/or guaranteed?