Red Hat APPLICATION STACK 2.0 RELEASE Instrukcja Użytkownika Pobierz pdf (Strona 19)

A Principled Technologies test report 19

Red Hat Enterprise Linux 6: Performance advantages with an

open source software stack

# LOGGING #

log_queries_not_using_indexes = 1

log_error = C:\MySQL\logXYZZY\mysql-error.log

slow_query_log_file = C:\MySQL\log0XYZZY\mysql-slow.log

slow_query_log = 1

13. Change the MySQL port in the second and third MySQL configuration files from 3306 to 3307 and 3308,

respectively.

14. Change the MySQL data directory, datadir, in each of the new MySQL configuration files to

C:/MySQL/dat01/, C:/MySQL/dat02, C:/MySQL/dat03 for the first, second, and third instance,

respectively.

15. Create three services, one for each MySQL instance, from a command window:

mysqld --install MySQL01 --defaults-file="C:\MySQL\my-01.ini MySQL01"

mysqld --install MySQL02 --defaults-file="C:\MySQL\my-02.ini MySQL02"

mysqld --install MySQL03 --defaults-file="C:\MySQL\my-03.ini MySQL03"

16. Start the first MySQL instance:

sc start mysql01

17. Set the user password:

mysqladmin -S=c:\MySQL\log01\mysql.sock -uroot password Password1

18. Create one MySQL user with full permissions for the DVD Store workload by starting a mysql shell with the

command, mysql –uroot –pPassword1, and then entering the following commands:

grant all privileges on *.* to web@lamp001 identified by 'web';

grant all privileges on *.* to web@localhost identified by 'web';

grant all privileges on *.* to web@'%' identified by 'web';

grant all privileges on *.* to 'apache'@'localhost';

delete from mysql.user where User='';

19. Finally, stop the first instance:

sc stop mysql01

Installing and configuring DVD Store 2.1 on the Windows server

1. Extract the DVD Store software, ds21.tar.gz and ds21_mysql.tar.gz, to c:\DS2.

2. Copy the zip archive, win-data_files.zip, containing the DVD Store 10GB data files to the Windows server and

unzip into the directory c:\DS2.

3. Create the batch file, c:\DS2\mysqlds2\mysqlds2_create_all.bat, with this content:

cd c:\DS2\mysqlds2\build

echo "Build start:"

mysql -u web --password=web < mysqlds2_create_db.sql

mysql -u web --password=web < mysqlds2_create_ind.sql

mysql -u web --password=web < mysqlds2_create_sp.sql

echo "Build end:"

cd ..\load\cust

1 2 ... 14 15 16 17 18 19 20 21 22

Brak uwag

Red Hat APPLICATION STACK 2.0 RELEASE Instrukcja Użytkownika Strona 19