Question
How to install and configure mariadb on centos
- Posted on September 9, 2019
- MariaDBUbuntu
Asked by Georgi Dimitrov
I’ve been trying to install MariaDB on my Ubuntu server to check it out. I want to see if my website’s performance actually is better but I have one concern, by installing MariaDB to not brake my website.
Can you guys help.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @Remdore,
Well, upgrading MySQL to MariaDB in this case is just installing MariaDB and stopping your MySQL service. Maybe it’ might seem strange but MariaDB is a “drop-in” replacement for MySQL. The differences will increase with time, but as of now, there’s nothing to do, other than stopping MySQL and installing MariaDB.
Steps to install MariaDB
Make sure your package manager has access to MariaDB. Stop MySQL. Install MariaDB
On Ubuntu
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://suro.ubaya.ac.id/mariadb/repo/10.3/ubuntu bionic main'
sudo apt-get update
Stop MySQL
sudo service mysql stop
Now install MariaDB, which will be launched upon completion
apt install mariadb-server
That’s it. Have fun.
Kind regards, Kalin
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.