How to backup zabbix database?

[krusty]

Hi,
i have a question about backup the zabbix database. Is there any backup module included into zabbix code which can do automaticly start or save a backup of the database? Maybe there is a function to do incremental backups.

Please let me know how i can do something.

Greetz

[dminstrel]

Well, if you're using MySQL as a database engine, this is all you need:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

I've setup a simple cron job that takes daily backups.

Postgres probably has something similar.

Cheers,

[krusty]

Thanks for your information. But with this tool i can only get full database backups. If have monitored 1200 Routers with the zabbix tool so i have many values in my database. Is their a solution to do incremental backups? Maybe the zabbix developer could implemented something like this into the next versions of zabbix.

[Alexei]

I believe incremental backups is responsibility of a database engine. I'm not sure if MySQL supports this.

[krusty]

Yeah, i have to google for it. But i think there is a problem, because zabbix write all data into history and trends table. So i dont think the is a facility to do incremental backups. But i will search and report here.

[Alexei]

Advanced database engines (Informix, Oracle, DB2) do online incremental backups perfectly regardless od DB structure and its size. I don't think implementing this on application level is a good idea.

[KarmaPolice]

Advanced database engines (Informix, Oracle, DB2) do online incremental backups perfectly regardless od DB structure and its size. I don't think implementing this on application level is a good idea.

I agree with this statement 100% as a DBA I would never consider it an applications job to back itself up.

On the other hand databases should have the ability to do incremental backups I know ORACLE does, as does DB2... I would find it very hard to believe that MySQL doesn't have the same in version 5 considering how one of their main objectives is to begin taking away enterprise level databasing from ORACLE et al.

[bbrendon]

I know mysql 5 supports incremental. I don't believe earlier versions do.

You need to use the binary logs to get incremental backups.

[krusty]

I know mysql 5 supports incremental. I don't believe earlier versions do.

You need to use the binary logs to get incremental backups.

This sounds good. Do you use this function on MySQL5? What I have to do, to set up incremental backups?

[KarmaPolice]

I would wander around mysql.com a bit and look through their information... i'm sure it's not that complex, and i'm sure you'll find much more accurate information for managing MySQL there than here

[elkor]

while on the subject of databases...


Alexei, I wouldn't want to delay b7 .. but what ever happened to Oracle support? I could really leverage some fast hardware if we had that

[KarmaPolice]

while on the subject of databases...


Alexei, I wouldn't want to delay b7 .. but what ever happened to Oracle support? I could really leverage some fast hardware if we had that

HAHAHAHA... while i second this idea whole heatedly... i am somewhat opposed to open source interfacing closed source...

It would help win over a ton of support for the product at my company, i know that's for sure since right now we are one of only 2 MySQL databases in the company and they look at us ugly everytime it gets mentioned.

[elkor]

HAHAHAHA... while i second this idea whole heatedly... i am somewhat opposed to open source interfacing closed source...

It would help win over a ton of support for the product at my company, i know that's for sure since right now we are one of only 2 MySQL databases in the company and they look at us ugly everytime it gets mentioned.

I disagree.

the OS vs CS argument should collectively stop at their APIs. This allows the maximum amount of flexability and interconnectivity, allowing zabbix to write to an oracle database does NOTHING but allow better enterprise level penetration of an admittedly fine product.

the fact that oracle's db engine is closed source has nothing to do with the power of said engine, and if zabbix can benefit from that power (partiuarly in the instances where it is already installed and licensed) than that only adds to it's strengths