今年に入ってから、4回目のMySQLリリースです。
Changes in MySQL 5.6.19 (2014-05-30)
Changes in MySQL 5.6.18 (2014-04-11)
Changes in MySQL 5.6.17 (2014-03-27)
Changes in MySQL 5.6.16 (2014-01-31)

修正内容はInnoDB, Replication関連があります。
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-19.html

ダウンロードと展開

[root@HOME002 src]# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19-linux-glibc2.5-i686.tar.gz
--12:44:52--  http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19-linux-glibc2.5-i686.tar.gz
dev.mysql.com をDNSに問いあわせています... 137.254.60.11
dev.mysql.com|137.254.60.11|:80 に接続しています... 接続しました。
HTTP による接続要求を送信しました、応答を待っています... 302 Found
場所: http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19-linux-glibc2.5-i686.tar.gz [続く]
--12:44:52--  http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19-linux-glibc2.5-i686.tar.gz
cdn.mysql.com をDNSに問いあわせています... 23.207.104.96
cdn.mysql.com|23.207.104.96|:80 に接続しています... 接続しました。
HTTP による接続要求を送信しました、応答を待っています... 200 OK
長さ: 297157607 (283M) [application/x-tar-gz]
Saving to: `mysql-5.6.19-linux-glibc2.5-i686.tar.gz'

100%[=====================================================================================================>] 297,157,607  362K/s   in 10m 16s

12:55:08 (471 KB/s) - `mysql-5.6.19-linux-glibc2.5-i686.tar.gz' を保存しました [297157607/297157607]

FINISHED --12:55:08--
Downloaded: 1 files, 283M in 10m 16s (471 KB/s)
[root@HOME002 src]# ls -l
合計 290488
-rw-r--r-- 1 root root 297157607  5月  8 14:56 mysql-5.6.19-linux-glibc2.5-i686.tar.gz
[root@HOME002 src]# tar zxvf mysql-5.6.19-linux-glibc2.5-i686.tar.gz
mysql-5.6.19-linux-glibc2.5-i686/data/test/db.opt
mysql-5.6.19-linux-glibc2.5-i686/share/korean/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/dictionary.txt
mysql-5.6.19-linux-glibc2.5-i686/share/estonian/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/norwegian-ny/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/german/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/dutch/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/mysql_system_tables.sql
mysql-5.6.19-linux-glibc2.5-i686/share/aclocal/mysql.m4
mysql-5.6.19-linux-glibc2.5-i686/share/greek/errmsg.sys
mysql-5.6.19-linux-glibc2.5-i686/share/mysql_test_data_timezone.sql
mysql-5.6.19-linux-glibc2.5-i686/share/mysql_security_commands.sql
mysql-5.6.19-linux-glibc2.5-i686/share/swedish/errmsg.sys

省略......

mysql-5.6.19-linux-glibc2.5-i686/sql-bench/test-ATIS
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/test-create
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/server-cfg
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/innotest2b
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/test-big-tables
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/test-wisconsin
mysql-5.6.19-linux-glibc2.5-i686/sql-bench/bench-count-distinct
[root@HOME002 src]#
[root@HOME002 src]# mv mysql-5.6.19-linux-glibc2.5-i686 /usr/local/
[root@HOME002 src]# ls -l
合計 290488
-rw-r--r-- 1 root root 297157607  5月  8 14:56 mysql-5.6.19-linux-glibc2.5-i686.tar.gz
[root@HOME002 src]# cd /usr/local/
[root@HOME002 local]# ls -l
合計 132
drwxr-xr-x  2 root  root  4096  1月  8  2013 bin
drwxr-xr-x  2 root  root  4096  3月 30  2007 etc
drwxr-xr-x  2 root  root  4096  3月 30  2007 games
drwxr-xr-x  2 root  root  4096  1月  7  2013 include
drwxr-xr-x  3 root  root  4096  1月  7  2013 lib
drwxr-xr-x  2 root  root  4096  3月 30  2007 libexec
drwxr-xr-x  3 root  root  4096  1月  7  2013 man
lrwxrwxrwx  1 root  root    33  3月  1 13:43 mysql -> mysql-5.6.16-linux-glibc2.5-i686/
drwxr-xr-x 13 mysql mysql 4096  4月 28  2013 mysql-5.6.11-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  6月 22  2013 mysql-5.6.12-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  9月 14  2013 mysql-5.6.13-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096 11月  9  2013 mysql-5.6.14-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  3月  1 13:39 mysql-5.6.16-linux-glibc2.5-i686
drwxr-xr-x 13 root  root  4096  6月  1 12:58 mysql-5.6.19-linux-glibc2.5-i686
drwxr-xr-x  2 root  root  4096  3月 30  2007 sbin
drwxr-xr-x  5 root  root  4096  1月  7  2013 share
drwxr-xr-x  2 root  root  4096  6月  1 13:00 src
[root@HOME002 local]#

ファイル入れ替え前のDB停止とシステムテーブルアップグレード

