LowEndBox - Cheap VPS, Hosting and Dedicated Server Deals

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!

How to Backup Your DirectAdmin Reseller Automatically Even If You Don't Have Shell Access

If you've been following my journey with Directadmin, I signed up for a DirectAdmin reseller account with Silicom Network. They perform backups, but I'd like my own backups. How can I automate them, including MySQL, when I don't have a shell account?

Read More
How to Backup Your DirectAdmin Reseller Automatically Even If You Don't Have Shell Access

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!

Updating A Free Udemy Bootstrap Course On Oracle Cloud Free Tier

Low End Box recently published A Beginner’s Quick Glance At Two Of Udemy’s Free Courses! The second of the two Udemy courses discussed in that post was Create a Members Only Blog using PHP, MySQL,...

Read More
Updating A Free Udemy Bootstrap Course On Oracle Cloud Free Tier

Have You Checked Out Our Tutorials?

Sure, you come to LowEndBox to get great deals, but did you know you can also learn a thing or two here? We have over 250 tutorials we've published over the years on topics such as Linux VPS administr...

Read More
Have You Checked Out Our Tutorials?

SQL vs. NoSQL - Which is Better?

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

Read More
SQL vs. NoSQL - Which is Better?

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

Read More
LowEndBoxTV: Weekend Update for May 1, 2021

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

Tuning MySQL 101: The Big Things to Look At

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

Read More
Tuning MySQL 101: The Big Things to Look At

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

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

Read More
Getting Started With the Dolphin: MySQL 101 - Full Setup and How to Guide

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

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

Read More
Limitless Hosting - Amazing discounts on cPanel/DirectAdmin Web Hosting and Reseller Hosting

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

LEMP Stack Installation on Debian 9

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

Read More
LEMP Stack Installation on Debian 9

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

Install and Secure phpMyAdmin on Ubuntu 16.04 VPS

With this tutorial, you will be able to install and secure phpMyAdmin, the most popular program for accessing MySQL and MariaDB databases on Internet servers. What We Are Going To Cover Installing the...

Read More
Install and Secure phpMyAdmin on Ubuntu 16.04 VPS

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]

How To Set Up A Laravel Application on Ubuntu 16.04 VPS

How To Set Up A Laravel Application on Ubuntu 16.04 VPS Let us presume that you have already set up an Ubuntu 16.04 VPS server with Apache and that you have installed a bare bones Laravel app. In this...

Read More
How To Set Up A Laravel Application on Ubuntu 16.04 VPS

How To Install CakePHP On Ubuntu 16.04 VPS

How To Install CakePHP On a Ubuntu 16.04 VPS With this tutorial, you will be able to create a CakePHP environment from scratch, define a database, and automatically generate a working web app. You wil...

Read More
How To Install CakePHP On Ubuntu 16.04 VPS

LEMP Stack installation on Centos 7

What is a LEMP STACK? Linux an open source operating, is most popular OS among web hosting providers. For successfully hosting a website on a Linux server we need four important software components i....

Read More
LEMP Stack installation on Centos 7
Older Posts »

Latest LowEndTalk Hosting Offers

View More