LowEndBox - Cheap VPS, Hosting and Dedicated Server Deals

SQL vs. NoSQL – Which is Better?

Tags: , , , , , , , , , Date/Time: October 2, 2021 @ 3:41 pm, by raindog308

In the world of database systems, SQL has been the king since it took off in the early 80s.  It was conceived, developed, and codified in the 1970s but really hit its stride once developers had worked out the kinks and it rapidly overtook earlier, hierarchical DB systems like IMS. In the 21st century, NoSQL […]

Nodes and Modes: Maintaining Galera Replication for MariaDB

Tags: , , , , Date/Time: September 23, 2021 @ 12:00 am, by raindog308

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 tutorial, we’re doing to forcibly interject a little pain into the process by seeing how Galera deals with down loads and replaced nodes. Once […]

Painless MariaDB Replication with Galera Clusters

Tags: , , , , , Date/Time: September 22, 2021 @ 12:00 am, by raindog308

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 look at some replication events. Cluster Design For Galera, you want to use odd-number clustered sizes: 3 nodes, 5 nodes, etc.  It’s possible to run a […]

LowEndBoxTV: Weekend Update for May 1, 2021

Free VPS, Cheap VPS, and Ryzen VPS, plus interviews with DirectAdmin and OnApp, plus our Industry Roundtable on ipv4 exhaustion, plus…whew, it was quite a week! This video is our weekly update of everything that happened on LowEndBox over the last week.  Since this is the first one, we’re actually going back two weeks.  We’re […]

Automating mysql_secure_installation in MariaDB Setup

Tags: , , , , Date/Time: April 27, 2021 @ 12:00 am, by raindog308

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 are trying to automate MariaDB/MySQL installations, it’s easy enough to install MariaDB (e.g., apt-get -y mariadb-server) but you […]

Tuning MySQL 101: The Big Things to Look At

Tags: , , , Date/Time: April 9, 2021 @ 12:00 am, by raindog308

Database tuning is an art, rather than a science. I speak as someone who’s worked as a professional DBA for over 15 years and is certified in multiple commercial RDBMS techologies. There is no set of formulas that can be presented that work in all cases, because the data sets and workloads are too variable. […]

Getting Started With the Dolphin: MySQL 101 – Full Setup and How to Guide

Tags: , , , Date/Time: February 25, 2021 @ 6:53 am, by raindog308

MariaDB and PostgreSQL are the two leading SQL databases. Both adhere to many ANSI SQL standards, but these ANSI standards don’t specify all behaviors. The SQL statement themselves (such as SELECT, INSERT, UPDATE, and DELETE) are the areas where they have the most commonality. Where they differ the most is in their DDL (data definition […]

Limitless Hosting – Amazing discounts on cPanel/DirectAdmin Web Hosting and Reseller Hosting

Tags: , , , , , , Date/Time: January 19, 2020 @ 7:29 am, by Frank Williams

Limitless Hosting recently contacted us with very affordable cPanel/DirectAdmin Web Hosting and Reseller Hosting. They told us that even normal price starts at $0.50/month! Also, they provide even more discounts to LEB users as well as additional promo codes to use on plans that are not listed below! Their WHOIS is public and you can […]

CentOS 7 LAMP Server Tutorial Part 6: Moving to NGINX

Tags: , , , , , , , , , , , , , , Date/Time: July 15, 2019 @ 7:58 am, by Ryan Flowers

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 installing NGINX (pronounced “Engine X”) in its place. Why would we want to replace the Apache web server with NGINX? […]

LEMP Stack Installation on Debian 9

Tags: , , , , , , Date/Time: July 13, 2019 @ 12:56 pm, by Dusko Savic

This tutorial will show you how to install and configure the LEMP stack on your VPS/LowEndBox, running Debian 9. LEMP stands for Linux Nginx MySQL PHP, and is a lightweight variation of the LAMP stack, which includes Apache instead of Nginx. You’ll notice that it’s not written as LNMP, and that’s due to the pronunciation […]

Older Posts »