vestacp : how to replace mysql with mariadb

i have vestacp webpanel on my server along which mysql is running am thinking to replace mysql with mariadb , because of the awesome performance of mariadb , so how to can i remove mysql and install maraidb on my production server  without losing my database and other settings . Am using debian 8 64bit os.

Supporter Asked on December 1, 2016 in Software.
Add Comment
1 Answer(s)
Best answer

To purge mysql and install mariadb is easy on debian , just follow below steps

first install some tools by running


apt-get install software-properties-common

next add mariadb identification key repository


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

finally add repository , currently mariadb stable version is 10.1 , although you can check for new stable release on their site


add-apt-repository 'deb [arch=amd64,i386] http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb/repo/10.1/debian jessie main'

next update things before going to install maria


apt-get update

and finally time to install maria and during installation it will ask for root password , then type mysql old root password or if you have not changed mysql root password it will be same as your vestacp password so enter vestacp  password which will be your mysql root password by default , so  that when mariadb is installed then vestapcp will communicate with mariadb with that root account


apt-get install mariadb-server

once installation is done , you can reboot server by command


reboot

once server is reboot login again to ssh and check maria version by


mysql -V

you will see something like : mysql  Ver 15.1 Distrib 10.1.19-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

 

Supporter Answered on December 1, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.