The RRD directory can be a challenge if its large, but there are ways, like possibly keeping it on a ZFS drive array and using the snapshot backup option, never tried it with rrd but i assume it would work, then your missing rrd would be limited to the downtime of the server and the time it takes to restore the rrd files and then start up the pollers again

On 02 Nov 2017, at 09:36, Markus Klock markus@best-practice.se wrote:

What do you mean by a hot backup? Observium uses a standard MySQL-database which can be easliy backup with mysqldump https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html Use the --single-transaction to just dump the whole DB to a file, as this is done as a single transaction there is no issues with doing this on the live database.

To recover a broken Observium server you will need backup of 3 things. The MySQL-DB, the rrd-directory and the config.php-file

/Markus

2017-11-02 5:44 GMT+01:00 Vikas Kumar <mailvikasnow@gmail.com mailto:mailvikasnow@gmail.com>: Hi all,

Is it possible to take hot backup of observium database? Also if the observium server crashes unexpectedly will we be able to recover it?

Thanks

--

http://moodi.org/ Vikas Kumar | Hospitality & PR Coordinator Mood Indigo, IIT Bombay +91-9694532954 tel:+91%2096945%2032954 | mailvikasnow@gmail.com mailto:mailvikasnow@gmail.com https://www.facebook.com/vikas.cse.iitb

https://mailtrack.io/ Sent with Mailtrack https://chrome.google.com/webstore/detail/mailtrack-for-gmail-inbox/ndnaehgpjlnokgebbaldlmgkapkpjkkb?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality _______________________________________________ observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium