Re: To ODA or Not?

Although Mladen is correct in what he is describing. It is (used to be?) possible to build an active-passive cluster using Oracle Clusterware, and use it to move a single-instance database from one node to another in the event of failures. I have done this myself. Since the introduction of RAC One-Node, though, I have avoided using this, because the two are very nearly indistinguishable and could get you in trouble in an audit. (That said, the old use probably still is legitimate -- this is just me in "risk management" mode. The easiest way to win a fight is to avoid it altogether.)

Mladen is not quite correct, though, in saying that Oracle clusterware is "free". There is no charge for Oracle clusterware, so long as at least one node in the cluster is (properly) licensed to run Oracle. You can build a MySQL active-passive cluster this way, but unless the rules have changed in the last year or two, you will need to buy some Oracle database licenses to do it!

(It is just possible that this has changed, though, since Oracle took ownership of MySQL.)

On Sat, Mar 28, 2015 at 3:04 PM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:

> RAC One Node is not free. Nor does it have anything to do with
> Clusterware. Nor does it have anything to do with MySQL. Nor is the
> ORACLE_SID the same on all cluster nodes. I think you may be confused by
> what RAC One Node is.
>
> RAC One Node allows a connection failover between two or more active
> instances (temporarily) exactly the same as RAC. There is no way to achieve
> this with active-passive clustering. A database is one of RAC, RAC One Node
> or Single Instance. They are all mutually exclusive.
>
> Seth Miller
>
> On Sat, Mar 28, 2015 at 11:34 AM, Mladen Gogala <
> dmarc-noreply_at_freelists.org> wrote:
>
>> On 03/28/2015 01:52 AM, MARK BRINSMEAD wrote:
>>
>>> When did RAC One Node become "free"? Its been a while, but the last
>>> time I checked, it cost something like $5500 ($11,000?) per processor. It
>>> certainly wasn't "free". (Although that doesn't mean it isn't now, I
>>> guess. I have not looked at a pr
>>>
>> Hi Mark,
>> Clusterware is free. You can install clusterware without paying and use
>> it to fail-over MySQL service. Oracle licenses are not free.
>>
>>
>> --
>> Mladen Gogala
>> Oracle DBA
>> http://mgogala.freehostia.com
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l