CODEWITHSUNDEEP
greenplum
Adam
Adam

Reputation: 525

two greenplum installation on the same machine

I have an old version of greenplum and I would like to upgrade to version 5.0.0 since it has been released. https://github.com/greenplum-db/gpdb/releases/tag/5.0.0.

I have a huge machine, and I can not simply have an equivalent one. So I would like to know how can I run both version on the same machine. I have seen for example gpseginstall distribute binaries to the /usr/local/gpdb which is already there for the old version.

Regards

Upvotes: 0

Views: 589

Answers (2)

oak
oak

Reputation: 186

I have run multiple versions in parallel on a single node system.

You need to set your config file you use for the gpinitsystem for different segment/mirror directories, master port, starting port, etc..

You will also need two different OS profiles to source, so when you log as gpadmin you can source your 4.3 or 5.0 paths ($GPHOME, $MASTER_DATA_DIRECTORY) for gpstart, gpstop, psql, etc..

Hope this makes sense... I haven't tried it on a multi node system, but the setup should be the same

i.e.

GPDB 4.3

ARRAY_NAME="GPDB"

MACHINE_LIST_FILE=./hostsfile

SEG_PREFIX=seg

PORT_BASE=40000

declare -a DATA_DIRECTORY=(/gpsegment4 /gpsegment4 /gpsegment4 /gpsegment4)

MASTER_HOSTNAME=mdw

MASTER_DIRECTORY=/gpmaster4

MASTER_PORT=5432

TRUSTED_SHELL=ssh

CHECK_POINT_SEGMENTS=8

ENCODING=UNICODE

DATABASE_NAME=gpadmin

#MIRROR_PORT_BASE=50000

REPLICATION_PORT_BASE=41000

#MIRROR_REPLICATION_PORT_BASE=51000

#declare -a MIRROR_DATA_DIRECTORY=(/mirror4 /mirror4 /mirror4 /mirror4)

GPDB 5.0

ARRAY_NAME="GPDB"

MACHINE_LIST_FILE=./hostsfile

SEG_PREFIX=seg

PORT_BASE=60000

declare -a DATA_DIRECTORY=(/gpsegment5 /gpsegment5 /gpsegment5 /gpsegment5)

MASTER_HOSTNAME=mdw

MASTER_DIRECTORY=/gpmaster5

MASTER_PORT=7432

TRUSTED_SHELL=ssh

CHECK_POINT_SEGMENTS=8

ENCODING=UNICODE

DATABASE_NAME=gpadmin

#MIRROR_PORT_BASE=70000

REPLICATION_PORT_BASE=61000

#MIRROR_REPLICATION_PORT_BASE=71000

#declare -a MIRROR_DATA_DIRECTORY=(/mirror5 /mirror5 /mirror5 /mirror5)

Upvotes: 1

Robert
Robert

Reputation: 1

I have seen where you can have different versions installed, then change the greenplum-db link to point to the one you want to run. That link is referenced when you enter gpstart. Not sure how you could have two different versions running at the same time on the same machine.

If your goal is to do upgrade dry runs and test on the new release, another alternative could be to deploy a Greenplum cluster using Microsoft Azure. This would deploy the latest version (5.0).

Sounds like you know how to build your own greenplum so you could delete that 5.0 install then install the version you are currently using, then practice the upgrade/migration as well as just kick the tires of 5.0.

You could also easily have side by side systems in Azure; one running your current release and the other running 5.0.

The smallest cluster you can deploy is 1 master and 1 segment which could be adequate depending on your requirements.

Hope this helps

Upvotes: 0

Related Questions