Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, so you can recover older copies of your database in case of an emergency, or you...

Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-e...

MySQL is an open-source database management system. CentOS 7 prefers MariaDB, a fork of MySQL managed by the original MySQL developers and designed as a replacement for MySQL. Unless you have a specific use-case for M...

phpMyAdmin is an application that allows users to interact with MySQL (or MariaDB) databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on a Debian 10 server.

MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...

MariaDB is an open-source database management system, commonly used for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack.

MariaDB is an open-source database management system, commonly installed as part of the popular LEMP stack. In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 server. If you ...

MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...

A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This stack typically consists of the Linux operating system, the Apache ...

Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-e...

MySQL and MariaDB are relational databases used in many unique situations. However, they can pose a security risk for your system and your data if you do not secure them properly. This guide will introduce some basi...

A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps written in PHP. This term is an acronym which represents the Linux operat...

MySQL and MariaDB are database management software that use the SQL querying language. In this guide, we will discuss how to create and manage databases from within the MySQL or MariaDB interface. This guide will co...

Zabbix is open-source monitoring software for networks and applications. In this tutorial, you will configure a Zabbix-based monitoring system on two CentOS 7 machines. One will be configured as the server, and the ot...

This article provides a real-world example of using Docker Compose to install an application, in this case WordPress with PHPMyAdmin as an extra. WordPress normally runs on a LAMP stack, which means Linux, Apache, My...

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three CentOS 7 Droplets that will act as nodes in the cluster. MariaDB is an open sour...

Django is a flexible framework for quickly creating Python applications. By default, Django applications are configured to store data into a lightweight SQLite database file. While this works well under some loads, mo...

Databases grow over time, sometimes outgrowing the space on the file system. You can also run into I/O contention when they’re located on the same partition as the rest of the operating system. RAID, network block sto...

MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distr...

ERPNext is an Enterprise Resource Planning (ERP) suite that leverages the power and flexibility of open-source technologies. It excels at managing core business processes such as finance, sales, HR, manufacturing, pur...