Re: mysql cluster allows on- line upgrades, is there anything like that in Oracle?
From: <zigzagdna_at_yahoo.com>
Date: Sun, 3 Jun 2012 05:20:24 -0700 (PDT)
Message-ID: <741d5427-650f-414c-8db0-f317f399e1ed_at_googlegroups.com>
On Sunday, June 3, 2012 3:18:02 AM UTC-4, Mladen Gogala wrote:
> On Sat, 02 Jun 2012 11:13:08 -0700, zigzagdna wrote:
>
>
> > Does Oracle have any HA in shared nothing architecture like mysql
> > custer?
>
> Oracle has shared nothing clusters. They're called "MySQL Clusters". As
> for HA in shared nothing architecture, it's always achieved by
> replication, it cannot be achieved by any other way because there is no
> sharing in shared nothing cluster. Oracle supports several types of
> replication: advanced replication (trigger based), STREAMS replication,
> Golden Gate replication and active standby (11G).
>
>
>
> --
> http://mgogala.byethost5.com
Date: Sun, 3 Jun 2012 05:20:24 -0700 (PDT)
Message-ID: <741d5427-650f-414c-8db0-f317f399e1ed_at_googlegroups.com>
On Sunday, June 3, 2012 3:18:02 AM UTC-4, Mladen Gogala wrote:
> On Sat, 02 Jun 2012 11:13:08 -0700, zigzagdna wrote:
>
>
> > Does Oracle have any HA in shared nothing architecture like mysql
> > custer?
>
> Oracle has shared nothing clusters. They're called "MySQL Clusters". As
> for HA in shared nothing architecture, it's always achieved by
> replication, it cannot be achieved by any other way because there is no
> sharing in shared nothing cluster. Oracle supports several types of
> replication: advanced replication (trigger based), STREAMS replication,
> Golden Gate replication and active standby (11G).
>
>
>
> --
> http://mgogala.byethost5.com
I am not sure in active standby (11G), one can do rolling uupgrade of database without nring Oracle downtime for few minutes/seconds. I could not find anything on google for active standby, but for physical standby, see link http://blog.csdn.net/sweethouse1128/article/details/6857571 but it requires some down time. Also I do not know whether SAP Oracle Database can be converted to logical standby. Received on Sun Jun 03 2012 - 07:20:24 CDT