Upgrading Arcadia Enterprise on EMR

To upgrade Arcadia Enterprise on EMR, you must terminate the existing EMR cluster with Arcadia Enterprise, and then deploy a new EMR cluster with Arcadia Enterprise. Follow the steps in Deploying Arcadia Enterprise on EMR Cluster.

Ater upgrading Arcadia Enterprise on EMR, perform the following post-installation tasks:

Migrating Arcviz Metastore

To migrate the old ArcViz metastore to the newly deployed EMR cluster, you have the following options:

Connecting to an SQLite Metastore

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:

  • Transferring an Existing arcviz.db

    Example format of trransferring 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
  • Rebuilding 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

Connecting to an External Metastore

Connecting a newer version of Arcadia Enterprise on EMR to an external metastore that contains an ArcViz metastore, automatically upgrades the ArcViz metastore at startup.