Upgrade MariaDB dari MySQL di Debian Wheezy

Mariadb

onta.uin-suka.ac.id (repo inta UIN Sunan Kalijaga) memasuki masa main tenis.

Job pertama : Upgrade database menggunakan MariaDB

1. Perbaharui gnupg

root@onta:~# gpg --keyserver keys.gnupg.net --recv-keys CBCB082A1BB943DB
gpg: requesting key 1BB943DB from hkp server keys.gnupg.net
gpg: key 1BB943DB: "MariaDB Package Signing Key <package-signing-key@mariadb.org>" not changed
gpg: Total number processed: 1
gpg:              unchanged: 1
root@onta:/home/tukang# gpg -a --export CBCB082A1BB943DB | apt-key add -
OK

2. Tambahkan repositori MariaDB (lokasi ID)

root@onta:~# echo "deb http://mariadb.biz.net.id//repo/10.0/debian wheezy main" >> /etc/apt/sources.list
root@onta:~# apt-get update && apt-get install mariadb-server

3. Install MariaDB

root@onta:~# apt-get install mariadb-client mariadb-server

Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  cpp-4.4 gcc gcc-4.4 gcc-4.7 libc-dev-bin libc6-dev libitm1 linux-libc-dev manpages-dev zlib1g-dev
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  libmariadbclient18 libmysqlclient18 mariadb-client-10.0 mariadb-client-core-10.0 mariadb-common mariadb-server-10.0
  mariadb-server-core-10.0
Suggested packages:
  tinyca mariadb-test
The following packages will be REMOVED:
  libmysqlclient-dev mysql-client-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5
The following NEW packages will be installed:
  libmariadbclient18 mariadb-client mariadb-client-10.0 mariadb-client-core-10.0 mariadb-common mariadb-server mariadb-server-10.0
  mariadb-server-core-10.0
The following packages will be upgraded:
  libmysqlclient18
1 upgraded, 8 newly installed, 5 to remove and 1 not upgraded.
Need to get 34.7 MB of archives.
After this operation, 24.3 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Fetched 34.7 MB in 6min 21s (91.0 kB/s)
Reading changelogs... Done
Preconfiguring packages ...
(Reading database ... 42786 files and directories currently installed.)
Removing libmysqlclient-dev ...
Removing mysql-server ...
Removing mysql-server-5.5 ...
[ ok ] Stopping MySQL database server: mysqld.
Removing mysql-client-5.5 ...
Removing mysql-server-core-5.5 ...
Processing triggers for man-db ...
Selecting previously unselected package mariadb-common.
(Reading database ... 42496 files and directories currently installed.)
Unpacking mariadb-common (from .../mariadb-common_10.0.6+maria-1~wheezy_all.deb) ...
Preparing to replace libmysqlclient18:i386 5.5.31+dfsg-0+wheezy1 (using .../libmysqlclient18_10.0.6+maria-1~wheezy_i386.deb) ...
Unpacking replacement libmysqlclient18 ...
Selecting previously unselected package libmariadbclient18.
Unpacking libmariadbclient18 (from .../libmariadbclient18_10.0.6+maria-1~wheezy_i386.deb) ...
Selecting previously unselected package mariadb-client-core-10.0.
Unpacking mariadb-client-core-10.0 (from .../mariadb-client-core-10.0_10.0.6+maria-1~wheezy_i386.deb) ...
Selecting previously unselected package mariadb-client-10.0.
Unpacking mariadb-client-10.0 (from .../mariadb-client-10.0_10.0.6+maria-1~wheezy_i386.deb) ...
Selecting previously unselected package mariadb-server-core-10.0.
Unpacking mariadb-server-core-10.0 (from .../mariadb-server-core-10.0_10.0.6+maria-1~wheezy_i386.deb) ...
Processing triggers for man-db ...
Setting up mariadb-common (10.0.6+maria-1~wheezy) ...
Selecting previously unselected package mariadb-server-10.0.
(Reading database ... 42633 files and directories currently installed.)
Unpacking mariadb-server-10.0 (from .../mariadb-server-10.0_10.0.6+maria-1~wheezy_i386.deb) ...
Selecting previously unselected package mariadb-client.
Unpacking mariadb-client (from .../mariadb-client_10.0.6+maria-1~wheezy_all.deb) ...
Selecting previously unselected package mariadb-server.
Unpacking mariadb-server (from .../mariadb-server_10.0.6+maria-1~wheezy_all.deb) ...
Processing triggers for man-db ...
Setting up libmysqlclient18 (10.0.6+maria-1~wheezy) ...
Setting up libmariadbclient18 (10.0.6+maria-1~wheezy) ...
Setting up mariadb-client-core-10.0 (10.0.6+maria-1~wheezy) ...
Setting up mariadb-client-10.0 (10.0.6+maria-1~wheezy) ...
Setting up mariadb-server-core-10.0 (10.0.6+maria-1~wheezy) ...
Setting up mariadb-server-10.0 (10.0.6+maria-1~wheezy) ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
Installing new version of config file /etc/init.d/mysql ...
[ ok ] Stopping MariaDB database server: mysqld.
[ ok ] Starting MariaDB database server: mysqld.
[info] Checking for corrupt, not cleanly closed and upgrade needing tables..
Setting up mariadb-client (10.0.6+maria-1~wheezy) ...
Setting up mariadb-server (10.0.6+maria-1~wheezy) ...

Selesai, tinggal menyesuaikan pengaturan wiki.
Udah itu ajah/

Referensi :
[0] https://mariadb.com/kb/en/how-can-i-upgrade-from-mysql-to-mariadb/
[1] https://downloads.mariadb.org/mariadb/repositories/

Regard
Tuan Pembual