As described in [1], the Matterhorn database scripts so far lacked most of the robustness and performance tuning that should go into every production SQL database setup. As of today, these adjustments have been made, both for MySQL and PostgreSQL.
At the same time, and especially having ideas like the market place in mind where 3rd party services may be using the same database for storage, I adjusted the table names so they would be prefixed with "mh_" and added consistency to the table's field names and types. Some of those changes were needed in order to be able to properly index and set up foreign key constraints. Because I know that a number of institutions are already piloting 1.4, and the updated codebase will no longer work with their database, I spent considerable amounts of time creating an update script from yesterday's version of the ddl scripts to the new database structure and attached them to the ticket [1]. If you have been using auto-ddl, the scripts may or may not work for you, and I recommend switching to the scripts asap since audo-ddl will get you nothing but the tables (no indices, almost no constraints). IMPORTANT This patch introduces quite a number of code changes, and just running the integration tests may not be enough to cover all code paths. I tested the ddl scripts as well as the old ddl scripts + update scripts both with MySQL and PostgreSQL and successfully ran the integration tests. Given how much time went into this (multiple days), I would welcome some return on investment by having other piloters review and test with their instance and either give it a thumbs up on list or file tickets. Do not expect anyone else to do the due diligence for you, running into database issues at production time is amongst the worst things that could possibly happen. Tobias [1] https://opencast.jira.com/browse/MH-9202 _______________________________________________ Matterhorn mailing list Matterhorn@opencastproject.org http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email matterhorn-unsubscr...@opencastproject.org _______________________________________________
