morad rayyan’s blog

aggregation + convergence + design + distribution + identity + participation 
Filed under

drupal

 

Managing multiple instances of Drupal with Aegir ~ Video tutorial

This is a promising framework, which will allow you to easily install multiple instances on the fly and manage them with a click. Managing includes, upgrading modules and sites settings.

This is a must try.

Filed under  //   drupal   tutorial  

Comments [1]

Introducing Managing News 3 video

Didn't know that there was version 1 & 2. But anyway, this is a total plus like what I've mentioned in my earlier post.

This video should explain to you on how to use managing news for your own purposes... enjoy!

Filed under  //   drupal   tutorial  

Comments [0]

Moving forward with Drupal development

Currently, I am working on a large scale project based on Drupal framework for the first time. And as much as I thought I've mastered working with drupal, I find myself with more challenges.

This time, the challenge was Views. Unfortunatelly, Views does not offer the flexibility to amend changes to its SQL queries which can be devastating sometimes. One of my tasks was to display a list of users who have recently published in a certain category, and the list of users needs to be unique.

With that, I found the best way is to utilize THEME_views_pre_execute(&$views) function, which allows me to manipulate with the SQL query to my own liking in my custom module, which worked wonderfully.

And here is another script that you can put in your block that will fetch result from the database, here it is:

  $sql = "";
  $output = '';
  $nlimit = 5;
  $result = db_query_range(db_rewrite_sql($sql), $uid, 0, $nlimit);
  $output .= '<div class="item-list"><ul>' . "\n";
  $output .= node_title_list($result);
  $output .= '</ul></div>';


  print $output;


Anyway, I am merely posting this as a future reference for myself.

Filed under  //   drupal  

Comments [0]

Drupal on Amazon cloud: How I did it.

Working on several projects with limited budget, it had made me think twice of how & where I should deploy those projects.

I've tried Rackspace cloud, used to be Mosso, both Sites & Server packages but nor of them offered the complete package I am looking for. Example, the server package seemed to be unstable and also it did not offer CDN service which I needed. As for Sites package, it did not offer SSH access, which totally killed it for me.

On top of all that, Rackspace cloud support was total disappointing and not mere close to the actual Rackspace managed hosting support.

So that's when my journey of looking at deploying Drupal on Amazon infrastructure has started. Thanks to this presentation that explains the benefits of cloud deployment:



And thanks to Dries blog post "Drupal in the cloud" that explained the benefits of hosting drupal instance on the cloud and the future of Amazon ec2 and such, that's when I've decided to give it a shot.

To get started, I had to choose between deploying a default AMI (OS image) that is provided by Amazon or community image called "Pantheon" which is prebuilt with latest drupal instance and its performance is 400% better than APC. Here is a link that demonstrates its performance.

So with image "Pantheon" being deployed on Amazon EC2, I've decided the best option is to host "Sites/All & Files" folders and "MySQL storage" on two Amazon Elastic Block Store (EBS). With that said, I followed this tutorial that move MySQL storage on the AMI instance to the EBS. And had my "Sites/All & Files" folders on the other block, then created a symlink on the AMI instance.

And voila! Now, I have a complete Drupal deployment with scalability worry-free.

Filed under  //   drupal  

Comments [0]