Search

Hello, does anyone here currently use the D6 CacheRouter module on their site? If so, could you help test/refactor this patch (http://drupal.org/node/746610) to the CacheRouter module. The goal of the patch is to add a second layer of cache backup if your primary caching tier was unavailable. i.e you could have the Drupal db cache tables as a backup to memcache or apc, instead of defaulting to a "cache miss" scenario which could really hammer the database.

This discussion got me thinking...
http://groups.drupal.org/node/56438#comment-160418

So I decided to create some code that will auto add indexes to your CCK fields where there are none. Works for me (using MySQL), may not work for you. Also at the bottom is code to add indexes elsewhere in Drupal.
<?php
$ret = array();
// Add indexes to CCK fields
$result = db_query("SHOW TABLES LIKE 'content_%'");
while ($table = db_result($result)) {
if ($table == 'content_group') {
db_add_index($ret, 'content_group', 'weight', array('weight'));

I am building a couple of websites for a few departments in my university.
Each website will sit on the same server using a multisite configuration.

The hardware they have is this:

1 Server with 4GB Ram
2 ISCSI HDs

The software:

Windows
Apache
Drupal 6

What kind of solutions are possible in terms of load-balancing/scalability/clustering?
I would probably need to configure accordingly APC,Memcache and Boost.

Any ideas where to start? This is really not my specialty and the SysAdmin is an IIS guy so he has no idea what to do as well...

Many thanks!
Nimi.

I'm working on a unique problem right now with the relaunch of a high traffic site (2-5 million page views per day), and want to run an idea by the group. There is a specific singular landing page that will receive a significant amount of traffic from an external source, and each requested page would have a unique query parameter. Ex: /landing-page?uid=438474383487348?foo=bah.