How to install Drupal in a cluster
The goal of these instructions is to learn how to setup a master Drupal instance, with a local database, and the setup multiple slave Drupal instances that point back to the master's database so that all instances of Drupal show the same information at the same time.
This is useful if you have multiple application servers behind a load balancer but do not have the need for a high-availability setup.
These instructions were built using three virtualized instances of CentOS 5.5 running on Fedora 13 under QEMU. SELinux was activated at the QEMU level to provide secure virtualization.
The master server is running SELinux in enforcing mode and utilizes Apache (httpd), php, and MySQL to serve up Drupal.
The slave servers are running SELinux in enforcing mode and utilized Apache (httpd) and php to serve up Drupal.
Basically the trick to stand up slave servers and have them utilize the master's database. In this way each Drupal instance sees the same information at the same time. There are some additional setup requirements to do this on both the master and the slaves.
/usr/share/doc/drupal-*/drupal-README.fedora page on your system also has up-to-date instructions for your versions of Fedora and Drupal.
It is assumed that all servers are running SELinux and that the MySQL database was properly cleaned and hardened utilizing the mysql_secure_installation script. It is also assumed that IPTables has been modified to allow port 80 (httpd) and port 3306 (mysqld) through. It is highly recommended that port 3306 be secured to the specific IP addresses that will be connecting to the database. Opening up port 3306 to the world is inviting trouble.
Web and SQL server setup
- Switch to the root account. Enter the root password at the prompt.
- Install necessary packages:
yum shell > groupinstall 'Web Server' 'MySQL Database' > install drupal > run ts
- Edit '/etc/my.cnf'
bind-address=<server ip address>
- If you have not already done so, start the MySQL database server:
service mysqld start
- If you have not already done so, set up the MySQL database server's administrator account. First, provide a root password.
mysqladmin -u root password $PASSWORD
- Create a database for Drupal:
mysqladmin -u root -p create drupal
- Grant rights for a Drupal administrator on this database:
[root@publictest1 ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.1.41 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> GRANT ALL PRIVILEGES ON drupal.* TO drupaladmin@localhost IDENTIFIED BY 'DRUPAL_PASSWORD'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON drupal.* TO drupaladmin@<slave IP address> IDENTIFIED BY 'DRUPAL_PASSWORD'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> QUIT; ByeThe drupaladmin account and the DRUPAL_PASSWORD you used above are the ones you will use in Drupal's installation process shortly.
- Edit the
/etc/httpd/conf.d/drupal.conffile. If you are installing on the same system where you run your Web browser, uncomment the line below:
Allow from 127.0.0.1
If you are installing on a different system on your network, change the previous lines so they read as follows:
#Deny from All Allow from AllSave the file.
- Edit the
/usr/share/drupal/.htaccessfile. Uncomment the line below:
RewriteBase /drupalSave the file.
- If necessary, change your firewall settings to permit TCP port 80 (HTTP) traffic.
- Copy and change the permissions on the default settings file:
cp /etc/drupal/default/default.settings.php /etc/drupal/default/settings.php chmod 666 /etc/drupal/default/settings.php
- Allow httpd to access the settings.php
chcon -t httpd_sys_content_t '/etc/drupal/default/settings.php'
- Edit the
/etc/php.inifile to set the
date.timezonefor PHP on the system. Uncomment the line and insert your timezone, for example:
date.timezone = America/New_YorkIf you are unsure what to put here, look in the Drupal system's
/usr/share/zoneinfodirectory. You can use the relative name of a file in that directory for the timezone setting here.
- Start the Apache web server:
service httpd start
- Point your web browser at the system to be installed and follow the instructions on screen. When prompted for database information, remember to use the information for the drupal MySQL database you installed earlier. When the site asks for Drupal administrator account information later, you should use a different user name and passphrase.
- Remove write permissions from the settings file:
chmod 644 /etc/drupal/default/settings.php