
A Principled Technologies test report 18
Red Hat Enterprise Linux 6: Performance advantages with an
open source software stack
Using Microsoft Web Platform Installer (WPI) to install IIS, MySQL, and PHP on Microsoft
Windows Server 2008 R2
1. Download Microsoft WPI, wpilauncher_3_10, from http://www.microsoft.com/web/downloads/platform.aspx.
2. Launch the WPI program. Select the following applications to be installed: IIS 7 Recommended Configuration,
PHP 5.3.10, PHP Manager for IIS, and MySQL Windows 5.1. Click Install.
3. Make three copies of the PHP installation directory:
C:\Program Files (x86)\PHP\v5.3–01, C:\Program Files (x86)\PHP\v5.3–02, and C:\Program
Files (x86)\PHP\v5.3–03
4. Create three Web sites from the IIS manager: bind the first to 192.168.30.21:80, the second to 192.168.30.22:8,
and the third to 192.168.30.23:80.
5. Set their web root-spaces to c:\inetpub\webroot\ds2-01, c:\inetpub\webroot\ds2-02, and
c:\inetpub\webroot\ds2-03, respectively.
6. Open the PHP manager. Click Register new PHP version. Enter the path C:\Program Files
(x86)\PHP\v5.3–01. Repeat for C:\Program Files (x86)\PHP\v5.3–02 and C:\Program Files
(x86)\PHP\v5.3–03
7. Modify the PHP configuration file C:\Program Files (x86)\PHP\v5.3–01. For each row in the next table,
replace the line in the PHP configuration file (the entry in the left column) with the contents on the right:
error_reporting = E_ALL & ~E_DEPRECATED
error_reporting =
E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
mysql.default_port = 3306
mysql.default_port = 3306
mysql.default_host = localhost
mysql.default_password = web
mysqli.default_port = 3306
mysqli.default_port = 3306
8. Modify the remaining two PHP configuration files as in the previous step, but replacing the ports 3306 with 3307
and 3308, respectively.
9. Run the MySQL Instance Configurator, MySQLInstanceConfig, once to create the default configuration file and
database. Do not install the instance as a service yet.
10. Copy the default mysql-configuration file, C:\Program Files\MySQL\MySQL Server 5.1\my.ini, to C:\MySQL\my-
01.ini, C:\MySQL\my-02.ini, and C:\MySQL\my-03.ini
11. In each of the new MySQL configuration files, change the sql-mode from
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
12. In each of the new MySQL configuration files, append the following to the [mysqld] stanza, while changing XYZZY
to log01, log02 or log03 for the first, second, and third instances, respectively:
innodb_file_per_table = 1
ft_min_word_len = 3
ft_stopword_file =
Kommentare zu diesen Handbüchern