The process of migrating the repository from an Azure single server to an Azure flexible server involves three steps.
Creation of a Flexible Server instance
For Kyvos Manager
Download the FlexibleServerKyvosManagerRepository.json templates from here to create a Flexible PostgreSQL Server.
Deploy the template and while providing parameters, ensure that you keep the repository’s password and username the same as currently in use on the single server.
For Kyvos
Download the FlexibleServerKyvosRepository.json templates from here to create a Flexible PostgreSQL Server.
Deploy the template and while providing parameters, ensure that you keep the repository’s password and username the same as currently in use on the single server.
Important
You must attach the Contributor role to Managed Identity on the Kyvos Flexible Server for starting or stopping Flexible Server through cluster scheduling.
Migrating data from a Single server to a Flexible Server
The process of migrating from a single server to a flexible involves two steps.
Granting permission
Important
The Single server instance from which data is migrated to Flexible Server, either this Single server must be kept running to allow rollback if required later.
It is suggested to take dump of Single server and preserve that dump to some secure location before terminating that Single server instance. This dump will be required to create a new single server with this dump imported in it when rollback of Kyvos is required to that last version of Kyvos which was supporting single server.
To migrate Single Server Repository to Flexible Server, perform the following steps.
Grant permission for data access from single server for migrating it to flexible server. To do this, open the single server for Kyvos and Kyvos Manager. Go to Connection Security and switch Allow access to Azure services to Yes.
Migrating Repository data from Single Server to Flexible Server
Important
When upgrade operation is started and reaches to a stage where services of BI Server is stopped then start migration of Single server data to the Flexible server.
Perform this step in an overlapping manner with the Kyvos upgrade to save the time and thus minimize the downtime window as in this particular upgrade additional activities (like data migration to Flexible server from single server as well as switching the system from single server to flexible server) are also required which if not done in an overlapping manner then it can increase downtime window.
Note
The steps to migrate data from the Single Server Repository to the Flexible Server remain the same for Kyvos and Kyvos Manager.
To migrate from Single Server to Flexible Server, you need to perform the following steps for Kyvos Manager and Kyvos separately using their corresponding instances.
Open the newly created Flexible Postgres Server for Kyvos.
Click Migrate.
Click Migrate from Single Server.
Provide the name of Migration and click Next.
In the Source field, choose the Server name of the existing Single server Postgres of Kyvos.
Provide the password of the existing Single server Postgres of Kyvos. Choose all the databases to migrate and then click Next.
In Target section, provide the password of the flexible server (which should be same as single server) and then click review and create.
The migration could take some minutes to several hours depending on the size of data.
Configuring Kyvos Manager repository
Once the migration is completed, follow the below steps to configure the new flexible server with Kyvos Manager.
To configure the new flexible server with Kyvos Manager, perform the following steps.
Ssh into Kyvos Manager node.
Stop the Kyvos Manager service by using the ./stop-km.sh command.
Go to /data/kyvos/installs/kyvosmanager_war/kyvosmanagerdata/server/db and open jdbc.properties.
Replace the server name in jdbc url with the server name of the Flexible server.
Remove the server name in jdbc.username and add the username.
For example, if existing username is ‘jdbc.username=kmdbuser@kyvosManager-postgresServer-6487’ then CHANGE it to ‘jdbc.username=kmdbuser’.Start Kyvos Manager using the ./start-km.sh command.
Configuring Kyvos repository
Login into Kyvos Manager, navigate to Utilities then refer to the Manage Kyvos Repository section.
After completing the upgrade process and configuring Flexible server, you must start Kyvos services.