To upgrade Arcadia Enterprise on Amazon EMR, you must first terminate the existing EMR cluster that contains Arcadia Enterprise, and then deploy a new EMR cluster with Arcadia Enterprise.
Follow the steps in Deploying Arcadia Enterprise on an EMR Cluster.
After upgrading Arcadia Enterprise on EMR, perform the following post-installation tasks:
To migrate an SQLite Arcviz metastore from an existing deployment of Arcadia Enterprise to a new deployment of Arcadia Enterprise, there are following two options:
Transfer an Existing arcviz.db
Example format of transferring an existing arcviz.db from a stopped Arcviz service on an existing EMR deployment:
#Stop Arcviz on the master node
service arcviz stop
#Remove/rename the default metastore
mv /var/lib/arcadia/arcviz.db /var/lib/arcadia/arcviz.db.bak
#Transfer an existing arcviz.db (In this example we have a copy uploaded to an s3 bucket)
aws s3 cp s3://tempbucket/arcviz_db/arcviz.db /var/lib/arcadia/arcviz.db
#Ensure the file arcviz.db is owned by arcadia:arcadia
#Restart arcviz, output will indicate the status of the migration
service arcviz start
Rebuild arcviz.db from backup
Example format of rebuilding arcviz.db from backup:
#Stop Arcviz on the master node
service arcviz stop
#Remove/rename the default metastore
mv /var/lib/arcadia/arcviz.db /var/lib/arcadia/arcviz.db.bak
#Transfer the backup arcviz.db dump from an existing EMR deployment install dir
aws s3 cp s3://arc-emr-test-alex/ARCADIA-ENTERPRISE-4.5.0.0_1547601544-1.amzn1/
backup/sqlite/arcviz.db.ip-172-31-43-106.ec2.internal.1547755141.sql /var/lib/arcadia/
#Rebuild the SQLite db file
cd /var/lib/arcadia
sqlite3 arcviz.db < arcviz.db.ip-172-31-43-106.ec2.internal.1547755141.sql
#Ensure the file arcviz.db is owned by arcadia:arcadia
#Restart arcviz, output will indicate the status of the migration
service arcviz start
When you connect a newer version of Arcadia Enterprise on EMR to an external metastore that contains an ArcViz metastore, ArcViz metastore is automatically upgraded at startup.