Rédiger « OVH/VPC02/idneuf » ici.
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