[root@HOME002 local]# /etc/init.d/mysql stop
Shutting down MySQL...                                     [  OK  ]
[root@HOME002 local]# rm mysql
rm: remove シンボリックリンク `mysql'? y
[root@HOME002 local]#

[root@HOME002 local]# cp -rp /usr/local/mysql-5.6.16-linux-glibc2.5-i686/data/* /usr/local/mysql-5.6.19-linux-glibc2.5-i686/data/
cp: `/usr/local/mysql-5.6.19-linux-glibc2.5-i686/data/test/db.opt' を上書きしてもよろしいですか(yes/no)? y
[root@HOME002 local]#

[root@HOME002 local]# chown -R mysql:mysql mysql-5.6.19-linux-glibc2.5-i686/
[root@HOME002 local]# chmod 755 mysql-5.6.19-linux-glibc2.5-i686/

[root@HOME002 local]# ln -s mysql-5.6.19-linux-glibc2.5-i686/ mysql
[root@HOME002 local]# ls -l
合計 132
drwxr-xr-x  2 root  root  4096  1月  8  2013 bin
drwxr-xr-x  2 root  root  4096  3月 30  2007 etc
drwxr-xr-x  2 root  root  4096  3月 30  2007 games
drwxr-xr-x  2 root  root  4096  1月  7  2013 include
drwxr-xr-x  3 root  root  4096  1月  7  2013 lib
drwxr-xr-x  2 root  root  4096  3月 30  2007 libexec
drwxr-xr-x  3 root  root  4096  1月  7  2013 man
lrwxrwxrwx  1 root  root    33  6月  1 13:09 mysql -> mysql-5.6.19-linux-glibc2.5-i686/
drwxr-xr-x 13 mysql mysql 4096  4月 28  2013 mysql-5.6.11-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  6月 22  2013 mysql-5.6.12-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  9月 14  2013 mysql-5.6.13-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096 11月  9  2013 mysql-5.6.14-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  3月  1 13:39 mysql-5.6.16-linux-glibc2.5-i686
drwxr-xr-x 13 mysql mysql 4096  6月  1 12:58 mysql-5.6.19-linux-glibc2.5-i686
drwxr-xr-x  2 root  root  4096  3月 30  2007 sbin
drwxr-xr-x  5 root  root  4096  1月  7  2013 share
drwxr-xr-x  2 root  root  4096  6月  1 13:00 src
[root@HOME002 local]#



[root@HOME002 local]# /etc/init.d/mysql start
Starting MySQL....                                         [  OK  ]
[root@HOME002 local]#

[root@HOME002 local]# /usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.6.19, for linux-glibc2.5 (i686) using  EditLine wrapper
[root@HOME002 local]#


[root@HOME002 bin]# pwd
/usr/local/mysql/bin
[root@HOME002 bin]# ./mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: ./mysql
Looking for 'mysqlcheck' as: ./mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
test.TABLE001                                      OK
test.timestamp_chk                                 OK
test.timestamp_chk2                                OK
OK
[root@HOME002 bin]#

基本的な確認とレプリケーションの修正

[root@HOME002 local]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.6.19-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select @@version;
+------------+
| @@version  |
+------------+
| 5.6.19-log |
+------------+
1 row in set (0.00 sec)

mysql>


mysql> stop slave;
Query OK, 0 rows affected (0.07 sec)

mysql> CHANGE MASTER TO MASTER_HOST = 'home001', master_port=3306, MASTER_LOG_FILE = 'mysql-bin.000037', MASTER_LOG_POS = 120;
Query OK, 0 rows affected (0.17 sec)

mysql> start slave;
Query OK, 0 rows affected (0.07 sec)

mysql>

※ マスター側での確認してスレーブの開始ポジションを設定


mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000037 |      120 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

mysql>

※レプリケーション再開後にデータ確認
マスター側


mysql> select @@hostname;
+---------------------+
| @@hostname          |
+---------------------+
| HOME001.localdomain |
+---------------------+
1 row in set (0.00 sec)

mysql>

mysql> insert into TABLE001(title,comment) values('after-upgrade','Master MYSQL is upgraded to 5.6.19.');
Query OK, 1 row affected (0.39 sec)

mysql> select * from TABLE001 order by id desc limit 0,1;
+----+---------------+-------------------------------------+
| id | title         | comment                             |
+----+---------------+-------------------------------------+
| 26 | after-upgrade | Master MYSQL is upgraded to 5.6.19. |
+----+---------------+-------------------------------------+
1 row in set (0.00 sec)

mysql>

※スレーブ側


mysql> select @@hostname;
+---------------------+
| @@hostname          |
+---------------------+
| HOME002.localdomain |
+---------------------+
1 row in set (0.00 sec)

mysql>

mysql> select * from TABLE001 order by id desc limit 0,1;
+----+---------------+-------------------------------------+
| id | title         | comment                             |
+----+---------------+-------------------------------------+
| 26 | after-upgrade | Master MYSQL is upgraded to 5.6.19. |
+----+---------------+-------------------------------------+
1 row in set (0.00 sec)

mysql>