Differences

This shows you the differences between two versions of the page.

Link to this comparison view

muster:9.0:migration_guide [2018/01/30 15:25]
127.0.0.1 external edit
muster:9.0:migration_guide [2018/04/11 10:44] (current)
admin [New database structure]
Line 7: Line 7:
 Muster 9 has a new databases schema either for the regular queue and history queue. It also includes a new database for the backups facilities, so be sure to create a new database for the backup if you are working on MySQL or SQL Server, no action is necessary if you're using the builtin Sqlite engine. Muster 9 also lets you use different database engines independently for the three end points. Have a look at the new Dispatcher configuration dialog for possible configurations. ​ Muster 9 has a new databases schema either for the regular queue and history queue. It also includes a new database for the backups facilities, so be sure to create a new database for the backup if you are working on MySQL or SQL Server, no action is necessary if you're using the builtin Sqlite engine. Muster 9 also lets you use different database engines independently for the three end points. Have a look at the new Dispatcher configuration dialog for possible configurations. ​
  
-**Also be aware that, Muster checks on startup the databases schema, so if you absolutely need to migrate the old queue data, be sure to make a snapshot of your previous databases and manually migrate to the new schema otherwise your data will be erased on the first startup. Instructions for schemas migration are DB dependant and are not automated at the moment.**+<del>**Also be aware that, Muster checks on startup the databases schema, so if you absolutely need to migrate the old queue data, be sure to make a snapshot of your previous databases and manually migrate to the new schema otherwise your data will be erased on the first startup. Instructions for schemas migration are DB dependant and are not automated at the moment.**</​del>​
  
-If you are querying the databases outside of Muster, also have a look at the [[ muster:9.0:​databases_structure|new ​databases ​schemas]]  ​to verify ​if you need to modify your queries.+Starting from Muster 9.0.2, databases ​from version 8.5+ can be automatically upgraded by Muster 9. Be sure to make a backup of the muster.db and muster_history.db files if you're running sqlite. If you're running Mysql or SQL Server, backup tables are created automatically.
  
 +If you are querying the databases outside of Muster, also have a look at the [[ muster:​9.0:​databases_structure|new databases schemas]] ​ to verify if you need to modify your queries.
 ===== New network ports ===== ===== New network ports =====