This guide provides details on how to update your database with each new Kylo version. Kylo supports two ways to upgrade your database:
- Automatic upgrades
- Manual upgrades
1. Automatic Upgrades¶
By default Kylo is set up to automatically upgrade its database on Kylo services startup. As such, there isn’t anything specific an end user has to do. Just start Kylo services as normal and your database will be automatically upgraded to latest version if required.
2. Manual Upgrades¶
By default Kylo is set up to automatically upgrade its database. To manually upgrades your database:
- Turn off automatic database upgrades
- Generate update SQL script
- Run generated SQL manually on your database
2.1 Turn off automatic database upgrades¶
/opt/kylo/kylo-services/conf/application.properties if you don’t
want to automatically upgrade Kylo database. Also make sure your database connection properties are correct:
liquibase.enabled=false spring.datasource.url= spring.datasource.username= spring.datasource.password= spring.datasource.driverClassName=
2.2 Generate upgrade SQL script¶
Make sure that required database driver is on classpath in
/opt/kylo/kylo-services/lib directory and
This will generate database update SQL in your current directory called
This SQL script will contain all required SQL statements to update your database to next Kylo version.
2.3 Run generated SQL manually on your database¶
The process of executing
kylo-db-update-script.sql SQL script will differ for each database vendor.
Please consult documentation for your database on how to execute an SQL script.