Differences

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

Link to this comparison view

Both sides previous revision Previous revision
wiki:how_to_handle_a_bigger_and_bigger_oar_database [2016/06/29 14:17]
neyron [Option 1: reset the database]
wiki:how_to_handle_a_bigger_and_bigger_oar_database [2016/06/29 20:54] (current)
capitn [Option 1: reset the database]
Line 18: Line 18:
 This solution is fairly easy, but with the drawback of breaking history (e.g. job dependency if any), and forcing to stop running jobs and emptying queues (i.e. breaking the continuity of service). This solution is fairly easy, but with the drawback of breaking history (e.g. job dependency if any), and forcing to stop running jobs and emptying queues (i.e. breaking the continuity of service).
  
-It involves ​to following steps:+It involves ​the following steps:
   * initialize a new database using the oar-database tool   * initialize a new database using the oar-database tool
     * typically with the same credentials as the former one     * typically with the same credentials as the former one
Line 27: Line 27:
     * admission rules: data (rows) of the admission_rules table     * admission rules: data (rows) of the admission_rules table
   * make sure the cluster is empty of running jobs (you may use oarnodesetting --drain command)   * make sure the cluster is empty of running jobs (you may use oarnodesetting --drain command)
-  * empty the queues (waiting jobs): ask users to wait for the new database to be in service before submitting new jobs, an dedicated admission rule may help here)+  * empty the queues (waiting jobs): ask users to wait for the new database to be in service before submitting new jobs, dedicated admission rule may help here)
   * stop the oar-server   * stop the oar-server
   * change the database in use, in oar.conf (server and frontend)   * change the database in use, in oar.conf (server and frontend)
wiki/how_to_handle_a_bigger_and_bigger_oar_database.txt ยท Last modified: 2016/06/29 20:54 by capitn
Recent changes RSS feed GNU Free Documentation License 1.3 Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki