All geek questions in one place

Update / update from mariadb from 5.5 to 10

Recently, MariaDB 10 has become stable.

MySQL 5.6 features have been added to 10 releases. I need to use some new features, so I'm wondering:

Has anyone upgraded from MariaDB 5.5 to 10 on a production server? What is the upgrade path (just changing mariadb replication to 10 will work?)? Is the transition smooth?

+4
source share
3 answers

We recently went through this exact update, also on CentOS. We did not experience any problems with any of our databases, all using the InnoDB engine. I have included our internal update, this can save you some time and show you which way we took.

This guide assumes that you are using AMD64 versjon og CentOS 6.

Create a repo yum file for MariaDB and name it /etc/yum.repos.d/MariaDB.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

// The signing key value is 0x1BB943DB.

Delete the current MariaDB server and client. If yum was used to install them, use:

yum remove mysql MySQL-server MySQL-shared MySQL-shared-compat

This should remove all packages depending on MariaDB / MySQL and therefore you will need to reinstall php-mysql as described below. Any other packages depending on MySQL must also be reinstalled, so keep an eye out for this.

Install MariaDB

yum install MariaDB server MariaDB client

Reinstall PHP MySQL lib

yum install php-mysql

MariaDB, Apache

service mysql start  
mysql_upgrade 
service httpd restart

, , .

+3

5.5 10.0.12 . .

+ ----------------- + | @@version | + ----------------- + | 10.0.12-MariaDB |

. , CentOS, :

0

If you configured your root MySQL / MariaDB access with a password, you need to use the -p option if you want to use mysql_upgrade.

0
source

Source: https://habr.com/ru/post/1535363/

More articles:


All Articles