HP OpenSource ブループリント

Size: px

Start display at page:

Download "HP OpenSource ブループリント"

ただきよさどひら
5 years ago
Views:

1 HP OpenSource Blue Print MySQL Enterprise Server 5.0 Red Hat Enterprise Linux 3 tar.gz ver 1.1 1

2 MySQL Red Hat Enterprise Linux 3 MySQL Community Server Enterprise Server 2 MySQL Enterprise Server MySQL Enterprise Server MySQL MySQL Red Hat Enterprise Linux3 1 MySQL 2 MySQL MySQL 3 MySQL tar.gz MySQL 4 HP Smart Array 2

3 MySQL MySQL OS tar MySQL MySQL MySQL Appendix1 : Appendix2 : HP Smart

4 1. MySQL 3 tar.gz rpm tar.gz MySQL 1 MySQL ) rpm ) MySQL MySQL ( ) 1 MySQL ) MySQL Enterprise MySQL Enterprise 2. MySQL MySQL MySQL Enterprise 1 MySQL Enterprise ( Address Password) 4

5 1 MySQL Enterprise 5

2 MySQL Enterprise Home 2 MySQL Enterprise Home Enterprise Software MySQL MySQL Red Hat Enterprise Linux 3 AS Update8 (x86, 32-bit) tar.gz Linux TAR(x86, dynamic glibc-2.

6 2 MySQL Enterprise Home 2 MySQL Enterprise Home Enterprise Software MySQL MySQL Red Hat Enterprise Linux 3 AS Update8 (x86, 32-bit) tar.gz Linux TAR(x86, dynamic glibc-2.3) mysql-enterprise-gpl linux-i686- glibc23.tar.gz /tmp 3. MySQL MySQL tar.gz tar.gz MySQL OS MySQL # rpm -qa grep mysql OS msql # rpm -qa grep mysql xargs rpm -e 3.1. OS MySQL OS 'mysql' mysql 'mysql' $ su 6

7 # /usr/sbin/groupadd mysql # /usr/sbin/useradd -g mysql mysql # passwd mysql ( ) 3.2. tar tar /usr/local tar.gz # cd /usr/local/ # tar xvzf /tmp/mysql-enterprise-gpl linux-i686-glibc23.tar.gz # chown -R mysql:mysql mysql-enterprise-gpl linux-i686-glibc23/ # ln -s mysql-enterprise-gpl linux-i686-glibc23 mysql MySQL /usr/local/mysql Owner MySQL OS (mysql) chown tar mysql-enterprise-gpl linux-i686-glibc23 tar bin data docs include lib scripts share sql-bench mysql, Change 3.3. MySQL (/etc/my.cnf) MySQL # cd /usr/local/mysql # cp./support-files/my-huge.cnf /etc/my.cnf # chown mysql:mysql /etc/my.cnf # chmod 644 /etc/my.cnf my-hoge.cnf 1G 2Gbyte (my-large.cnf, my-medium.cnf ) 3.4. MySQL # cd /usr/local/mysql #./scripts/mysql_install_db --user=mysql Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER! To do so, start the server, then issue the following commands:./bin/mysqladmin -u root password 'new-password'./bin/mysqladmin -u root -h dl380g4node1 password 'new-password' See the manual for more instructions. 7

8 You can start the MySQL daemon with: cd. ;./bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the./bin/mysqlbug script! The latest information about MySQL is available on the web at Support MySQL by buying support/lic./senses at tar.gz mysql_install_db MySQL (/usr/local/mysql) 3.5. MySQL MySQL # cd /usr/local/mysql #./bin/mysqld_safe --user=mysql & Starting mysqld daemon with databases from /usr/local/mysql/data 3.6. MySQL #./bin/mysqladmin ping mysqld is alive mysqld is alive MySQL 3.7. MySQL # /usr/local/mysql/bin/mysql -u root mysql> use mysql; mysql> select host, user, password from user; host user password localhost localhost root host1 host1 root rows in set (0.03 sec) mysql> delete from user where user = '' or host='host1'; Query OK, 3 rows affected (0.01 sec) mysql> set password for 'root'@'localhost' = password('root_password'); Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'root'@'%' identified by 8

9 mysql> 'root_password' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> select host, user from user; host user password localhost root *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 % root *97E3CA0A0B E6ECCD76C473CCA8757F rows in set (0.00 sec) mysql> quit root@localhost mysql> delete from user where user='root' and host='%'; mysql> grant all privileges on *.* to 'root'@'hostname' identified by 'dbpassword'; mysql> select host, user, password from user; host user password localhost root *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 admin_host root *2AF14BD74D8A4FDB580D3208C0092BE75EE95B hostname dbpass root 3.8. MySQL # mysqladmin version MySQL # mysqladmin version mysqladmin Ver 8.41 Distrib , for pc-linux-gnu on i686 Copyright (C) MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version enterprise-gpl Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 hours 35 min 32 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg:

10 4. MySQL 4.1. MySQL mysql mydb root MySQL mydb cp932 # mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: enterprise-gpl MySQL Enterprise Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE mydb CHARACTER SET cp932; Query OK, 1 row affected (0.00 sec) 4.2. mydb mydbuser mydbpass mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'mydbuser'@'localhost' -> IDENTIFIED BY 'mydbpass'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'mydbuser'@'%' -> IDENTIFIED BY 'mydbpass'; Query OK, 0 rows affected (0.00 sec) localhost mydb Table mydbuser mydbuser mydb Table 4.3. mydb mytable mysql> USE mydb Database changed mysql> CREATE TABLE mytable -> ( -> id INT NOT NULL AUTO_INCREMENT, -> last_name CHAR(30) NOT NULL, -> first_name CHAR(30) NOT NULL, -> PRIMARY KEY (id) -> ); Query OK, 0 rows affected (0.00 sec) 4.4. mytable mysql> INSERT INTO mytable (last_name, first_name) -> VALUES ('Hewlett','Bill'),('Packard','Dave'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 10

11 mysql> SELECT * FROM mytable; id last_name first_name Hewlett Bill 2 Packard Dave rows in set (0.00 sec) 11

Appendix1 : MySQL (/usr/local/mysql)./data 1. /dev/cciss/c0d1p1 Appendix2 2. # mount /dev/cciss/c0d1p1 /mnt/mysql-data 3. # chown mysql:mysql /mnt/mysql-data # chmod 755 /mnt/mysql-data 4. /etc/my.

12 Appendix1 : MySQL (/usr/local/mysql)./data 1. /dev/cciss/c0d1p1 Appendix2 2. # mount /dev/cciss/c0d1p1 /mnt/mysql-data 3. # chown mysql:mysql /mnt/mysql-data # chmod 755 /mnt/mysql-data 4. /etc/my.cnf [mysqld] [mysqld] datadir = /mnt/mysql-data 5. # cd /usr/local/bin #./scripts/mysql_install_db --datadir=/mnt/mysql-data --user=mysql mysql /dev/cciss/c0d1p1 Appendix2 : HP Smart HP ProLiant RAID [F8] Rom Configuration for Arrays Utility RCAU RCAU [Create Logical Drive] 12

13 Tab RAID HP ProLiant 13

untitled

untitled HP OpenSource MySQL Server 5.0 Red Hat Enterprise Linux 4 ver 1.5 MySQL Red Hat Enterprise Linux 4 Super Smack Super Smac MySQL Super Smack RHEL4 1 2 MySQL SuperSmack SuperSmack 3 SuperSmack MySQL 4 MySQL