terça-feira, 8 de outubro de 2013

Mudando do MySQL 5.6 para 5.6 Percona

Original post: http://anothermysqldba.blogspot.com/2013/10/moving-from-mysql-56-to-percona-56.html

Percona 5.6 foi lançado recentemente (hoje cedo, no momento deste post). Então, como exemplo simples o que todos que é preciso para mover-se para este "drop em substituição?"

Oct 7 06:47 Percona-Server-56-debuginfo-5.6.13-rel61.0.461.rhel6.x86_64.rpm
Oct 7 06:47 Percona-Server-client-56-5.6.13-rel61.0.461.rhel6.x86_64.rpm
Oct 7 06:47 Percona-Server-devel-56-5.6.13-rel61.0.461.rhel6.x86_64.rpm
Oct 7 06:47 Percona-Server-server-56-5.6.13-rel61.0.461.rhel6.x86_64.rpm
Oct 7 06:47 Percona-Server-shared-56-5.6.13-rel61.0.461.rhel6.x86_64.rpm

Oct 7 06:47 Percona-Server-test-56-5.6.13-rel61.0.461.rhel6.x86_64.rpm
# rpm -qa | grep MySQL
MySQL-server-5.6.13-1.el6.x86_64
MySQL-devel-5.6.13-1.el6.x86_64
MySQL-shared-compat-5.6.13-1.el6.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
MySQL-client-5.6.13-1.el6.x86_64
MySQL-shared-5.6.13-1.el6.x86_64
MySQL-test-5.6.13-1.el6.x86_64


# rpm -Uhv *.rpm

Enquanto isso seria bom ser capaz de se mover a partir do MySQL para Percona com um comando tão simples, você terá conflitos se você tentou fazê-lo.

Percona-Server-server-56-5.6.13-rel61.0.461.rhel6.x86_64 conflicts with file from package MySQL-server-5.6.13-1.el6.x86_64

Então, em vez você tem que fazer o seguinte.

Você já deve ter cópias de segurança, mas apenas no caso de criar outro.

Um exemplo extremamente simples abaixo com Xtrabackup
innobackupex ./

  • Desligue o MySQL
  • Remover os pacotes
  • Instale Percona
  • Iniciar e se conectar.

# /etc/init.d/mysql stop
Shutting down MySQL.. [ OK ]

# rpm -e MySQL-server MySQL-devel MySQL-client MySQL-shared MySQL-test mysql-workbench-community

# rpm -ihv Percona-Server-*.rpm
Preparing... ####################################### [100%]
1:Percona-Server-shared-5################################### [ 17%]
2:Percona-Server-client-5#################################### [ 33%]
3:Percona-Server-server-5################################### [ 50%]
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
4:Percona-Server-test-56 ###################################### [ 67%]
5:Percona-Server-devel-56###################################### [ 83%]
6:Percona-Server-56-debug##################################### [100%]
[root@centos64 Percona]# /etc/init.d/m
mdmonitor memcached messagebus mysql mysqld
[root@centos64 Percona]# /etc/init.d/mysql start
Starting MySQL (Percona Server)............... [ OK ]

# mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"

# mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
# mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.13-56-log Percona Server (GPL), Release rel61.0, Revision 461

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Você agora está livre para explorar Percona 5.6.