From Fedora Project Wiki

Revision as of 13:19, 19 June 2010 by Sparks (talk | contribs) (→‎Assumptions: Removed assumption about mysql_secure_installation and added a warning admon)

This page is a draft only
It is still under construction and content may change. Do not rely on the information on this page.

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 /usr/share/doc/drupal-*/drupal-README.fedora 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.

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

  1. Switch to the root account. Enter the root password at the prompt.
    su -
  2. Install necessary packages:
    yum shell
    > groupinstall 'Web Server' 'MySQL Database'
    > install drupal
    > run ts
  3. Secure the database
    mysql_secure_installation
    This script helps you properly setup the database.
  4. Edit '/etc/my.cnf'
    bind-address=<server ip address>
  5. If you have not already done so, start the MySQL database server:
    service mysqld start
  6. If you have not already done so, set up the MySQL database server's administrator account. First, provide a root password.
    Do not use root account password
    Do not provide the system administrator's password for your Linux system here. Use a different strong password, since this is a separate authentication for a MySQL user called "root."
    mysqladmin -u root password $PASSWORD
  7. Create a database for Drupal:
    mysqladmin -u root -p create drupal
    Database creation
    You will be prompted to enter the MySQL "root" password from the previous step.
  8. 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;
    Bye

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

    You should create an account for each server that will be attaching to the server.

Drupal setup

  1. Edit the /etc/httpd/conf.d/drupal.conf 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:

    #Deny from All
    Allow from All
    Save the file.
  2. Edit the /usr/share/drupal/.htaccess file. Uncomment the line below:
    RewriteBase /drupal
    Save the file.
  3. If necessary, change your firewall settings to permit TCP port 80 (HTTP) traffic.
  4. 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
  5. Allow httpd to access the settings.php
    chcon -t httpd_sys_content_t '/etc/drupal/default/settings.php'
  6. Edit the /etc/php.ini file to set the date.timezone 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 /usr/share/zoneinfo directory. You can use the relative name of a file in that directory for the timezone setting here.
  7. Start the Apache web server:
    service httpd start
  8. 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.
  9. Remove write permissions from the settings file:
    chmod 644 /etc/drupal/default/settings.php