How to Upgrade MySQL from 5.5 to 5.7

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04 https://www.linode.com/docs/databases/mysql/install-mysql-on-ubuntu-14-04 https://help.ubuntu.com/lts/serverguide/mysql.html https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade 1. The short version of the installation is simple: update your package index, install the mysql-server package, and then run the included security and database initialization scripts. MySQL 5.7: 3x Faster https://www.mysql.com/products/enterprise/database/ The latest version for Ubuntu 14.04 is 5.5 but you can always update to a later version later. However, […]

MySQL vs MariaDB

10 reasons to migrate to MariaDB (if still using MySQL) https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql MariaDB versus MySQL – Features https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/ MariaDB versus MySQL – Compatibility https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ MariaDB vs MySQL on Amazon’s AWS RDS http://cloudacademy.com/blog/mariadb-vs-mysql-aws-rds/ MariaDB 10.1 and MySQL 5.7 performance on commodity hardware https://mariadb.org/maria-10-1-mysql-5-7-commodity-hardware/

Install LAMP Stack on Ubuntu 14.04

DigitalOcean install reference https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04 assuming you have ubuntu already installed via virtualbox or direct install on pc: first, always do this on new ubuntu installs: $ sudo apt-get update $ sudo apt-get upgrade 1. Install apache server $ sudo apt-get install apache2 If installing on DigitalOcean, go to the ip address of the machine and […]

Vagrant, VirtualBox, Ubuntu 16.04 Setup

Setup Vagrant replace project with any name you wish. $ mkdir project $ cd project $ vagrant init ubuntu/xenial64 In text editor – Vagrantfile located within the ‘project’ folder, change config.vm.network “forwarded_port”, guest: 80, host: 8080 to: Change config.vm.network “forwarded_port”, guest: 80, host: 80 or Change config.vm.network “forwarded_port”, guest: 80, host: 8080 Also by using […]