You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
How to install MySQL Server, create the VCL database, and import the VCL database schema
-
If you have not already done so, download and extract the source files on the database server:
% wget http://www.apache.org/dist/incubator/vcl/apache-VCL-2.2.1-incubating.tar.bz2
% tar -jxvf apache-VCL-2.2.1-incubating.tar.bz2
Install MySQL Server
- Install MySQL Server 5.x:
% yum install mysql-server -y
- Configure the MySQL daemon (mysqld) to start automatically:
% /sbin/chkconfig --level 345 mysqld on
% /sbin/service mysqld start
- 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. (man iptables)
Create the VCL Database
- Run the MySQL command-line client:
- Create a database:
- Create a user with SELECT, INSERT, UPDATE, and DELETE privileges on the database you just created:
IMPORTANT: Replace 'vcluserpassword' with your own password
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';
- Exit the MySQL command-line client:
- Import the vcl.sql file into the database:
Note: The vcl.sql file is included in the mysql directory within the Apache VCL source code
% mysql vcl < apache-VCL-2.2.1-incubating/mysql/vcl.sql
Next step: VCL 2.2.1 Web Code Installation