MariaDB

How To Configure a Galera Cluster with MariaDB on Ubuntu 18.04 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MariaDB on Ubuntu 18.04 Servers

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Ubuntu 18.04 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.

Read more
How To Install an ERPNext Stack on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install an ERPNext Stack on Ubuntu 20.04

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, purchases, services, helpdesk, and more.

Read more
How To Install MariaDB from Binary Tarballs on Ubuntu 13.10 — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB from Binary Tarballs on Ubuntu 13.10

Currently, MariaDB is a drop-in replacement for MySQL. This article describes the installation of MariaDB version 5.5.34 x86_64 on an Ubuntu 13.10 droplet. Binary tarballs are used for installation instead of the software repositories available through apt-get. A potential rationale for this choice would be to have complete control over the installed version of MariaDB.

Read more
What is MariaDB? — step-by-step Databases tutorial on Progressive Robot

What is MariaDB?

MariaDB is an open-source relational database management system. As with other relational databases, MariaDB stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as…

Read more
How To Reset Your MySQL or MariaDB Root Password on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Reset Your MySQL or MariaDB Root Password on Ubuntu 20.04

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-enabled user account. In this tutorial you’ll reset the root password for your MySQL or MariaDB database running on Ubuntu 18.04.

Read more
How To Use MySQL Query Profiling — step-by-step Databases tutorial on Progressive Robot

How To Use MySQL Query Profiling

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 distributed throughout a large code base. This article will demonstrate some useful query profiling techniques using tools that are built into MySQL server.

Read more
CHAT