Greenplum Segment movement between hosts

[muhammad ali]

Hello Experts,

Scenario is that we have a single node GP VM with 8 segments(Consider it as node 1). Now we need to add a new host(Node 2) and move 4 segments from node 1 to node 2. Means both nodes will have 4 segments. Is this possible?

I know that a better strategy is to create a cluster on 2 new VMs with 4 segments each and then use gpcopy or restore backup. But just want to know if above scenario is easily  achievable .

Thanks and Regards,
Muhammad Ali 

[Luis Filipe de Macedo]

As far as I know you can't do that, but you can expand the cluster using gpexpand to have both with 8 segments.

Otherwise you can backup and restore to the new configuration. 

Obter o Outlook para Android

---

From: muhammad ali <engmuha...@gmail.com>
Sent: Tuesday, February 14, 2023 9:08:04 PM
To: Greenplum Users <gpdb-...@greenplum.org>
Subject: [gpdb-users] Greenplum Segment movement between hosts

 

!! External Email

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/6187ccae-ecc3-471a-9fba-a663425f79e9n%40greenplum.org.

!! External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.

[Cyrille Lintz]

Hello,

You can move the mirrors using gpmovemirrors (https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-utility_guide-ref-gpmovemirrors.html)

You can move the primaries using gprecoverseg (https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-utility_guide-ref-gprecoverseg.html)

In some cases, this may not be possible (for example, if a host was physically damaged and cannot be recovered). In this situation, gprecoverseg allows you to recover failed segments to a completely new host (using -p), on an alternative data directory location on your remaining live segment hosts (using -s), or by supplying a recovery configuration file (using -i) in the following format. The word <SPACE> indicates the location of a required space. Do not add additional spaces.

<failed_host_address>|<port>|<data_directory><SPACE>
<recovery_host_address>|<port>|<data_directory>

In your case, you will have to stop some primaries on the original VM using pg_ctl:

pg_ctl -D /data/primary/gpseg0 stop -m fast

By stopping the primaries you will simulate a failure as described in the paragrah earlier.

Cyrille

---

De : 'Luis Filipe de Macedo' via Greenplum Users <gpdb-...@greenplum.org>
Envoyé : mercredi 15 février 2023 14:47
À : muhammad ali <engmuha...@gmail.com>; Greenplum Users <gpdb-...@greenplum.org>
Objet : Re: [gpdb-users] Greenplum Segment movement between hosts

 

!! External Email

As far as I know you can't do that, but you can expand the cluster using gpexpand to have both with 8 segments.

Otherwise you can backup and restore to the new configuration. 

Obter o Outlook para Android

---

From: muhammad ali <engmuha...@gmail.com>
Sent: Tuesday, February 14, 2023 9:08:04 PM
To: Greenplum Users <gpdb-...@greenplum.org>
Subject: [gpdb-users] Greenplum Segment movement between hosts

 

!! External Email

Hello Experts,

Scenario is that we have a single node GP VM with 8 segments(Consider it as node 1). Now we need to add a new host(Node 2) and move 4 segments from node 1 to node 2. Means both nodes will have 4 segments. Is this possible?

I know that a better strategy is to create a cluster on 2 new VMs with 4 segments each and then use gpcopy or restore backup. But just want to know if above scenario is easily  achievable .

Thanks and Regards,
Muhammad Ali 

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.
To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/6187ccae-ecc3-471a-9fba-a663425f79e9n%40greenplum.org.

!! External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

To view this discussion on the web visit https://groups.google.com/a/greenplum.org/d/msgid/gpdb-users/PH0PR05MB86855328A5FA07307C296845C2A39%40PH0PR05MB8685.namprd05.prod.outlook.com.