= Drupal+HAProxy+MemCached = == Paquet necessaire == {{{ apt-get install apache2 haproxy php5 php5-gd php5-durl libssh2-php }}} == Config pour recuperer le X-Forward-For == {{{ sites/default/settings.php $conf['reverse_proxy'] = TRUE; $conf['reverse_proxy_addresses'] = array('10.242.1.194','10.242.1.195'); }}} == AutoSlave (repartition lecture/ecriture) == https://ftp.drupal.org/files/projects/autoslave-7.x-1.8.tar.gz {{{ cd /var/www/html/ cp -r sites/all/modules/autoslave/autoslave includes/database/ chown -R www-data:www-data includes/database/autoslave/ }}} {{{ $databases['default']['default'] = array ( 'driver' => 'autoslave', 'master' => array('master', 'autoslave'), // Fallback to slaves if master fails (read-only mode) 'slave' => array('autoslave', 'master'), // Fallback to master if slaves fail 'affected tables backend' => 'autoslave.affected_tables.memcache-db-accurate.inc', 'watchdog on shutdown' => TRUE, 'replication lag' => 2, ); $databases['default']['master'] = array ( 'database' => 'drupal', 'username' => 'auf', 'password' => 'XXXXXXXXXXXXXXXXXXXXXXX', 'host' => 'prod-db-master-idneuf', 'port' => '', 'driver' => 'mysql', 'prefix' => '', ); $databases['default']['autoslave'] = array ( 'database' => 'drupal', 'username' => 'haproxy_auf', 'password' => 'XXXXXXXXXXXXXXXXXXXXXX', 'host' => '127.0.0.1', 'port' => '', 'driver' => 'mysql', 'prefix' => '', 'readonly' => TRUE, // Required for system to enter "readonly" mode if master fails. 'tables' => array('sessions', 'semaphore', 'watchdog', 'users', 'history'), ); // Use locking that supports force master $conf['lock_inc'] = 'sites/all/modules/autoslave/memcache-lock.inc'; // Use AutoSlave transactional safe cache wrapper with a memcache backend $conf['cache_backends'][] = 'sites/all/modules/autoslave/autoslave.cache.inc'; $conf['cache_default_class'] = 'AutoslaveCache'; $conf['autoslave_cache_default_class'] = 'MemCacheDrupal'; }}} == Memcached == {{{ apt-get -y install php5-memcache memcached }}} Module DrupalĀ : https://ftp.drupal.org/files/projects/memcache-7.x-1.5.tar.gz