[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: carp + pfsync + sqlnet (Oracle)



On Mon, Jun 21, 2004 at 02:28:26AM -0500, James Cammarata wrote:
> At 06:00 AM 6/16/2004, [email protected] wrote:
> >Does anybody protect any oracle rdbms (sqlnet protocol) using
> >obsd 3.5 + carp + pfsync ? Does it work ? Is it problematic ?
> 
> I assume you want to do a redundant DB correct?  Databases are not suited 
> to this kind of failover, due to the lack of consistency between the files 
> on different disks.  Your best bet is to use Oracle's built in redundancy 
> (as expensive as that may be).  Creating a stand-by server is not cheap, 
> but that is the kind of redundancy you want.
I don't want to use stand-by server. I am aware of it and what it does.
Let assume I have oracle rdbms behind obsd firewall (working as a bridge) and 
it works ok. Now obsd is a single point of failure (SPOF) and if it
crashes/hangs (due to e.g. hardware failure) nobody can access oracle.
If I setup second obsd fw in a pair with the first (using carp + pfsync)
the obsd is not a SPOF but I am not sure if such configuration
influences sqlnet traffic somehow.
przemol