This group is dedicated to solutions and approaches for high traffic, high performing Drupal sites. As such, it will deal with a lot of information around the rest of a typical Drupal "stack" -- the operating system, web server, database, and PHP tweaks that combine to support the Drupal application.
This is not a support channel or a place to post bug reports.
If you think you have found a bug, use the issue queue for the appropriate project.
If you need support, see http://drupal.org/support for options.
Varnish Page Cache + Pressflow 6 IP Based Roles
So we use page level caching on our Pressflow 6 multisite installation and some of the sites use a module for IP based role assignment.
There is an issue with using page caching and IP based role assignment in which a user will get a cached page from Varnish despite having an IP that will give them an authenticated role.
Read moreAccess Denied, You are not authorized to access this page
I am going crazy because of this problem ... Become and you get a lot for no reason ...
I have this problem since several months have been circumvented by deleting www .... Noted after several days of normal operation of the website ... But in recent days has become a continuously and, more disturbingly ... when I add new node or edit node ... I normally logged I can add the node and after that I have to log-in again
I have had this problem and prevented me from entering the admin panel until I updated to latest version 6.22 but still happened to me
Regards,
Read moreDrupal Scalability and Performance training at SANDCamp 2012 on January 26, 2012
Join us at SANDcamp, the San Diego Drupal Camp, on Thursday, January 26, 2012 for a full day of scalability and performance training! This class is being offered at a 50% discount off our normal prices. Sign up today or contact us with any questions.
| Sign up today at http://www.larks.la/training |
In this all-day workshop, top experts with years of front-line experience building large-scale Drupal deployments show you the best known practices for running fast sites for a large volume of users. Starting with a blank Linux virtual server, we will work through the setup, configuration and tuning of Drupal using Varnish, Pressflow, Apache, MySQL, Memcache and Apache Solr.
Through this process, we will explain common pitfalls and how to avoid them. By the end of this course you should feel comfortable with the basics of how to setup, configure and tune your Drupal site. You’ll learn the most robust solutions the community has discovered.
Read moreWhich Linux flavour to choose?
Hi,
Found VPS provider for aegir instalation (up to 15 D6-D7 sites, 1/2 of them corporate brochure type), it will be openVZ with guaranteed 2048Mb RAM, mysql+php+apc+apache+smtp, and other basic services, maybe Apache Solr. Memcahed/Nginx/Varnish is a possibility if performance benefits over simple Boost module+APC are worth pain having another service on same vps.
Which linux to choose from this list:
CentOS 4
CentOS 5
CentOS 6
Debian 4
Debian 5
Debian 6
Fedora 14
Fedora 15
openSUSE 11.3
openSUSE 11.4
Ubuntu 10.04
Read more GlusterFS and Drupal 7 horizontal scaling
Prehaps someone can help me or at least point me in the right direction. If one needed to scale up a couple apache servers but share the docroot using a synchonized (common source) it seems glusterfs is a good solution. I have set up an experimental Glusterfs replicated system (2 instances, each both master and client) with linux (ubuntu), apache and php on them. Got Glusterfs working fine, however I am a little unclear how to "link" /var/www to the glusterfs client mount point (e.g. /mnt/point). Not sure how to bring drupal and Glusterfs together using "best practices."
Read moreDrupal on IIS 7.x Free Training at DrupalCon 2012
Hi Guys,
There will be a FREE full day training on Drupal on Windows at DrupalCon 2012 in Denver.
Topics will start from the basic deployment via WebPI on IIS 7.x and go up to the configuration of a full load balanced web farm using Application Request Routing!
There will be a lot of stuff indeed.
Attendance fees are sponsored by Microsoft and places are limited, so please register early! :-)
Here's the URL of the event at DrupalCon 2012
And here are some details:
Read moreapc instances by php-fpm pool
I'm in the process of moving a couple of sites to an Amazon ec2 microinstance. For the little traffic these sites get the microinstance will be suitable.
I am optimizing performance, and am using mod_fastcgi, php-fpm, and apc; along with varnish.
I have setup a separate fpm pool for each site, but they both appear to share the same apc instance, likely as apc is attached to the fpm process and not the pool.
Is there a method of using a separate apc instance per fpm pool? Or, can someone suggest a setup that is as performant, but which would allow for separate apc instances per site?
Read morevarnish + multiple webheads = files/(css/*.css|js/*.js) missing
I have this weird issue and I'm not sure if it's me who's doing something wrong or I'm just missing something but maybe some of you can guide me a little bit here...
i setup a varnish server, within varnish itself i created 2 backends and using director i'm able to do round robin to my webheads. That parts seems to be working fine as I'm able to bring one of my webheads down and the other one can serve content to varnish and vice verse.
Read moreHigh Performance Drupal meetup in Mar Vista on January 3, 2012
The High Performance Drupal meetup now meets on the 1st Tuesday of the month.
Interested in Pressflow, APC, Varnish and memcache? Want to jump from shared or "grid" hosting to VPS or dedicated hosting but aren't sure what to do? Do you just want to get more out of what you currently have and take your Drupal site to the next level?
Meet with friends, have coffee and talk about Drupal performance, scalability and DevOps on the Westside at the Venice Grind between 5-8pm on Tuesday, January 3, 2012. In the past, we've gone to dinner afterward at nearby restaurants including El Agave and Mitsuwa. You're invited!
To get last-minute updates, sign up by clicking the Signup button below or stay tuned to the comments on this page (or both!).
| When: 5pm to 8pm on Tuesday, January 3, 2012 |
| Where: Venice Grind at 12224 Venice Blvd, Los Angeles, CA 90066 |
MySQL optimization with uc_order_products
Hello,
I am working on site which has 13528 records in uc_order_products (from the ubercart 6 module).
Nid count is 5611.
To get the most purchased products, I have a query like below:
SELECT DISTINCT(node.nid) AS nid, uc_order_products.qty AS uc_order_products_qty FROM node LEFT JOIN uc_order_products ON node.nid = uc_order_products.nid WHERE (node.type in ('product')) AND (node.status <> 0) GROUP BY nid ORDER BY uc_order_products_qty DESC;However this causes our linode server with 1024 MB ram to crash so quickly.
By crash, I mean,
Read more



