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

A Principled Technologies test report 16

Red Hat Enterprise Linux 6: Performance advantages with an

open source software stack

sed –i 's/ LOAD DATA LOCAL INFILE/ LOAD DATA INFILE/' ${i}

done

3. Create the master data files for the tests on the Linux server; that is a 10GB DVD Store database for MySQL on

Linux:

cd /ds2

perl Install_DVDStore.pl

4. Copy the Linux master data files to a second directory and convert the files’ line endings from Linux to Windows

using the unix2dos program, which was installed earlier.

mkdir /ds2/win-data_files

cp –r /ds2/data_files /* /ds2/win-data_files

cd /ds2/win-data_files

for i in */*csv; do

echo Converting file $i

unix2dos –o $i

done

5. Bundle up the Windows data files for later use:

cd /ds2

zip –r win-data_files win-data_files

mkdir MySQL-GOLD

mv win-data_files.zip MySQL-GOLD

rm –rf win-data_files

6. Start the first MySQL instance and load the DVD Store data.

mysqld_safe --defaults-file=/mysql/my-01.cnf --basedir=/usr --user=mysql \

--datadir=/mysql/dat01 --socket=/mysql/log01/mysql.sock

sleep 10

cd /mysql/mysqlds2

sh mysqlds2_create_all.sh

7. Stop MySQL and copy its data and log file to the gold or master file location to speed resetting DVD Store to its

original state.

sh /mysql/MySQLstop

mkdir /ds2/TMP/MySQL-GOLD/dat/

mkdir /ds2/TMP/MySQL-GOLD/log

cp -rp /mysql/log01/* /ds2/TMP/MySQL-GOLD/log &

cp –rp /mysql/dat01/* /ds2/TMP/MySQL-GOLD/dat

8. Finally, copy the DVD Store Web and PHP files to the three web-root directories.

cd /ds2/mysqlds2/web/php5

cp dsnewcustomer.php.sp dsnewcustomer.php

cp index.html ds*.php ds*.inc /www/html01/ds2

cp index.html ds*.php ds*.inc /www/html02/ds2

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

Brak uwag

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