Replace mysql with MariaDB

This has been tested countless amount of times and it works with the Vesta Stack

1.) Setup the repo’s:

Debian 7:

CODE: SELECT ALL

sudo apt-get install python-software-properties

 

CODE: SELECT ALL

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

 

CODE: SELECT ALL

sudo add-apt-repository 'deb http://mirror.stshosting.co.uk/mariadb/repo/10.0/debian wheezy main'

Ubuntu 12.04:

CODE: SELECT ALL

sudo apt-get install python-software-properties

 

CODE: SELECT ALL

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db

 

CODE: SELECT ALL

sudo add-apt-repository 'deb http://mirror.stshosting.co.uk/mariadb/repo/10.0/ubuntu precise main'

Ubuntu 14.04:

CODE: SELECT ALL

sudo apt-get install software-properties-common

 

CODE: SELECT ALL

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db

 

CODE: SELECT ALL

sudo add-apt-repository 'deb http://mirror.stshosting.co.uk/mariadb/repo/10.0/ubuntu trusty main'

2.) Run the install (This will replace MySQL with MariaDB) You should backup data but its not essential as I did not lose any data after the install

CODE: SELECT ALL

sudo apt-get update

 

CODE: SELECT ALL

sudo apt-get install mariadb-server

3.) Reboot (To make sure everything starts nice and fresh)