MySQL
-
MySQL/MariaDB
ERROR 1047: WSREP has not yet prepared node for application use
On replicated databases, you need to achieve quorum. That means you need to have an odd number of MariaDB/MySQL database…
Read More » -
MySQL/MariaDB
How to import MySQL .SQL dump/backup files to MySQL Server
We’ve recently created a WordPress site and we want to move the database for this site from our production server…
Read More » -
MySQL/MariaDB
How to install MySQL 8 on Ubuntu 22 LTS and configure your first database
The next LTS version of Ubuntu is now available for download and we are going to install MySQL 8 Ubuntu…
Read More » -
MySQL/MariaDB
How To Replicate MySQL Databases Using MySQL Replication
A common issue when trying to introduce High Availability is what do to with your database. There are multiple options.…
Read More » -
MySQL/MariaDB
How To Configure/Set up MySQL Master-Master Replication
MySQL Master-Master replication evolved from the binary MySQL Master-Slave Replication. In a Master and Slave environment, database changes are made…
Read More » -
MySQL/MariaDB
Reset MySQL Replication Slave – Replica_SQL_Running No
MySQL Replication is a great tool and also a needed tool for high availability. Unfortunately, it’s temperamental, to say the…
Read More » -
MySQL/MariaDB
Install AutoMySQLBackup to Backup Databases In Linux Servers
With the very nature of MySQL databases, they tend to hold precious information. That’s why you must have a backup…
Read More » -
MySQL/MariaDB
How To Configure An Internal MySQL Database Server
High-value assets like database servers are always a target for hackers. Typically, these types of services hold valuable information like…
Read More » -
Load Balancing
Load Balance MySQL Connections With HAProxy
Recently, we went through the process of load-balancing HTTPS connections with HAProxy. In this article, we are going to Load…
Read More » -
Web Servers
Host websites on Apache Virtual Hosts With SSL
In this guide, we are going to use an Ubuntu 22 LTS instance with SSL Apache Virtual Hosts to host…
Read More »