# grep datadir /etc/my.cnf /etc/mysql/conf.d/001-basic-config.cnf /etc/my.cnf:datadir = /opt/mysql/dbdata1/test-q0 /etc/mysql/conf.d/001-basic-config.cnf:datadir = /opt/mysql/dbdata1/test-q0
# my_print_defaults server mysqld | grep datadir --datadir=/opt/mysql/dbdata1/test-q0 --datadir=/opt/mysql/dbdata1/test-q0
# yum -y install Percona-Server-server-55 Loaded plugins: downloadonly, fastestmirror, replace Loading mirror speeds from cached hostfile * base: mirror.cogentco.com * epel: mirror.symnds.com * extras: centos.someimage.com * ius: mirror.symnds.com * updates: mirror.umd.edu Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package Percona-Server-server-55.x86_64 0:5.5.32-rel31.0.549.rhel6 will be installed --> Processing Dependency: Percona-Server-shared-55 for package: Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 --> Processing Dependency: Percona-Server-client-55 for package: Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 --> Running transaction check ---> Package Percona-Server-client-55.x86_64 0:5.5.32-rel31.0.549.rhel6 will be installed ---> Package Percona-Server-shared-55.x86_64 0:5.5.32-rel31.0.549.rhel6 will be installed --> Finished Dependency Resolution
Dependencies Resolved
================================================================================ Package Arch Version Repository Size ================================================================================ Installing: Percona-Server-server-55 x86_64 5.5.32-rel31.0.549.rhel6 percona 15 M Installing for dependencies: Percona-Server-client-55 x86_64 5.5.32-rel31.0.549.rhel6 percona 6.3 M Percona-Server-shared-55 x86_64 5.5.32-rel31.0.549.rhel6 percona 647 k
Transaction Summary ================================================================================ Install 3 Package(s)
Total download size: 22 M Installed size: 97 M Downloading Packages: (1/3): Percona-Server-client-55-5.5.32-rel31.0.549.rhel6 | 6.3 MB 00:00 (2/3): Percona-Server-server-55-5.5.32-rel31.0.549.rhel6 | 15 MB 00:00 (3/3): Percona-Server-shared-55-5.5.32-rel31.0.549.rhel6 | 647 kB 00:00 -------------------------------------------------------------------------------- Total 17 MB/s | 22 MB 00:01 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : Percona-Server-shared-55-5.5.32-rel31.0.549.rhel6.x86_64 1/3 Installing : Percona-Server-client-55-5.5.32-rel31.0.549.rhel6.x86_64 2/3 Installing : Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 3/3 Non-fatal POSTIN scriptlet failure in rpm package Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 /var/tmp/rpm-tmp.gPgSse: line 105: [: /opt/mysql/dbdata1/test-q0: binary operator expected /var/tmp/rpm-tmp.gPgSse: line 124: [: /opt/mysql/dbdata1/test-q0: binary operator expected + '[' -x /usr/bin/my_print_defaults ']' ++ grep '^--datadir=' ++ /usr/bin/my_print_defaults server mysqld ++ sed -n s/--datadir=//p + mysql_datadir='/opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0' + '[' -z '/opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0' ']' + NEW_VERSION=5.5.32-rel31.0.549.rhel6 + STATUS_FILE='/opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER' + '[' -f /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER ']' /var/tmp/rpm-tmp.lAIITT: line 19: [: /opt/mysql/dbdata1/test-q0: binary operator expected + SERVER_TO_START= + '[' 1 -eq 1 ']' + '[' '!' -d /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0 ']' /var/tmp/rpm-tmp.lAIITT: line 29: [: /opt/mysql/dbdata1/test-q0: binary operator expected + '[' '!' -d /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/mysql ']' /var/tmp/rpm-tmp.lAIITT: line 31: [: /opt/mysql/dbdata1/test-q0: binary operator expected + echo 'MySQL RPM upgrade to version 5.5.32-rel31.0.549.rhel6' /var/tmp/rpm-tmp.lAIITT: line 35: /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER: No such file or directory + groupadd -r mysql + true + useradd -M -r -d /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0 -s /bin/bash -c 'MySQL server' -g mysql mysql + true + usermod -g mysql mysql + test '!' -e /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/mysql /var/tmp/rpm-tmp.lAIITT: line 56: test: /opt/mysql/dbdata1/test-q0: binary operator expected + '[' -x /sbin/chkconfig ']' + /sbin/chkconfig --add mysql + chown -R mysql:mysql /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0 + chmod -R og-rw /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/mysql chmod: cannot access `/opt/mysql/dbdata1/test-q0/mysql': No such file or directory + SETARGETDIR=/etc/selinux/targeted/src/policy + SEDOMPROG=/etc/selinux/targeted/src/policy/domains/program + SECONPROG=/etc/selinux/targeted/src/policy/file_contexts/program + '[' -f /etc/redhat-release ']' + grep -q 'Red Hat Enterprise Linux .. release 4' /etc/redhat-release + grep -q 'CentOS release 4' /etc/redhat-release + '[' -x sbin/restorecon ']' + sbin/restorecon -R var/lib/mysql + '[' '' = true ']' + echo 'Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.' Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit. + echo 'Run the following commands to create these functions:' Run the following commands to create these functions: + echo 'mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME '\''libfnv1a_udf.so'\''"' mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'" + echo 'mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME '\''libfnv_udf.so'\''"' mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'" + echo 'mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME '\''libmurmur_udf.so'\''"' mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'" + echo 'See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details' See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details ++ date + echo 'Upgrade/install finished at Wed Jul 17 22:32:33 UTC 2013' /var/tmp/rpm-tmp.lAIITT: line 145: /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER: No such file or directory + echo /var/tmp/rpm-tmp.lAIITT: line 146: /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER: No such file or directory + echo ===== /var/tmp/rpm-tmp.lAIITT: line 147: /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER: No such file or directory + STATUS_HISTORY='/opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_HISTORY' + cat /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER /var/tmp/rpm-tmp.lAIITT: line 149: /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_HISTORY: No such file or directory + mv -f /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER /opt/mysql/dbdata1/test-q0 /opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER-LAST mv: target `/opt/mysql/dbdata1/test-q0/RPM_UPGRADE_MARKER-LAST' is not a directory warning: %post(Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64) scriptlet failed, exit status 1 Verifying : Percona-Server-server-55-5.5.32-rel31.0.549.rhel6.x86_64 1/3 Verifying : Percona-Server-shared-55-5.5.32-rel31.0.549.rhel6.x86_64 2/3 Verifying : Percona-Server-client-55-5.5.32-rel31.0.549.rhel6.x86_64 3/3
Installed: Percona-Server-server-55.x86_64 0:5.5.32-rel31.0.549.rhel6
Dependency Installed: Percona-Server-client-55.x86_64 0:5.5.32-rel31.0.549.rhel6 Percona-Server-shared-55.x86_64 0:5.5.32-rel31.0.549.rhel6
Complete!
# grep datadir /etc/my.cnf /etc/mysql/ conf.d/ 001-basic- config. cnf dbdata1/ test-q0 conf.d/ 001-basic- config. cnf:datadir = /opt/mysql/ dbdata1/ test-q0
/etc/my.cnf:datadir = /opt/mysql/
/etc/mysql/
# my_print_defaults server mysqld | grep datadir /opt/mysql/ dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0
--datadir=
--datadir=
# yum -y install Percona- Server- server- 55 someimage. com Server- server- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6 will be installed Server- shared- 55 for package: Percona- Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 Server- client- 55 for package: Percona- Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 Server- client- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6 will be installed Server- shared- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6 will be installed
Loaded plugins: downloadonly, fastestmirror, replace
Loading mirror speeds from cached hostfile
* base: mirror.cogentco.com
* epel: mirror.symnds.com
* extras: centos.
* ius: mirror.symnds.com
* updates: mirror.umd.edu
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-
--> Processing Dependency: Percona-
--> Processing Dependency: Percona-
--> Running transaction check
---> Package Percona-
---> Package Percona-
--> Finished Dependency Resolution
Dependencies Resolved
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
Size ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= === Server- server- 55 x86_64 5.5.32- rel31.0. 549.rhel6 percona 15 M Server- client- 55 x86_64 5.5.32- rel31.0. 549.rhel6 percona 6.3 M Server- shared- 55 x86_64 5.5.32- rel31.0. 549.rhel6 percona 647 k
Package Arch Version Repository
=======
Installing:
Percona-
Installing for dependencies:
Percona-
Percona-
Transaction Summary ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
=======
Install 3 Package(s)
Total download size: 22 M Server- client- 55-5.5. 32-rel31. 0.549.rhel6 | 6.3 MB 00:00 Server- server- 55-5.5. 32-rel31. 0.549.rhel6 | 15 MB 00:00 Server- shared- 55-5.5. 32-rel31. 0.549.rhel6 | 647 kB 00:00 ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --- Server- shared- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 1/3 Server- client- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 2/3 Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 3/3 Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 rpm-tmp. gPgSse: line 105: [: /opt/mysql/ dbdata1/ test-q0: binary operator expected rpm-tmp. gPgSse: line 124: [: /opt/mysql/ dbdata1/ test-q0: binary operator expected my_print_ defaults ']' my_print_ defaults server mysqld '/opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0' dbdata1/ test-q0 dbdata1/ test-q0' ']' 5.5.32- rel31.0. 549.rhel6 FILE='/ opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ MARKER' dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ RPM_UPGRADE_ MARKER ']' rpm-tmp. lAIITT: line 19: [: /opt/mysql/ dbdata1/ test-q0: binary operator expected dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0 ']' rpm-tmp. lAIITT: line 29: [: /opt/mysql/ dbdata1/ test-q0: binary operator expected dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ mysql ']' rpm-tmp. lAIITT: line 31: [: /opt/mysql/ dbdata1/ test-q0: binary operator expected rel31.0. 549.rhel6' rpm-tmp. lAIITT: line 35: /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ MARKER: No such file or directory dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0 -s /bin/bash -c 'MySQL server' -g mysql mysql dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ mysql rpm-tmp. lAIITT: line 56: test: /opt/mysql/ dbdata1/ test-q0: binary operator expected dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ mysql dbdata1/ test-q0/ mysql': No such file or directory /etc/selinux/ targeted/ src/policy /etc/selinux/ targeted/ src/policy/ domains/ program /etc/selinux/ targeted/ src/policy/ file_contexts/ program udf.so' \''"' udf.so' \''"' udf.so' \''"' code.google. com/p/maatkit/ source/ browse/ trunk/udf for more details' code.google. com/p/maatkit/ source/ browse/ trunk/udf for more details rpm-tmp. lAIITT: line 145: /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ MARKER: No such file or directory rpm-tmp. lAIITT: line 146: /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ MARKER: No such file or directory rpm-tmp. lAIITT: line 147: /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ MARKER: No such file or directory HISTORY= '/opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ HISTORY' dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ RPM_UPGRADE_ MARKER rpm-tmp. lAIITT: line 149: /opt/mysql/ dbdata1/ test-q0 dbdata1/ test-q0/ RPM_UPGRADE_ HISTORY: No such file or directory dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ RPM_UPGRADE_ MARKER /opt/mysql/ dbdata1/ test-q0 /opt/mysql/ dbdata1/ test-q0/ RPM_UPGRADE_ MARKER- LAST dbdata1/ test-q0/ RPM_UPGRADE_ MARKER- LAST' is not a directory Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64) scriptlet failed, exit status 1 Server- server- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 1/3 Server- shared- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 2/3 Server- client- 55-5.5. 32-rel31. 0.549.rhel6. x86_64 3/3
Installed size: 97 M
Downloading Packages:
(1/3): Percona-
(2/3): Percona-
(3/3): Percona-
-------
Total 17 MB/s | 22 MB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : Percona-
Installing : Percona-
Installing : Percona-
Non-fatal POSTIN scriptlet failure in rpm package Percona-
/var/tmp/
/var/tmp/
+ '[' -x /usr/bin/
++ grep '^--datadir='
++ /usr/bin/
++ sed -n s/--datadir=//p
+ mysql_datadir=
/opt/mysql/
+ '[' -z '/opt/mysql/
/opt/mysql/
+ NEW_VERSION=
+ STATUS_
/opt/mysql/
+ '[' -f /opt/mysql/
/var/tmp/
+ SERVER_TO_START=
+ '[' 1 -eq 1 ']'
+ '[' '!' -d /opt/mysql/
/var/tmp/
+ '[' '!' -d /opt/mysql/
/var/tmp/
+ echo 'MySQL RPM upgrade to version 5.5.32-
/var/tmp/
/opt/mysql/
+ groupadd -r mysql
+ true
+ useradd -M -r -d /opt/mysql/
+ true
+ usermod -g mysql mysql
+ test '!' -e /opt/mysql/
/var/tmp/
+ '[' -x /sbin/chkconfig ']'
+ /sbin/chkconfig --add mysql
+ chown -R mysql:mysql /opt/mysql/
+ chmod -R og-rw /opt/mysql/
chmod: cannot access `/opt/mysql/
+ SETARGETDIR=
+ SEDOMPROG=
+ SECONPROG=
+ '[' -f /etc/redhat-release ']'
+ grep -q 'Red Hat Enterprise Linux .. release 4' /etc/redhat-release
+ grep -q 'CentOS release 4' /etc/redhat-release
+ '[' -x sbin/restorecon ']'
+ sbin/restorecon -R var/lib/mysql
+ '[' '' = true ']'
+ echo 'Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.'
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
+ echo 'Run the following commands to create these functions:'
Run the following commands to create these functions:
+ echo 'mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME '\''libfnv1a_
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
+ echo 'mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME '\''libfnv_
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
+ echo 'mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME '\''libmurmur_
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
+ echo 'See http://
See http://
++ date
+ echo 'Upgrade/install finished at Wed Jul 17 22:32:33 UTC 2013'
/var/tmp/
/opt/mysql/
+ echo
/var/tmp/
/opt/mysql/
+ echo =====
/var/tmp/
/opt/mysql/
+ STATUS_
/opt/mysql/
+ cat /opt/mysql/
/var/tmp/
/opt/mysql/
+ mv -f /opt/mysql/
mv: target `/opt/mysql/
warning: %post(Percona-
Verifying : Percona-
Verifying : Percona-
Verifying : Percona-
Installed: Server- server- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6
Percona-
Dependency Installed: Server- client- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6 Server- shared- 55.x86_ 64 0:5.5.32- rel31.0. 549.rhel6
Percona-
Percona-
Complete!