MySQL
-
PHP
Install phpMyAdmin on Ubuntu/Debian OpenLiteSpeed Server
phpMyAdmin is a web-based graphical user interface (GUI) for managing MySQL and MariaDB databases. Developed in PHP, it simplifies database administration tasks by providing an intuitive interface accessible…
Read More » -
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 »
