Skip to content

Instantly share code, notes, and snippets.

@oliverservin
Last active November 15, 2016 01:01
Show Gist options
  • Save oliverservin/b466ed056597958eacc0 to your computer and use it in GitHub Desktop.
Save oliverservin/b466ed056597958eacc0 to your computer and use it in GitHub Desktop.
How to Upgrade MySQL 5.5 to MariaDB 10.1 on Ubuntu 14.04 and ServerPilot
sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable
sudo invoke-rc.d apparmor restart
sudo replace log_slow_queries slow_query_log_file -- /etc/mysql/conf.d/mysqld_slow_log.cnf
sudo bash -c 'echo "slow_query_log = 1" >> /etc/mysql/conf.d/mysqld_slow_log.cnf'
sudo apt-get purge --assume-yes mysql-server mysql-server-5.5 mysql-server-core-5.5 mysql-client mysql-client-5.5 mysql-client-core-5.5
sudo apt-get autoremove --assume-yes
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] http://mariadb.mirror.anstey.ca/repo/10.1/ubuntu trusty main'
sudo apt-get update
sudo apt-get install --assume-yes mariadb-server
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment