MariaDB

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 on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB on Ubuntu 18.04

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 for MySQL. This tutorial will explain how to install MariaDB on an Ubuntu 18.04 server, and verify that it is running and has a safe initial configuration.

Read more
How To Install MySQL on CentOS — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on CentOS

MySQL is an open-source database management system. CentOS prefers MariaDB by default, 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 MySQL, see the [How To Install MariaDB on CentOS](https://www.progressiverobot.com/how-to-install-mariadb-on-centos-7/) guide.

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