HP OpenSource Blue Print MySQL Enterprise Server 5.0 Red Hat Enterprise Linux 3 tar.gz ver 1.1 1
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
... 2... 2... 2... 3 1.... 4 2. MySQL... 4 3. MySQL... 6 3.1. OS... 6 3.2. tar... 7 3.3.... 7 3.4.... 7 3.5. MySQL... 8 3.6.... 8 3.7. MySQL... 8 3.8. MySQL... 9 4.... 10 4.1.... 10 4.2.... 10 4.3.... 10 4.4.... 10 Appendix1 :... 12 Appendix2 : HP Smart... 12 3
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 https://enterprise.mysql.com/ 1 MySQL Enterprise (Email Address Password) 4
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.3) mysql-enterprise-gpl-5.0.34-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
# /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-5.0.34-linux-i686-glibc23.tar.gz # chown -R mysql:mysql mysql-enterprise-gpl-5.0.34-linux-i686-glibc23/ # ln -s mysql-enterprise-gpl-5.0.34-linux-i686-glibc23 mysql MySQL /usr/local/mysql Owner MySQL OS (mysql) chown tar mysql-enterprise-gpl-5.0.34-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
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 http://www.mysql.com Support MySQL by buying support/lic./senses at http://shop.mysql.com 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 +-------------+------+----------+ 4 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
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 *97E3CA0A0B00371413E6ECCD76C473CCA8757F86 +-----------+------+-------------------------------------------+ 2 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 *2AF14BD74D8A4FDB580D3208C0092BE75EE95B75 +------------+------+-------------------------------------------+ hostname dbpass root 3.8. MySQL # mysqladmin version MySQL # mysqladmin version mysqladmin Ver 8.41 Distrib 5.0.34, for pc-linux-gnu on i686 Copyright (C) 2000-2006 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 5.0.34-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: 0.000 9
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: 5.0.34-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
mysql> SELECT * FROM mytable; +----+-----------+------------+ id last_name first_name +----+-----------+------------+ 1 Hewlett Bill 2 Packard Dave +----+-----------+------------+ 2 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.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
Tab RAID HP ProLiant http://h50146.www5.hp.com/doc/manual/proliant/storage.html#ac 13
03-5304-6660 9:00 19:00 10:00 18:00 Linux/ http://www.hp.com/jp/linux/ 2007 4 HP Copyright 2007 Hewlett-Packard Development Company,L.P. 102-0076 7 14