[clue-admin] Future Web Site

[Raymond DeRoo]

Dan--

> Why would MySQL have to be rewritten?  Why not go in a multi-master
> replication?  Traffic wouldn't be high enough to cause problems.  Yes
> you could lose out on an update due to higher latency.

I'm sorry I was not more clear. It is not MySQL that would need
rewriting, I'm no where near that talented, but rather Drupal's data
interface layer to MySQL, unless D7 has introduced separate threads for
read and write. If so that would simplify matters greatly. As for
reasons not to use master/master... there are plenty.

> As for MySQL performance, I have tuned the key and table caches so
> hopefully we aren't hitting NFS' inherent latency too hard.  Yes I/O
> can become a problem on a VPS.

table_open_cache wouldn't be relevant as we would be using the InnoDB
storage engine. The bigger concern is write performance and table
corruption due to locking issues with NFS. That's why it recommended if
one must use NFS it be do done via iscsi or some other block level device.

> I am not saying Drupal is the right answer but I am trying to not
> reinvent the wheel.  There was previous work for a drupal based site
> and I am trying to capitalize on that.

Sure, go for it. If it's not already well know, I'm not a Drupal fan.
I've made some good money doing Drupal/php/MySQL consulting, but that
doesn't mean I like it. :) However, if it is the tool of choice, and
it provides CLUE an current and up to date web, then I'll help support
it as best I can.

One reason I would like to not use Drupal is that it offers little in
skill building. There have been a few members who have noted difficultly
in finding employment. Though I could be wrong, I don't think there is
much call for Drupal CMS admins ( granted Drupal *programmers* are in
demand ). Where as if we choose to give the current website an overhual
and facelift it would be a good chance for those who wish to learn more about AJAX, CSS, html, jquery ( or other such library ). And for those who to to gain SA skills, let them find a monitoring solution, and work on system configuration.

> As for a distributed web site, this is a large technical hurdle.  I
> have a hard enough time making all my compute nodes play together
> well and they are connected through a single switch with low latency.
> It is an interesting project but far enough above my head I can't
> contribute much.

I work on this for my day job, so doing something similar ( yet different ) for CLUE would be fun. Though I would want others to work along side of me. I've watched DavidW be an army-of-one and have *NO* desire to follow in his footsteps.

> Finally, for a shell, I can offer that.  This VPS is mostly idle.
> I'll set up an account and forward you the details.  Is this an
> account to share or just something you would like to personally
> dabble with?

I'm very much against shared accounts, especially accounts with the power this one would need to be usefu. Then again, it is only needed if there are perfomance issues within the LAMP stack I can help trouble shoot, so I would hold off on making such a request until it is deemed necessary. At that point I would be happy to send you my public ssh key.

Raymond
Sent from my iPhone