Yellowfin 7.3 and 7.4 parallel upgrade

Pearlsia shared this question 9 months ago
Answered

Hi,

We have existing YF 7.3 running in an old server sharing with another applications and it is in operation, we would like to changed the environment and do a separate installation of YF 7.4 on another server dedicated to Yellowfin only. The plan is to continue the use of YF 7.3 until we have fully migrated all content and tested everything on the new server and finally switch users to use the new YF 7.4. Is there a best practice to this or has this been already discussed here in the community? If yes, could anyone provide the link please? How will the license work for this type of upgrade?

Any help is highly appreciated.


Thanks,

Pearlsia.

Best Answer
photo

Hi Pearlsia,

Thanks for reaching out with your question. It looks like you're already headed in the right direction!

In order to accomplish this, the best answer is to start by:

A) Restore a full backup of your 7.3 Yellowfin Configuration Database onto the target server.

B) Perform a fresh install of the SAME 7.3 version on the target server into a temporary or DUMMY Database.

C) Edit line 112 in the <YellowfinInstall>/appserver/webapps/ROOT/WEB-INF/web.xml file to point to your RESTORED Database.

D) Restart Yellowfin.

From this point you will have a replica of your production 7.3 server, with all settings intact. The caveat here is that the license will be tied to your hostname. You may have to reach out to your Account Manager to discuss options for licensing here to finalize this process.

Once you have a license working for your target server, you can then begin your upgrade testing.

Let me know if this helps or if you have any further questions.

Thanks,

Ryan

Comments (8)

photo
1

Okay so I searched further and found these links:

https://community.yellowfinbi.com/knowledge-base/article/%E2%80%8Bbest-practice-for-performing-a-yellowfin-upgrade

https://community.yellowfinbi.com/knowledge-base/article/replicating-your-yellowfin-environment?_ga=2.38058467.1310391533.1534894879-1554337166.1532491985&_gac=1.249168179.1533254302.EAIaIQobChMI-8Ob5MjP3AIVE6qWCh3H1AguEAAYASAAEgIUO_D_BwE


This is what we are going to do, to mirror the YF 7.3 production environment on the new server .

Goal is to make it identical to the existing environment.


  • Perform the upgrade, use the same license (will this work?)
  • Perform the testing, and take note of the performance difference
  • Once we have confirmed the tests are all good, we can decommission YF 7.3 and uninstall it from the old server to reclaim resources to boost up other apps

photo
2

Hi Pearlsia,

Thanks for reaching out with your question. It looks like you're already headed in the right direction!

In order to accomplish this, the best answer is to start by:

A) Restore a full backup of your 7.3 Yellowfin Configuration Database onto the target server.

B) Perform a fresh install of the SAME 7.3 version on the target server into a temporary or DUMMY Database.

C) Edit line 112 in the <YellowfinInstall>/appserver/webapps/ROOT/WEB-INF/web.xml file to point to your RESTORED Database.

D) Restart Yellowfin.

From this point you will have a replica of your production 7.3 server, with all settings intact. The caveat here is that the license will be tied to your hostname. You may have to reach out to your Account Manager to discuss options for licensing here to finalize this process.

Once you have a license working for your target server, you can then begin your upgrade testing.

Let me know if this helps or if you have any further questions.

Thanks,

Ryan

photo
1

Hello Ryan,

Thank you for your response.

So just on the license part, is it possible to install another YF 7.3 on the new server during upgrade and testing while we keep the existing Yellowfin7.3 operational on the old server till we can confirm that everything is perfectly working on the new server and we can decommission/uninstall it from the old one?


What are the options for us to achieve this?


Thank you so much!

Kindest regards,


Pearlsia.

photo
2

Hi Pearlsia,

Yes it is possible to host two instances of Yellowfin on one server, provided there are adequate resources available to do so.

The caveat here is that you will have to set your NEW Instance to a different port number than the existing instance. This can be done during install per the process highlighted above.

You will also have to manually install this as a service (if on Windows) instead of doing so in the installer. To do this, after installation you will want to open a command line prompt in the <YellowfinInstall>/appserver/bin folder and execute the following command as Administrator:

service install Yellowfin74

This allows you to name the service uniquely so as to not cause problems with your existing service.

I would encourage you to reach out briefly to discuss this with your Account Manager, as they are often willing to work with clients who are performing operations such as this.

Please let me know if you have further questions on the process.

Thanks,

Ryan

photo
1

Hi Ryan,

Thank you again.

In our case, we have another VM in different host for the new YF 7.4 while the current YF 7.3 is still running on the old server in a different host. We will be using the same Server, same SQL instance where the YF 7.3 is running. We have performance issues with the current setup. We plan to create a new Report_database for YF 7.4 to ETL data from the Production DB which is also in the same instance.

Can I seek your opinion on this please?

We are already in contact with YF to issue us another license key but have not receive a reply yet. Will post update here once we commence the upgrade.

Your help is so appreciated.


Kindest regards,


Pearlsia.

photo
1

Hi Pearlsia,

Happy to help! In regards to your last questions, this is something traditionally handled by our Consulting team. Your Account Manager would be able to facilitate this type of interaction.

On a broad statement, if you're experiencing performance issues please verify your JVM Max Memory setting. This can be seen by visiting http://<YourYellowfinURL>/info.jsp in the browser and searching for JVM Max Memory. The default is 1GB, however the recommended minimum is 4 GB. It's possible this was overlooked during initial installation. If so, you can update this using this process.

Under typical loads, the Yellowfin Configuration Database should be fairly inconsequential to system performance (provided the network connection is stable). If you're experiencing long-running report times this can be due to a number of things. As stated before, for items such as this Consulting is well equipped to assist.

Let me know if you have any further questions.

Thanks,

Ryan

photo
1

Hi Ryan,

Thanks a lot for your help here! really gave me more things to consider on this migration/upgrade.

Kudos!


Kindest regards,


Pearlsia.

photo
1

Hi Pearlsia,

No problem! I'll go ahead and mark this answered, however don't hesitate to reach out if you encounter any issues or have further questions.

Thanks,

Ryan

photo