Mnesia and Oracle

[Serge Aleynikov]

One feature that I truly miss in mnesia is its ability to be able to 
resynchronize a partitioned database after the network gets merged by 
using a user-selected behavior.

It is nowadays possible to make LANs quite robust, but when a network 
spans across miles, intermittent issues become more frequent than 
desired and mnesia resynchronization by a node restart becomes not quite 
a good of an option.

Perhaps someone in the OTP team can shed some light on whether we (the 
Erlang community) are going to see some functionality of mnesia any time 
soon that would address this issue.

Serge

Valentin Micic wrote:
> First of all, I do not want to be flamed here ;-) so, I want to stress 
> out that as much I've tried to get rid of mnesia, I did not found 
> anything better. Yet.
> Look, despite the fact that more and more money has been invested in the 
> network infrastructure, it seems that networks are less stable than 
> before. It is my experience that deploying distributed mnesia with table 
> replication over such a network, invariantly leads to problems -- mnesia 
> gets partitioned, and, depending on how complex the data model is, it 
> might be quite a difficult job to recover & re-syncronize. Now, as Ulf 
> pointed out once, it is not that other databases have a better solution, 
> it is just that problem is of such a nature that it is very dificult to 
> solve it in a generic way (or one-fits-all kind of way). This is why it 
> was easier for (at least) me to develop specialised journaling system, 
> and have complete control over what happens if and when network lets me 
> down. There.
> 
> V.
> 
> ----- Original Message ----- From: "Joel Reymont" <joelr1@REDACTED>
> To: "Valentin Micic" <valentin@REDACTED>
> Cc: "Yariv Sadan" <yarivvv@REDACTED>; "Ryan Rawson" 
> <ryanobjc@REDACTED>; "Inswitch Solutions" <erlang@REDACTED>; 
> <erlang-questions@REDACTED>
> Sent: Thursday, August 10, 2006 3:55 PM
> Subject: Re: Mnesia and Oracle
> 
> 
>>
>> On Aug 10, 2006, at 2:09 PM, Valentin Micic wrote:
>>
>>>  my experience with mnesia replication, however,  is somewhat  
>>> negative with respect to volatile network environment.
>>
>> Valentin, would you kindly elaborate?
>>
>> Thanks, Joel
>>
>> -- 
>> http://wagerlabs.com/