LowEndBox

Apr 17, 2024

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. We're at the final part and now we're going to wrap up with round-robin DNS, Let's Encrypt, and a test of the HA setup.

Setup a Highly Available Wordpress Site From Scratch, 2024 Edition! Part 7: Round-Robin DNS, Let’s Encrypt, & Conclusion

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

Apr 16, 2024

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.

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

Apr 15, 2024

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.

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

Apr 14, 2024

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.

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

Apr 13, 2024

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.

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

Apr 12, 2024

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.

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

Apr 11, 2024

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.

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!

Jan 31, 2024

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.

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

Removing a Package on Debian with Extreme Prejudice

Mar 18, 2023

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

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

Mar 03, 2023

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!

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

Stop the Senseless Flushing!

Feb 27, 2023

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

PostgreSQL 15 is Released!

Oct 13, 2022

The world's most advanced open source database

Nodes and Modes: Maintaining Galera Replication for MariaDB

Sep 23, 2021

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...

Painless MariaDB Replication with Galera Clusters

Sep 22, 2021

Comments (4)

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...

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

May 14, 2021

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...

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

Automating mysql_secure_installation in MariaDB Setup

Apr 27, 2021

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...

Automating mysql_secure_installation in MariaDB Setup

LEMP Stack Installation on Ubuntu 16.04

Kaylee

Jul 18, 2019

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...

CentOS 7 LAMP Server Tutorial Part 6: Moving to NGINX

Jul 15, 2019

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...

CentOS 7 LAMP Server Tutorial Part 6: Moving to NGINX

How to Install Moodle on Ubuntu 18.04

Kaylee

Jul 05, 2019

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...

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

Jul 01, 2019

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...

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

Jun 15, 2019

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...

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

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

Jun 13, 2019

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,...

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

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

Jun 03, 2019

Comments (5)

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...

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

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

Jun 03, 2019

Comments (6)

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...

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

MariaDB: Installation, Optimization and Tuning

SysAdmin

Sep 29, 2016