How To Set Up MySQL Master-Master Replication
This second installment of “Scaling Web Applications” will list out the steps necessary for scaling a mysql deployment over two VPS.
How To Work with JSON in MySQL
Learn how to use and query JSON data in your MySQL databases.
How to Connect to a MySQL Server Remotely with MySQL Workbench
Use MySQL Workbench to connect securely to your remote MySQL database using SSH.
Building for Production: Web Applications — Backups
In this part of the “Building for Production: Web Applications” series (4 of 6), we will set up the backup system that is required to support our recovery plan. This tutorial will focus on using Bacula as a backups solution. The benefits of using a full-fledged backup system, such as Bacula, is that it gives you full control over what you back up and restore at the individual file level, and you can schedule backups and restores according to what is best for you.
How To Install Moodle on Ubuntu 16.04
Moodle is a popular web-based learning management system (LMS) that is free for anyone to install and use. With Moodle, you create and deliver learning resources such as courses, readings, and discussion boards to groups of learners. Moodle also allows you to manage user…
How To Connect to MySQL Managed Database via phpMyAdmin
The phpMyAdmin tool allows users to create, store, and edit entire databases created with MySQL via a web interface. In this tutorial, you will install phpMyAdmin and use it to connect to a MySQL Managed Database cluster.
How To Address Crashes in MySQL
The most common cause of crashes in MySQL is that it stopped or failed to start due to insufficient memory. To check this, you will need to review the MySQL error log after a crash. First, attempt to start the MySQL server by typing: sudo systemctl start mysql Then…
How To Install Linux, Nginx, MySQL, PHP (LEMP stack) in Ubuntu 16.04
The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. This is an acronym that describes a Linux operating system, with an Nginx web server. The backend data is stored in the MySQL database and the dynamic processing…
How To Configure a Galera Cluster with MySQL 5.6 on Ubuntu 16.04
Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general…
How to Install MemSQL on Ubuntu 14.04
MemSQL is a type of in-memory database that can serve faster reads and writes than a traditional database. Even though it is a new technology, it speaks the MySQL protocol, so it feels very familiar to work with.
