Bundled to RDS Migration

Before you start migrating bundled to RDS for AWS, test the connection for both kmrepo and delverepo bundled Postgres databases. This is required to verify passwords for both databases. You must use the same passwords for Kyvos Manager and Kyvos RDS respectively.

Creating Amazon Relational Database Service (RDS)

To create and migrate Kyvos Manager RDS, perform the following steps.

1. Login to the AWS console.

2. Navigate to RDS. On the RDS page, click Databases in the left pane.

3. On the Databases page, click Create database.

   

4. Create a new Database instance as per the below settings:

   1. Use Postgres version 13.5.

   2. Provide the name of the Database Instance.

      

   3. Provide the Master username as kmdbuser for the Kyvos Manager DB Instance.

   4. Provide a password for the Database. (use default password kyvosmanager#123)

   5. Use db.t3.large as the instance type for the KM DB instance.

      

   6. Specify the Storage.

      

   7. Create a new security group.

      

   8. Expand the Additional configuration and change the port from 5432 to 45421.

   9. Provide the database name as kmrepo.

      

Kyvos Manager RDS Creation and Migration

1. To create RDS, perform steps from 1 to 3 as mentioned in the ‘Creating Amazon Relational Database Service (RDS)’ section.

2. Once the RDS instance is created. Open the security group attached to it and edit the inbound rules.

3. In the inbound rule, pass the port as 45421 and source will be the CIDR of the subnet in which Kyvos is launched.

4. Login to the Kyvos Manager machine and stop running Kyvos Manager.

5. Navigate to /data/kyvos/app/postgres/bin.

6. Take the kmrepo database dump using the following command:
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/kyvos/app/postgres/lib
   ./pg_dump -c -C --host=localhost --port=45421 --dbname=kmrepo --user=kmdbuser --file /tmp/kmrepo.sql

7. Validate that the file is created, and it has content in it.

8. Restore the data dump in KM RDS using below command:
   ./psql -U kmdbuser -p 45421 -h <database_endpoint> -d kmrepo -f /tmp/kmrepo.sql

9. Navigate to /data/kyvos/installs/kyvosmanager_war/kyvosmanagerdata/server/db/ and take a backup of jdbc.properties.

10. Open the jdbc.properties and update only the below highlighted properties.

    1. JDBC URL will be: jdbc:postgresql://<endpoint_of_kyvosmanager_RDS>:45421/kmrepo

    2. Make sure the jdbc.username will be kmdbuser

    3. Update the repoIdentifier with the RDS identifier name. - Update the useBundledRepo from true to false

11. Once done, start the Kyvosmanager and verify the KM application is working as expected.

Kyvos RDS Creation and Migration

1. To create RDS, perform steps from 1 to 3 as mentioned in the ‘Creating Amazon Relational Database Service (RDS)’ section.

   1. Use database name as delverepo.

   2. Use the database user name as postgres.

   3. Use the same security group that is created for the Kyvos Manager RDS.

   4. Port will be same as 45421.

2. To take the Database dump for Kyvos Database:

   1. Navigate to /data/kyvos/app/postgres/bin/

   2. Execute the following below commands:
      ./pg_dump -c -C --host=localhost --port=45421 --dbname=delverepo --user=postgres--file /tmp/delverepo.sql

   3. Validate that the created file must have content.

   4. Restore the Kyvos database dump using the following command:
      ./psql -U postgres -p 5432 -h cbre-kyvos.ctdjrop6598x.us-east-1.rds.amazonaws.com -d delverepo -f /tmp/delverepo.sql

   5. Once done, connect to Kyvos RDS using the following commands and make sure the database is restored.
      ./psql -h <endpoint_of_kyvos_RDS> -p 45421 -U postgres -d delverepo \dt+

   6. Once done, navigate to Kyvos Manager > Utilities > Manage Kyvos Repository.

   7. Click External repository.

   8. Provide the repository identifier and click Fetch. It will automatically fill the details.

   9. Click Test.

   10. Once the test connection is successful, click Save.