Update Mysql (MariaDB) 5.5 para 10.1 no CentOS 7

O upgrade é simples, mas como sempre, faça um backup full de suas bases de dados com o comando abaixo.

mysqldump -u root -ppassword --all-databases > /tmp/all-database.sql

1	mysqldump -u root -ppassword --all-databases > /tmp/all-database.sql

Mesmo assim faça uma cópia do diretório das bases por via das dúvidas (o paranóico) …

systemctl stop mysql
cp -a /var/lib/mysql/ /var/lib/mysql.bak

1 2	systemctl stop mysql cp -a /var/lib/mysql/ /var/lib/mysql.bak

Crie o arquivo MariaDB10.repo com o comando abaixo

vim /etc/yum.repos.d/MariaDB10.repo

1	vim /etc/yum.repos.d/MariaDB10.repo

Copie o conteúdo abaixo e cole no novo arquivo

# MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

# MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC

# http://mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.1/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

Salve e saia do arquivo e agora … update no MariaDB

yum update MariaDB-server MariaDB-client

1	yum update MariaDB-server MariaDB-client

Agora inicie o banco

systemctl start mariadb

1	systemctl start mariadb

Agora rode o comando para fazer o upgrade do Mysql

mysql_upgrade

1	mysql_upgrade

Deve retornar algo conforme abaixo

Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      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
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
test
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

Phase 1/7: Checking and upgrading mysql database

Processing databases

mysql

mysql.columns_priv OK

mysql.db OK

mysql.event OK

mysql.func OK

mysql.help_category OK

mysql.help_keyword OK

mysql.help_relation OK

mysql.help_topic OK

mysql.host OK

mysql.ndb_binlog_index OK

mysql.plugin OK

mysql.proc OK

mysql.procs_priv OK

mysql.proxies_priv OK

mysql.servers 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

Upgrading from a version before MariaDB-10.1

Phase 2/7: Installing used storage engines

Checking for tables with unknown storage engine

Phase 3/7: Fixing views

Phase 4/7: Running 'mysql_fix_privilege_tables'

Phase 5/7: Fixing table and database names

Phase 6/7: Checking and upgrading tables

Processing databases

information_schema

performance_schema

test

Phase 7/7: Running 'FLUSH PRIVILEGES'

Feito isso o Mysql está pronto.

Com a tagMariaDB, mysql

Monitoramento

Operação de TI

Infraestrutura

Cibersegurança

A SV.Net