Ubuntu 16.04 - Install MariaDB 10.1

Run the command below install MariaDB 10.1 on Ubuntu 16.04: curl -s https://scripts.programster.org/scripts/16?output=raw | bash ... or copy, paste, and execute the following script: sudo apt update sudo apt install software-properties-common -y sudo apt-key adv --recv-keys --keyserver \ hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8…

Read this article

MariaDB Versions

I consider MariaDB as a "better alternative" to MySQL. Below is a list of MySQL versions and their "equivalent" MariaDB versions that one can migrate to. MySQL Version MariaDB Version 5.5 5.5 5.6 10.0 / 10.1 5.7 10.2? References What is MariaDB 10.0?…

Read this article

CentOS - Install MySQL Server

CentOS does not come with MySQL in the repositories. Instead it has switched over to MariaDB. The script below will install MariaDB 5.5 which is extremely similar to MySql 5.5. sudo yum install mariadb-server -y sudo systemctl start mariadb sudo systemctl enable mariadb mysql_secure_installation Now you…

Read this article

Ubuntu 14.04 - Install MariaDB 10.1

The following script will install MariaDB as an apt repository (for automatic updates), using DigitalOcean UK as a mirror. Go here if you want to use a different mirror. sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver \ hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db echo '# MariaDB 10.1 repository…

Read this article

MySQL Configuration Variables

This is an overview of MySQL variables that can be tweaked in the my.cnf file for MySQL 5.5 or 5.6. I will use MiB to denote values, but if you want to specify this in the configuration files, you would use M, also, you would use G…

Read this article

Debian 8 - Install MariaDB 10.1

You can run the script below to install MariaDB 10.1.x on Debian and receive updates. sudo apt-get install software-properties-common -y # Add the key so we trust packages from MariaDB sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db # Add the repo sudo add-apt-repository 'deb [arch=amd64,i386] http:…

Read this article