Skip to main content

Upgrading/Migrating from Accelerator Versions Prior to 3.x

  1. On the old Hubble Accelerator 2.x machine:

    1. Stop the Vector Service:

      /etc/init.d/S60ingresVW stop

    2. Stop the Replication Service:

      /etc/init.d/S65areplicate stop

    3. Back up the current data disk (disk mounted on /mnt/ybdata).

    4. Detach the data disk.

  2. On the new Hubble Accelerator 4.x machine:

    1. Install the Hubble Accelerator 4.x (see Install Hubble Accelerator).

    2. Attach the data disk from the old Hubble Accelerator to the new machine:

      1. Run the following command::

        blkid

        You should see output similar to this. Locate the device with LABEL="ybdata" as it contains the old data:

        /dev/xvda2: UUID="4a1c93d9-eb47-4f96-9f3d-920e52dc8cca" TYPE="xfs" PARTUUID="078b129f-9e3b-4665-8871-232657ae682c"
        /dev/xvdb1: LABEL="ybconfig" UUID="213187cf-5d80-4623-b4fc-53fa5153cd35" TYPE="ext2" PARTUUID="897ae9ad-83e2-4e7c-8dd8-686cd0d36837"
        /dev/xvdb2: LABEL="ybdata" UUID="9a7fc249-8fd7-40ed-84a6-6789c8346f78" TYPE="ext3" PARTUUID="4c5d92db-4cf2-40f6-b0f1-c28d1f67652d"
        /dev/xvda1: PARTUUID="e7184259-29aa-42a5-b24d-1143dc10e5d8"

      2. Stop the Vector Service:

        systemctl stop actian-vectorVW

      3. Stop the Replication Service:

        /etc/init.d/areplicate stop

      4. Edit /etc/fstab

        vi /etc/fstab

        Add the following lines:

        LABEL=ybdata  /mnt/ybdata auto defaults 00
        /mnt/ybdata/ingres/ckp
        		 
        /opt/Actian/VectorVW/ingres/ckp
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/ingres/data
        		 
        /opt/Actian/VectorVW/ingres/data
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/ingres/dmp
        		 
        /opt/Actian/VectorVW/ingres/dmp
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/ingres/jnl 
        /opt/Actian/VectorVW/ingres/jnl
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/ingres/log
        		 
        /opt/Actian/VectorVW/ingres/log
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/ingres/work
        		 
        /opt/Actian/VectorVW/ingres/ work
        		 
        none
        		 
        bind,_netdev 
         00
        		 
        /mnt/ybdata/areplicate/data
        		 
        /opt/attunity/replicate/data 
        none
        		 
        bind,_netdev 
         00

  1. Refresh the mounts to implement the changes on fstab:

    mount -a

  2. Change user ownership for actian and attunity users on the mounted file-system folders by running:

    chown -R actian:actian /mnt/ybdata/ingres
    chown -R attunity:attunity /mnt/ybdata/areplicate/

  3. Remove the old db configuration:

    rm /mnt/ybdata/ingres/data/vectorwise/vectorwise.db.conf

  4. Create a new db configuration (where 4.x.x is the Hubble Accelerator version):

    /opt/insightsoftware/hubble-accelerator/4.x.x/vector/ configurevector.sh

    For example:

    /opt/insightsoftware/hubble-accelerator/4.2.1/vector/ configurevector.sh

  5. Reboot.