http://localhost:8080/trac/ticket/671 <p> <strong>Issue &amp; background</strong> During work on <a class="closed ticket" href="http://localhost:8080/trac/ticket/610" title="defect: Aegir database intensive (migrate, clone, restore) tasks hang for larger ... (closed: fixed)">#610</a>, it was discovered that of a 1/4GB database dump for TN.org, ~80% (180Mb) of it was related to the Drupal 6 core Search module. </p> <p> It's worth noting <a class="ext-link" href="https://tech.transitionnetwork.org/trac/ticket/516#comment:3"><span class="icon">​</span>this</a> was <a class="ext-link" href="https://tech.transitionnetwork.org/trac/ticket/516#comment:6"><span class="icon">​</span>raised</a> when we migrated the site to the Puffin server in March 2013, but it's generally the case that the core Search module does not scale easily beyond a few thousand nodes. </p> <p> www.transitionnetwork.org has 23,803 nodes at time of writing -- this is probably approaching the sensible limit of the core module's capability. </p> <p> Note also, any future D7 or D8 version of the site would also hugely benefit from using Solr, so the server config part is time well spent. </p> <p> <strong>Proposed solution</strong> </p> <ol><li>Add the Apache Solr option to BOA, re-run the installer to get it installed and configured automatically. </li><li>Add the <a class="ext-link" href="https://drupal.org/project/apachesolr"><span class="icon">​</span>ApacheSolr module</a> and any related required modules to the TN D6 makefile -- it's not clear if the 6.x-3.x branch or 6.x-1.x branch is the right choice at present. </li><li>Build a new platform containing these modules, migrate a clone of STG to it. </li><li>Enable the modules, configure them, disable core Search. </li><li>Create a feature that wraps up config for Solr and required modules. Add to Git, add reference to feature to makefile </li><li>Test, tweak, repeat 3 &amp; 4 &amp; 5 as needed. </li><li>Migrate PROD to the new plaform, enabled feature, index site. </li></ol><p> This could be parked until D7/8 migration, or not... Ed's call. </p> en-us /trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg http://localhost:8080/trac/ticket/671 Trac 0.12.5 jim Sat, 11 Jan 2014 21:11:14 GMT http://localhost:8080/trac/ticket/671#comment:1 http://localhost:8080/trac/ticket/671#comment:1 <ul> <li><strong>hours</strong> changed from <em>0.0</em> to <em>0.2</em> </li> <li><strong>totalhours</strong> changed from <em>0.0</em> to <em>0.2</em> </li> </ul> Ticket ed Mon, 13 Jan 2014 14:48:41 GMT http://localhost:8080/trac/ticket/671#comment:2 http://localhost:8080/trac/ticket/671#comment:2 <p> Well spotted Jim; thanks. Park it for now - all big jobs (like this) are on hold; main focus for you - knowledge transfer and handover to the others. </p> Ticket