Erlang/OTP Forums
Author Message

<  Open Telecom Platform (OTP)  ~  Mnesia Recovery
anderst
Posted: Thu Aug 23, 2007 7:06 pm Reply with quote
User Joined: 21 Nov 2006 Posts: 37
The nodes on which I was stress testing my system crashed because I ran out of disk space (Don't ask Smile). The crash was triggered by mnesia, which failed miserably to repair the files and recover.

Suggestions on what I should do in a production system to safeguard myself from this and ensure I can recover should I be forced to delete the schema and all of its associated files? What do the Gurus and the foot soldiers do out there?

Hilsen,
Anders
Back to top View user's profile Send private message Visit poster's website
francesco
Posted: Tue Aug 28, 2007 12:15 pm Reply with quote
User Joined: 07 Jul 2006 Posts: 249 Location: London
* A Duplicate your data on two nodes and make the node which did not crash the master.
* Take daily backups stored off site which you can revert to.
* Take a backup of the whole system, including the mnesia schema files.
* Buy more hard disks Smile

Regards,
Francesco
--
http://www.erlang-consulting.com
Back to top View user's profile Send private message Visit poster's website
anderst
Posted: Sun Sep 09, 2007 6:26 pm Reply with quote
User Joined: 21 Nov 2006 Posts: 37
Does anyone have any experience with Mnesia checkpoints? How helpful are they in soft real time systems where Mnesia is mainly used to store live data or as a cache?

Hilsen,
Anders
Back to top View user's profile Send private message Visit poster's website
francesco
Posted: Mon Oct 15, 2007 4:38 pm Reply with quote
User Joined: 07 Jul 2006 Posts: 249 Location: London
Quote:
Does anyone have any experience with Mnesia checkpoints? How helpful are they in soft real time systems where Mnesia is mainly used to store live data or as a cache?


Useless unless you have dependencies among your records. But if you have a cache with a Key, Element relationship, then you should focus your efforts on the TTL stamp, which will clear up any inconsistencies.

Francesco
--
http://www.erlang-consulting.com
Back to top View user's profile Send private message Visit poster's website

Display posts from previous:  

All times are GMT
View next topic
View previous topic
Page 1 of 1
Erlang Forum - Trap Exit Forum Index  ~  Open Telecom Platform (OTP)
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
Hosted by Erlang Solutions    |    Powered by phpBB and NoseBleed 1.14