LowEndBox - Cheap VPS, Hosting and Dedicated Server Deals

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 6: MariaDB Multi-Master

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part six, we're setting up MariaDB multi-master replication using Galera.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 6: MariaDB Multi-Master

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 5: Wordpress Install

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part five, we're using the Gluster install we did in the previous part to setup Wordpress.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 5: Wordpress Install

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 4: Gluster

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part four, we're installing GlusterFS and getting it working on all three nodes.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 4: Gluster

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 3: Ansible

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part three, we'll leverage Ansible to make our setup fast and easy.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 3: Ansible

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 2: Ordering the VPSes

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part two, we'll step through provisioning these VMs at Hetzner.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 2: Ordering the VPSes

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 1: Introduction, Considerations, and Architecture

Three years ago, we published a series on building a highly-available Wordpress site from scratch. Now we're going to refresh the technology stack and bring it up to date for 2024. In part one, we're covering some background, design considerations, and architecture.

Read More
Setup a Highly Available Wordpress Site From Scratch, 2024 Edition!  Part 1: Introduction, Considerations, and Architecture

NOW() vs. SYSDATE() in MySQL/MariaDB: What's the Difference? Watch Out for This Gotcha!

Recently I read a long article about the difference between SYSDATE() and CURRENT_DATE() in Oracle databases.  It reminded me that I once researched the difference between NOW() and SYSDATE() in MySQL.  These functions seem very similar, and for many (most?) uses, you'd be hard-pressed to observe a difference.  But they're not exactly the same.  Here's a quick guide on which to use when.

Read More
NOW() vs. SYSDATE() in MySQL/MariaDB: What's the Difference?  Watch Out for This Gotcha!

Removing a Package on Debian with Extreme Prejudice

apt just slaps at the problem; dpkg solves it. An interesting experience trying to get MariaDB back to a clean slate.

Read More
Removing a Package on Debian with Extreme Prejudice

How to Setup a Highly Available Wordpress Site From Scratch: Two Years Later, It Still Works!

We did a six-part tutorial on setting up a highly available Wordpress site using two VPS systems, configuring MariaDB and replication, using DRBD and OCFS2 for filesystem replication, and tying it all off with round-robin DNS. It still works!

Read More
How to Setup a Highly Available Wordpress Site From Scratch: Two Years Later, It Still Works!

Stop the Senseless Flushing!

After you create users and grant privileges in MySQL, the next step is to FLUSH PRIVILEGES, right? Wrong.

Read More
Stop the Senseless Flushing!

PostgreSQL 15 is Released!

The world's most advanced open source database

Read More
PostgreSQL 15 is Released!

Nodes and Modes: Maintaining Galera Replication for MariaDB

In a previous tutorial, we showed you how to setup Galera replication for MariaDB so you could have multi-node, multi-master clusters.  We also saw how MariaDB painlessly replicates data.  In this tut...

Read More
Nodes and Modes: Maintaining Galera Replication for MariaDB

Painless MariaDB Replication with Galera Clusters

Galera is MariaDB's multi-master replication technology which makes it a snap to setup highly-available multi-node MariaDB clusters.  In this tutorial we'll walk through setting up a cluster and also...

Read More
Painless MariaDB Replication with Galera Clusters

LowEndBoxTV: Building a Highly Available Wordpress Site, Part 3: Configuring MariaDB Multi-Master Replication

In this series, we take you from bare-metal to a highly-available Wordpress site, load-balanced over two nodes and resistant to VPS failures using MariaDB multi-master replication, DRBD, and round-rob...

Read More
LowEndBoxTV: Building a Highly Available Wordpress Site, Part 3: Configuring MariaDB Multi-Master Replication

Automating mysql_secure_installation in MariaDB Setup

Lots of people want to automate their system setup, and this is frequently done by either using the provider's new VM hooks to run a script at setup time or later using something like Ansible. If you...

Read More
Automating mysql_secure_installation in MariaDB Setup

LEMP Stack Installation on Ubuntu 16.04

This tutorial will show you how to install and configure the LEMP stack on your VPS/LowEndBox. LEMP stands for Linux Nginx MySQL PHP, and is a lightweight variation of the LAMP stack, which includes A...

Read More
LEMP Stack Installation on Ubuntu 16.04

CentOS 7 LAMP Server Tutorial Part 6: Moving to NGINX

Welcome to the last installment in the CentOS 7 LAMP Server Tutorial: Modernized and Explained series! In this article we are going to turn our LAMP server into a LEMP server by removing Apache and in...

Read More
CentOS 7 LAMP Server Tutorial Part 6: Moving to NGINX

How to Install Moodle on Ubuntu 18.04

Moodle is an open source Learning Management System or LMS.  It hails as the worlds most popular learning platform with over 153M users worldwide.  Moodle is consumable in 3 basic hosted varieties: DI...

Read More
How to Install Moodle on Ubuntu 18.04

CentOS 7 LAMP Server Tutorial Part 5: Speeding up WordPress with Redis

In the previous CentOS 7 LAMP Server Tutorials, we configured a LAMP stack, secured it with Let's Encrypt SSL certificates, and installed WordPress with WP-CLI. Here in Part 5 we're going to up our ga...

Read More
CentOS 7 LAMP Server Tutorial Part 5: Speeding up WordPress with Redis

CentOS 7 LAMP Server Tutorial Part 4: WordPress and wp-cli

Welcome to the fourth installment of the CentOS 7 LAMP Server Tutorial: Modernized and Explained series.In Part 1 and Part 2 we configured a LAMP server with PHP-FPM running PHP 7.3 and a modern versi...

Read More
CentOS 7 LAMP Server Tutorial Part 4: WordPress and wp-cli

CentOS 7 LAMP Server Tutorial Part 3: Let's Encrypt SSL

Welcome to the third installment of the CentOS 7 LAMP Server Tutorial: Modernized and Explained series. This tutorial builds on the work done in Part 1 and Part 2, so if you haven't checked them out,...

Read More
CentOS 7 LAMP Server Tutorial Part 3: Let's Encrypt SSL

CentOS 7 LAMP Server Tutorial: Modernized and Explained [Part 2]

In Part 1 of this Tutorial, we discussed why we decided to build a LAMP server instead of getting one pre-configured via a control panel such as cPanel or Virtualmin. We configured Remi's repository f...

Read More
CentOS 7 LAMP Server Tutorial: Modernized and Explained [Part 2]

CentOS 7 LAMP Server Tutorial: Modernized and Explained [Part 1]

Welcome to another LowEndBox Linux tutorial! In this post we're going to design and configure a high performance server that will allow you to run multiple websites using the latest software available...

Read More
CentOS 7 LAMP Server Tutorial: Modernized and Explained [Part 1]

MariaDB: Installation, Optimization and Tuning

MariaDB is forked from MySQL, MariaDB has been known to be a drop-in replacement that brings enhancements and performance optimizations over MySQL. This tutorial will show you how to install, optimize...

Read More
MariaDB: Installation, Optimization and Tuning

Latest LowEndTalk Hosting Offers

View More