Install & Configure the Database

1. Download & Extract the Apache VCL Source

   1. If you have not already done so, download and the Apache VCL source to the database server:

      Tip
      wget http://www.apache.org/dist/incubator/vcl/apache-VCL-2.2.1-incubating.tar.bz2

   2. Extract the files:

      Tip
      tar -jxvf apache-VCL-2.2.1-incubating.tar.bz2

2. Install MySQL Server

   1. Install MySQL Server 5.x:

      Tip
      yum install mysql-server -y

   2. Configure the MySQL daemon (mysqld) to start automatically:

      Tip
      /sbin/chkconfig --level 345 mysqld on

   3. Start the MySQL daemon:

      Tip
      /sbin/service mysqld start

   4. Make sure the firewall on the database server is configured to allow traffic from the web server and management node servers to connect to the MySQL daemon TCP port: 3306.  See the firewall documentation for more information.

      Info
      man iptables

3. Create the VCL Database

   1. Run the MySQL command-line client:

      Tip
      mysql

   2. Create a database:

      Tip
      CREATE DATABASE vcl;

   3. Create a user with SELECT, INSERT, UPDATE, and DELETE privileges on the database you just created:

      Note
      Replace vcluser and vcluserpassword with that of the user you want to use to connect to the database

      Tip
      GRANT SELECT,INSERT,UPDATE,DELETE ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

   4. Exit the MySQL command-line client:

      Tip
      exit

   5. Import the vcl.sql file into the database:

      Info
      The vcl.sql file is included in the mysql directory within the Apache VCL source code

      Tip
      mysql vcl < apache-VCL-2.2.1-incubating/mysql/vcl.sql

      
      

...