This afternoon I updated my Centos 6.3 VM and choose to drop the MySQL 5.1 and give the MariaDB fork a try. I’ve found several steps to do and some problems to take of – all of them described somewhere else. It may be useful for somebody doing the same upgrade to have my collection of tasks to do. <\/p>\n
So this is the starting point:<\/p>\n
and here it is how I did the upgrade:<\/p>\n
1. Stop mysql: Welcome to the MariaDB monitor. Commands end with ; or \\g. Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.<\/p>\n Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/code> Connection id: 59 Threads: 6 Questions: 2307 Slow queries: 0 Opens: 75 Flush tables: 1 Open tables: 50 Queries per second avg: 0.725 if you see a similar output your upgrade is complete.<\/p>\n","protected":false},"excerpt":{"rendered":" This afternoon I updated my Centos 6.3 VM and choose to drop the MySQL 5.1 and give the MariaDB fork a try. I’ve found several steps to do and some problems to take of – all of them described somewhere else. It may be useful for somebody doing the same upgrade to have my collection […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,3],"tags":[33,65,34,35],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-linux","category-software-development","tag-centos","tag-linux","tag-mariadb","tag-mysql"],"_links":{"self":[{"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=199"}],"version-history":[{"count":10,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":209,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=\/wp\/v2\/posts\/199\/revisions\/209"}],"wp:attachment":[{"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.johannes-beck.name\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\/etc\/init.d\/mysql stop<\/code>
\n2. Backup mysql database: mv \/var\/lib\/mysql \/var\/lib\/mysql.bak<\/code>
\nAlternatively you should do a backup of your databases with mysqldump.
\n3. Install the remi repo (if you are using a are different distro or arch<\/a>): rpm -Uvh http:\/\/rpms.famillecollet.com\/enterprise\/remi-release-6.rpm<\/code>
\nYou need to enable the repo manually.
\n4. Remove old phpmyadmin (which has no support for MariaDB): yum remove phpmyadmin <\/code>
\n5. Install current phpmyadmin (with MariaDB support): yum install phpMyAdmin<\/code>
\n6. Import PGP key for the mariadb repo: rpm --import https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/code>
\nThe id of the signing key is 0xcbcb082a1bb943db.
\nThe short form of the id is 0x1BB943DB and the full key fingerprint is 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB.
\n7. Create \/etc\/yum.repos.d\/mariadb.repo with the help of the repository-generator<\/a> at mariabb.org:
\n[mariadb]
\nname = MariaDB
\nbaseurl = http:\/\/yum.mariadb.org\/5.5\/centos6-x86
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\nenabled=1<\/code>
\nMore info<\/a>
\n8. install compat library: yum --enablerepo=remi-test --disablerepo=remi install compat-mysql55<\/code>
\n9. install MariaDB: yum install MariaDB-devel MariaDB-client MariaDB-server<\/code>
\nif you are running into problems with these two steps because of dependencies or conflicts, you may need to erase the mysql-libs manually: rpm -e --nodeps mysql-libs<\/code>
\n10. Restore mysql config in \/etc\/my.conf.d\/server.conf from \/etc\/my.cnf.rpmsave; in my case I readded these values:
\n[mysqld]
\nlog-error=\/var\/lib\/mysql\/mysqld.log
\nlog_warnings = 2
\nmax_allowed_packet = 32M
\ndefault-storage-engine=innodb<\/code>
\n11. If you had already a database, restore it before starting the database:
\nmv \/var\/lib\/mysql \/var\/lib\/mysql.new
\nmv \/var\/lib\/mysql.bak\/ \/var\/lib\/mysql<\/code>
\n12. start the mysql server: \/etc\/init.d\/mysql start<\/code>
\n13. upgrade the mysql database: mysql_upgrade<\/code>
\nIf you starting with a new database, set the root password:
\nmysqladmin -u root password '<PASSWORD>'
\nmysqladmin -u root -h
\n14. Login to mysql:
\nmysql<\/p>\n
\nYour MariaDB connection id is 60
\nServer version: 5.5.28a-MariaDB MariaDB Server<\/p>\n
\n15. Show status:
\n<status
\n--------------
\nmysql Ver 15.1 Distrib 5.5.28a-MariaDB, for Linux (i686) using readline 5.1<\/p>\n
\nCurrent database:
\nCurrent user: root@localhost
\nSSL: Not in use
\nCurrent pager: stdout
\nUsing outfile: ''
\nUsing delimiter: ;
\nServer: MariaDB
\nServer version: 5.5.28a-MariaDB MariaDB Server
\nProtocol version: 10
\nConnection: Localhost via UNIX socket
\nServer characterset: latin1
\nDb characterset: latin1
\nClient characterset: utf8
\nConn. characterset: utf8
\nUNIX socket: \/var\/lib\/mysql\/mysql.sock
\nUptime: 53 min 1 sec<\/p>\n
\n--------------<\/code><\/p>\n