![]() This is mainly possible due to our high compatibility of OpenProject between the two versions as of now. Your installation will be unchanged for the regular user, and all data will be as-is. The migration with pgloader is safe when pointing to an empty PostgreSQL database you wish to migrate to. Will I lose any data during the migration? No. Packaged installation (RPM/DEB packages).Please select your installation type below to get to the respective instructions for your OpenProject installation: The version comes with additional scripts and helpers to perform the update. We suggest installing the upgrade to 9.0.0., and then perform the migrations. OpenProject provides detailed guides on how to perform the migration to PostgreSQL as part of 9.0 for all supported installations. Thanks to a community project called pgloader, it is very easy to convert a running MySQL installation of OpenProject to PostgreSQL without any data loss in a matter of seconds to minutes. This has resulted in some confusion and performance impacts for users who installed OpenProject with MySQL due to missing functionality or degraded performance. At the same time, the same standard-compliant SQL would often be optimized better by PostgreSQL DBMS, resulting in degraded performance in some edge cases for MySQL users.įor a while now, PostgreSQL has received increased importance such as in the full-text search functionality which simply does not exist on MySQL versions < 8.0., which is not available natively on major distributions we support. While this works great in Rails for basic functionality, advanced SQL support such as json(b), CTE, full text search functionality and other, often performance related improvements could not be used or required efforts to make compatible with both systems given the plethora of version differences in MySQL 5.6, 5.7 and above. For OpenProject, it has been difficult to make use of newer SQL features since we traditionally supported both PostgreSQL and MySQL with the same priority. ![]() Over the past years, SQL functionality in major DBMS such as PostgreSQL and MySQL have skyrocketed, but common SQL support is still stuck at old standards. This post will explain reasons and provide detailed guides on how to migrate safely without any loss of information. MySQL remains fully supported for the major branch of 9.x releases but may see removal starting in OpenProject 10 versions and above. Starting in OpenProject 9.0.0, OpenProject is deprecating support for MySQL and MariaDB variants in its community and enterprise editions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |