MariaDB

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
How To Use MySQL with Your Ruby on Rails Application on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Use MySQL with Your Ruby on Rails Application on CentOS 7

Ruby on Rails uses sqlite3 as its default database, which works great in many cases, but may not be sufficient for your application. If your application requires the scalability, centralization, and control (or any other feature) that a client/server SQL database, this tutorial will show you how to do just that, with MySQL, on CentOS 7 or RHEL.

Read more
CHAT