Archive mysql database
Hello,
I would like to archive my mysql database of zabbix. Is there an option for zabbix to automatically used different places (tiered storage)?
The best option would be to have data for the current month (or week, whatever) in tables wich are on fast (but expensive) hardware like fibrechannel raid, and everything older than one month would be stored on inexpensive hardware like sata raid disks.
Perhaps by using different table names (and define in MySQL on which partition the archive tables are), or even better to use different mysql databases wich could be on different server hardware.
Is such an option available?
I would like to archive my mysql database of zabbix. Is there an option for zabbix to automatically used different places (tiered storage)?
The best option would be to have data for the current month (or week, whatever) in tables wich are on fast (but expensive) hardware like fibrechannel raid, and everything older than one month would be stored on inexpensive hardware like sata raid disks.
Perhaps by using different table names (and define in MySQL on which partition the archive tables are), or even better to use different mysql databases wich could be on different server hardware.
Is such an option available?