How to install Drupal in a cluster

Background
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.

The 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.

The page on your system also has up-to-date instructions for your versions of Fedora and Drupal.

Assumptions
It is assumed that all servers are running SELinux. It is also assumed that IPTables has been modified to allow port 80 (httpd) and port 3306 (mysqld) through.

Web and SQL server setup
 Switch to the root account. Enter the root password at the prompt. su - 

Install necessary packages: yum shell > groupinstall 'Web Server' 'MySQL Database' > install drupal > run ts 

Secure the database mysql_secure_installation

Edit '/etc/my.cnf' bind-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@ 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; Bye

The drupaladmin account and the DRUPAL_PASSWORD you used above are the ones you will use in Drupal's installation process shortly.

</li> </ol>

Drupal setup
<ol> Edit the file. 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: Allow from All Save the file.</li>
 * 1) Deny from All

Edit the file. Uncomment the line below: RewriteBase /drupal Save the file.</li>

If necessary, change your firewall settings to permit TCP port 80 (HTTP) traffic.</li>

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 </li>

Allow httpd to access the settings.php chcon -t httpd_sys_content_t '/etc/drupal/default/settings.php' </li>

Edit the file to set the   for PHP on the system. Uncomment the line and insert your timezone, for example: date.timezone = America/New_York If you are unsure what to put here, look in the Drupal system's directory. You can use the relative name of a file in that directory for the timezone setting here.</li>

Start the Apache web server: service httpd start </li>

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.</li>

Remove write permissions from the settings file: chmod 644 /etc/drupal/default/settings.php </li>

</ol>