By Alx on

Instalation:

  • Drupal 7.11-dev with one database (almost 600MB at this moment)
  • multi domains with DOMAIN module +
  • multilanguage with i18n module.

Using drupal for make portal for community of media monitoring of ads and announcements in newspapers for Balkan region
All of this are hosting on dedicated server at SiteGround.com
For less than 3 month we add more than 2000 newspapers in system with appr. 100.000 pages including 50-60.000 crops of ads and announcements.
We grow with new countries and expect for next few months this happen every month in system.
At this moment we don't have too many register (less than 500) users (and appr 7000 new users/month by google analytics) but until end of year expect to be 5-10.000 registar users as result of monitoring in more Balkan countries.

1.
We need solution or assist how to solve (or avoid) problem with Time to First Byte which usually are more than 10-15 sec. Sometimes comes even more than 30 sec.
We use to cache all even install Boost but we are not sure is it work even everything are configure as is.
Some sample of this problem you can see on follow Web Page Performance Test or http://www.webpagetest.org/result/120101_3D_2Q1Z7/
If Boost are solution we need professional advice to set up right boost

2.
Another problem when we add new node waiting time for saving are between 20 and 60 second. At same time works appr 10 people for input data but this should be much more in next period.
Need professional service to solve this

3.
Solr instalation
As we need upgrade search option need professional service to install Solr to work with Drupal installation.

4.
Need solution for http://drupal.org/node/1391206

These are just few requests.
We have more needs to upgrade in future like on-line synchronize 2 or more Drupal (domain-database) installatiion.
Replication of databases

Just give us Initial offers to support us with your professional services and we can start immediately.

⋅ Categories: Drupal 7.x

Comments

pjcdawkins’s picture

pjcdawkins commented

I can't offer paid work but here's some free advice, since your problems are similar to those I solved with my recent project.

It sounds like you have poorly configured web and database servers. The following are low-hanging fruit, which are worth checking:

  • Drupal's minimum cache lifetime should be set
  • Make sure Drupal's cron is not clearing your caches every 10 minutes or so - a module such as Ultimate Cron may help divide cron into separate tasks
  • APC should be installed and enabled
  • MySQL should be properly configured with a working query cache, and check other settings such as innodb_buffer_pool_size
  • If you have problems when there are many concurrent users, you might have a poorly configured web server. Check settings such as Apache's MaxClients, which should usually be much lower than the default for a Drupal install. Or, the server might just be too small!

Install the Devel module, and ideally PHP xhprof or similar, to find out why the site is performing slowly. You may be able to narrow it down to one rogue module, or find out that all your problems are in the database server (both of which are possibilities - there are many variables).

Boost should not be necessary, although other caching backends would help, particularly Memcache and Varnish.

On the front end, make sure Drupal's CSS+JS aggregation is enabled, set up something like Varnish to cache static non-SSL files/content in memory, and set the correct client caching headers via Varnish/Apache.