[OpenSIPS-Devel] [Fwd: Re: [NEW] Virtual DB module]

[Razvan Pistolea]

Hi Iñaki,

1. When in PARALLEL mode and an operation fails the connection to that db url will be closed.   
   
2. Synchronization between dbs will be lost.   
   
3. Ways to realize synchronization would be:   
3a.        save all operations and values (whenever a db fails at least for the duration of the failure)   
                feasible but not desired or required due to the way curent modules use dbs   
3b.        use database managers (that know how to merge databases)   
3c.        use a cluster db   
   
4. A response code at this time is given only if all dbs fail.   
Other modules interpret return codes as: (succes =0 or succes >0 (some) ) and (fail <0) not caring about [partial success].  
So a response != 0 for some modules will mean that the operation failed (even though only some db failed).  
A response code could also be given when failover switches to a new db (even though the operation on the new db succceds).  
  
Could you please explain what do you need the response code for? (there might be other ways to achieve extra operation information)  
   
Hope that answered your questions.

Regards,
Razvan Pistolea



> -------- Original Message --------
> Subject:     Re: [OpenSIPS-Devel] [NEW]
> Virtual DB module
> Date:     Thu, 30 Jul 2009 16:02:54 +0200
> From:     Iñaki Baz Castillo <ibc at aliax.net>
> CC:     devel at lists.opensips.org
> References:     <mailman.1.1248948002.8373.devel at lists.opensips.org>
> <208433.96124.qm at web38002.mail.mud.yahoo.com>
> <cc1f582e0907300700g134a95f0u1fbae172ca2cf125 at mail.gmail.com>
> 
> 
> 
> 2009/7/30 Iñaki Baz Castillo <ibc at aliax.net>:
> > 2009/7/30 Razvan Pistolea <razvy000 at yahoo.com>:
> > 
> >>        The virtual url could
> just as well use all the real connections at the same time
> .
> >>        Ex: when an insert
> operation takes place it will insert in all the real dbs.
> >>        This mode is called
> parallel and makes sence for write operations(insert,
> update, delete).
> > 
> > Great!
> > 
> > Let me a question: What does occur if when writing to
> various DB's at
> > the same time an operation fails?
> 
> Well, I read in the doc:
> 
>  PARALLEL
>  Use all the urls in the virtual db url. Fails if all the
> urls fail.
> 
> However we would lost syncronism between the databases. If
> there any
> way to realize of that? somre response code?
> 
> -- Iñaki Baz Castillo
> <ibc at aliax.net>
> 
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
> 
>