https://homeproj.cesnet.cz/https://homeproj.cesnet.cz/httpauth-login/favicon.ico?16194486082017-10-10T16:16:37ZHomeproj: Redmine for CESNETMentat - Task #3752: Migration from MongoDB to PostgreSQLhttps://homeproj.cesnet.cz/issues/3752?journal_id=125302017-10-10T16:16:37ZPavel Káchaph@cesnet.cz
<ul></ul>Notes for future production migration:
<ul>
<li>both db engines on the same machine</li>
<li>user/group management + relevant data – can be migrated independently of event db
<ul>
<li>then management GUI</li>
<li>we will need migration script, which will allow reporter/statistician use Perl DB until also rewritten</li>
</ul>
</li>
<li>statistician
<ul>
<li>simple incremental conversion script from Mongo to PQ + GUI, which already looks into PQ</li>
<li>then statistician can be written in python, switched and conversion script ditched</li>
</ul>
</li>
<li>reporter
<ul>
<li>simple incremental conversion script from Mongo to PQ + GUI, which already looks into PQ</li>
<li>then reporter can be written in python, switched and conversion script ditched</li>
</ul>
</li>
<li>incoming events forked into both old (Mongo) storage and new (PQ) storage daemons (events go simultaneously into both DBs)
<ul>
<li>then GUI can be written independently</li>
</ul></li>
</ul> Mentat - Task #3752: Migration from MongoDB to PostgreSQLhttps://homeproj.cesnet.cz/issues/3752?journal_id=141962018-05-31T11:58:07ZJan Machjan.mach@cesnet.cz
<ul><li><strong>Related to</strong> <i><a class="issue tracker-5 status-5 priority-5 priority-high3 closed" href="/issues/3362">Task #3362</a>: Migrate Mentat system to new hardware</i> added</li></ul> Mentat - Task #3752: Migration from MongoDB to PostgreSQLhttps://homeproj.cesnet.cz/issues/3752?journal_id=146312018-07-27T09:19:05ZJan Machjan.mach@cesnet.cz
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Closed</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>On tuesday 24.7. 2018 we have successfully migrated our production instance of Mentat system to version of Mentat system that is completely written in Python and uses PostgreSQL as database backend. Therefore this task can be considered complete.</p> Mentat - Task #3752: Migration from MongoDB to PostgreSQLhttps://homeproj.cesnet.cz/issues/3752?journal_id=146632018-07-27T09:54:01ZJan Machjan.mach@cesnet.cz
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/2808">Bug #2808</a>: Python and batch_size constraint</i> added</li></ul>