Red Hat APPLICATION STACK 2.0 RELEASE Bedienungsanleitung PDF herunterladen (Seite 15)

A Principled Technologies test report 15

Red Hat Enterprise Linux 6: Performance advantages with an

open source software stack

# end of MySQLstop

for i in 01 02 03; do

mkdir /mysql/{dat,log}${i} >/dev/null 2>&1

chown mysql:mysql /mysql/dat* /mysql/log*

rm -rf /mysql/{dat,log}${i}/*

cp -rp /ds2/MySQL-GOLD/dat/* /mysql/dat${i} &

cp -rp /ds2/MySQL-GOLD/log/* /mysql/log${i} &

echo Restoring dataset $i

wait

done

# end of MySQLdata

5. Create the default MySQL database and user permissions for the first instance:

chown mysql:mysql /mysql/dat* /mysql/log*

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

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

6. Set the user password:

mysqladmin -S=/mysql/log01/mysql.sock -uroot password Password1

7. 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='';

Installing and configuring DVD Store 2.1 on the Linux server

Download the DVD Store 2.1 software from the Dell repository, http://linux.dell.com/dvdstore, to the Red Hat

Enterprise Linux server. The files needed are ds21.tar.gz and ds21_mysql.tar.gz. Create MySQL data files in CSV format

for both the Linux and Windows servers, as the file line endings differ.

1. Extract the DVD Store software to the /ds2 file system:

cd /ds2

tar zxf ds21.tar.gz

tar zxf ds21_mysql.tar.gz

2. Modify the database creation SQL scripts to load the data from the local file system, rather than through the

network.

cd /ds2/mysqlds2/build

mv mysqlds2_create_db.sql mysqlds2_create_db.sql-

sed 's/TYPE=/ENGINE=/g' < sql mysqlds2_create_db.sql- > sql mysqlds2_create_db.sql

cd /ds2/mysqlds2/load

for i in */*.sql; do

cp ${i} ${i}-orig

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

Kommentare zu diesen Handbüchern

Keine Kommentare

Red Hat APPLICATION STACK 2.0 RELEASE Bedienungsanleitung Seite 15

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Server Red Hat APPLICATION STACK 2.0 RELEASE