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.
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
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
once server is reboot login again to ssh and check maria version by
you will see something like : mysql Ver 15.1 Distrib 10.1.19-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2