[zabbix 4.0.8][active proxy] DB incident, recover data from active proxy ?
Hi all,
So here goes nothing:
As a proof of concept, we have set up a zabbix server with 3 active SQLITE proxies. We are using a partitionned InnoDB cluster database.
Our DBA had forgotten to create the partitions for august, so no data was inserted from august 1st 00:00 to august 1st roughly 10:30.
This should not have happened, but guess what, it did. So the big question here is: is it possible to retrieve the data we lost ? If possible, how do I retrieve the values ?
Proxy is set up with :
So, as the server was OK, just not able to insert values, I'm guessing it was useless.
If this was to happen again, is there a way to retrieve the data ?
I'd want to use something like:
So we could recover a little more than a week-end worth of data.
What remains to be solved is: how ? I'd value some input on the subject.
Any idea will be considered as this might be a big problem for us.
So here goes nothing:
As a proof of concept, we have set up a zabbix server with 3 active SQLITE proxies. We are using a partitionned InnoDB cluster database.
Our DBA had forgotten to create the partitions for august, so no data was inserted from august 1st 00:00 to august 1st roughly 10:30.
This should not have happened, but guess what, it did. So the big question here is: is it possible to retrieve the data we lost ? If possible, how do I retrieve the values ?
Proxy is set up with :
Code:
ProxyMode=0 ProxyOfflineBuffer=12
If this was to happen again, is there a way to retrieve the data ?
I'd want to use something like:
Code:
ProxyMode=0 ProxyOfflineBuffer=72 ProxyLocalBuffer=72
What remains to be solved is: how ? I'd value some input on the subject.
Any idea will be considered as this might be a big problem for us.