Migrate from MySQL to MariaDB in Ubuntu

6,636 0
Summary

Many developers are migrating from MySQL to MariaDB, influenced by major open-source distributions adopting it and concerns regarding Oracle's management of MySQL. The migration process on Ubuntu is straightforward and uncomplicated. It primarily involves adding the MariaDB GPG key and repository to your system's `sources.list`, followed by updating apt and installing `mariadb-server`. Ubuntu automatically handles the uninstallation of MySQL, and there's no need to recompile PHP or reconfigure phpMyAdmin, ensuring a smooth transition with minimal impact on existing setups.

The biggest movement of escaping from MySQL in this century starts, openSUSE,Fedora and Arch have started to use MariaDB instead of MySQL as their default database. Many people also dislike the attitude of Oracle on MySQL, so it's reasonable to migrate from MySQL to MariaDB. The whole process is not complicated. Here we share the steps to migrate from MySQL to MariaDB in Ubuntu.

Installation procedure:

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db

Modify /etc/apt/sources.list, add:

# MariaDB 5.5 repository list - created 2013-04-08 14:44 UTC
# http://mariadb.org/mariadb/repositories/
deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian squeeze main
deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian squeeze main

Now we can start to install MariaDB

sudo apt-get update
sudo apt-get install mariadb-server

Ubuntu will automatically uninstall MySQL and install MariaDB. You don't need to recompile PHP, phpMyAdmin is also supported by default. There is no big impact after installing MariaDB.

Source : http://lunax.info/archives/3003.html

UBUNTU MYSQL MARIADB

  RELATED

  COMMENTS

0

No comment for this article.