Re: [Postgres-xc-general] node out situation

[Koichi S. <koi...@gm...>]

Hi,

So far, we can use PITR for individual datanode.   Unfortunately,
we've not released any utility to set it up.

Now we're working to add mirroring capability of datanodes, which
allow whole cluster continue to run and maintain cluster integrity
even when some mirror fails with disk failure.   In this case, mirror
can be failed back by stopping whole cluster, copying files from
another surviving mirrors and restart the cluster.

In the case of coordinator, because all the coordinators are
essentially clones, we can continue to run the cluster without the
failed coordinator.   To fail-back the coordinator, we can copy whole
database from another coordinator while the cluster is shut down and
restart whole cluster.

When a coordinator is failed and is involved in outstanding 2PC, we
need to clear it up to prevent them to appear in snapshots for a long
time.   We're now implemeting this capability.

Ideally, it's so nice to have each component failed back without
stopping cluster operation.   This will be a challenge of this year.

Regards;
----------
Koichi Suzuki



2011/1/5 Marcin Krol <mr...@gm...>:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello everyone,
>
> Suppose a node falls out of a cluster: say, it had a disk failure.
>
> After getting that node back online, how can I resync that node with a
> cluster so cluster integrity is preserved?
>
>
> - --
>
> Regards,
> mk
>
> - --
> Premature optimization is the root of all fun.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJNI38tAAoJEFMgHzhQQ7hOD60H/R9DhEfSU//+v/ab+N/MJ/oB
> ksbbWowklFo71iLonW/P9ZmeRD6NROX3a/gYNmBetQ7KUp2fAmyb35ijJNmwL7mA
> FTC9fpVD1Vv3DL1jWWo/7EyYA/mdcHsPhHGgKe4/s6mvESOU8dR0bFep1FDYFYuK
> 1DCsvB+l++Yu1HLJlbzJzmeS8E7f+pjPDzWyt8fPZ8StROc5lHq393c75gg2MKx7
> 03ylfxAqW6JIKbrqNwSsk7B5AoQ+tJETxbAzSaK5FoZ63fXcAtGFfOTQbSJ8pyyt
> HXfGziR0qgwjbhLGMLV+O56Dhj5lKT/UB8lrEljAJQUfPH4mpva/b2u84IkVQ98=
> =3wVa
> -----END PGP SIGNATURE-----
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment, and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>