https://forge.in2p3.fr/https://forge.in2p3.fr/favicon.ico?16780521162013-02-13T10:49:07ZIN2P3-ForgePipelet - Task #1178: writing mysql and postgre backendshttps://forge.in2p3.fr/issues/1178?journal_id=86492013-02-13T10:49:07ZBetoule Marcbetoule@lpnhe.in2p3.fr
<ul><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li></ul><p>The lack for concurrent access proves to be a real issue when the number of workers increase as it prevents completely access from the web when running.</p>
<p>In addition, it occurs that computing infrastructure do not provide any filesystem able to hold a database. As an exemple, CCIN2P3 filesystems accessible to users are all distant filesystems with significant latency. This induces a serious performance hit that prevents in practice the number of tasks to exceed a million. It would be interesting in such cases to have dabases hold by a distant and better suited server.</p>
<p>the mysql python backend support DB-API 2 as the sqlite3 backend so I guess it is not that a big work to write a new tracker backend for mysql.</p>
<p>mysql-python.sourceforge.net/</p>