IDS Forum

Re: End chunk mirror on two serves doing er

Posted By: Juan Francisco González Navarro
Date: Friday, 4 December 2015, at 3:49 p.m.

In Response To: Re: End chunk mirror on two serves doing er (Khaled Bentebal)

I'm using er.

Regards
On 4 Dec 2015 8:34 pm, "Khaled Bentebal" <khaled.bentebal@consult-ix.fr>
wrote:

> This is If you are are using HDR of course.
>
> If you are using ER, the 2 instances are different since you are only
> replicating part of the database (some or part of some tables only).
>
> Cordialement, Regards,
>
> Khaled Bentebal
> Directeur Général - ConsultiX
> Tél: 33 (0) 1 39 12 18 00
> Fax: 33 (0) 1 39 12 18 18
> Mobile: 33 (0) 6 07 78 41 97
> Email: khaled.bentebal@consult-ix.fr
> Site Web: www.consult-ix.fr
>
> Le 04/12/15 20:17, Khaled Bentebal a écrit :
> > Just drop (using onspaces for example) the mirror chunk on the primary,
> > the system will do the rest for you.
> > The actual file or raw device remains on disk of course. If you run
> > onstat -d after dropping the mirror, you will not see the mirror chunk
> > displayed any longer. It is up to you to remove the actual file/raw
> > device (on both servers: primary and secondary.
> >
> > Do not forget that mirroring is per dbspace and not per chunk. If you
> > want to remove a mirror chunk, you have to do it for all of the chunks
> > of a dbspace. You cannot have a mirrored chunk and a not mirrored chunk
> > within a single dbspace. However, you can have a mirrored dbspace (all
> > of its chunks) and a not mirrored dbspace (all of its chunks).
> >
> > *Note*: there is a difference between diabling a mirror chunk and
> > removing a mirror chunk.
> > Diabling a mirror chunk is just changing a flag so that there is no
> > writing to it (interesting in certain situations if you want to do a
> > big load or a big UPDATE/DELETE) so your task is not penalized
> > performance-wise. When you change the flag (chunk status) again, the
> > system resynchronizes things for you online. You can have a DOWN chunk
> > (chunk exists but not active) and a ONLINE chunk in a single dbspace.
> > Removing a mirror chunk removes the chunk from the list of chunks that
> > the informix instance sees. If you want to put it back, you have to add
> > mirroring from scratch to that dbspace that contains one or more chunks.
> >
> > Cordialement, Regards,
> >
> > Khaled Bentebal
> > Directeur Général - ConsultiX
> > Tél: 33 (0) 1 39 12 18 00
> > Fax: 33 (0) 1 39 12 18 18
> > Mobile: 33 (0) 6 07 78 41 97
> > Email: khaled.bentebal@consult-ix.fr
> > Site Web: www.consult-ix.fr
> >
> > Le 04/12/15 19:37, a écrit :
> >> Hello:
> >>
> >> Which one is the best way to end chunk mirroring on two database
> servers?
> >>
> >> Maybe, end chunk mirror for root space on slave server and them on
> master
> >> server?
> >>
> >> And end chunk mirror for other space as final stage.
> >>
> >> Thank you.
> >>
> >> --001a113ecbee87c9c5052616cb37
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a113ecbeecabe8c052618a08c

Messages In This Thread

• End chunk mirror on two serves doing er
  Juan Francisco González Navarro -- Friday, 4 December 2015, at 1:37 p.m.
  • Re: End chunk mirror on two serves doing er
    Art Kagel -- Friday, 4 December 2015, at 1:50 p.m.
    • Re: End chunk mirror on two serves doing er
      Juan Francisco González Navarro -- Friday, 4 December 2015, at 3:48 p.m.
      • Re: End chunk mirror on two serves doing er
        Art Kagel -- Friday, 4 December 2015, at 4:09 p.m.
  • Re: End chunk mirror on two serves doing er
    Khaled Bentebal -- Friday, 4 December 2015, at 2:17 p.m.
    • Re: End chunk mirror on two serves doing er
      Khaled Bentebal -- Friday, 4 December 2015, at 2:34 p.m.
      • Re: End chunk mirror on two serves doing er
        Juan Francisco González Navarro -- Friday, 4 December 2015, at 3:49 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.