Manual update of database needed before changing newer docker image?s?

Joakim shared this question 8 months ago
Answered

Hello!

We plan to use the docker image for yellowfin (app only).

We will use a postgres database running in a separate container.

First time when we initialize the database, we will have to run the full jar installation I assume.

But if Yellowfin releases an update, will we then need to manually migrate/update the database using the update-jar, or will it be magically solved by the new docker image/container?

Best regards,

Joakim


PS. The tomcat in Yellowfin seems to contain critical vulnerabilities according to the scanner we use, any update on this?

Replies (5)

photo
1

Hello Joakim

Thank you for reaching out to the Yellowfin support.

We are currently reviewing this case. We will get back to you with the findings shortly.

Regards,

Siddhartha

photo
1

Hello Joakim

If a new Yellowfin release requires changes to the Database, then the updater would need to be run to completely upgrade the system and avoid any mismatch between the DB and the application. Having said this, the containers do not need to run the updater every time you deploy one. What I would recommend is using the updater on a separate machine (this does not need to be a docker container) which is used to upgrade just the database (this is based on the assumption that your database is not included in your docker image) and then deploy your dockers with the full jar for the same version.

To update just the database, have a look at this guide for the Patch Installer. You will see an example for updating the database only which looks similar to this:

java -jar yellowfin-20180402-update.jar -silent option.upgrade=database jdbcUser=yellowfin jdbcPassword=password jdbcURL=jdbc:mysql://localhost:3306/yellowfin_74_master
The Yellowfin wiki articles listed below relate with the docker image/container. (https://wiki.yellowfinbi.com/display/user80/Installer+Properties#InstallerProperties-SilentInstallerPropertiesFile)

(https://hub.docker.com/r/yellowfinbi/yellowfin-app-only)

(https://community.yellowfinbi.com/knowledge-base/article/configuring-yellowfin-for-containerization)

(https://wiki.yellowfinbi.com/display/yfcurrent/Upgrading+Yellowfin+Container+Deployment)

Please let me know if you have any more questions on this.


Regards

Siddhartha

photo
1

Hello Joakim

Greetings for the Day!

We would like to check, with you if you had the opportunity to read our last response.
Request, you to review and let us know if you have any questions or further assistance is required

Regards

Siddhartha

photo
1

Hello Siddhartha!

Thank you for your response, it matches our understanding. Thanks for confirming.

We have not had time to test it yet but this can be marked as answered!

Best regards,

photo
1

Hello Joakim

Thats a great news. Thank you very much for the confirmation. I will now go ahead and mark this case as completed. Feel free to reach out to us if you have any questions or concerns; we would be more than happy to assist you.

Have a great rest of your day!

Regards

Siddhartha

Leave a Comment
 
Attach a file