MariaDB

Status: Deprecated> Status: Deprecated # This article covers a version of Ubuntu that is no longer supported. If you are currently operate a server running Ubuntu 12.04, we highly recommend upgrading or migrating to a supported version of Ubuntu:

The author selected the Open Source Initiative to receive a donation as part of the Write for DOnations program. Introduction> Introduction # Zabbix is open-source monitoring software for networks and applications.

Introduction> Introduction # Docker Compose makes dealing with the orchestration processes of Docker containers (such as starting up, shutting down, and setting up intra-container linking and volumes) really easy. This article provides a real-world example of using Docker Compose to install an application, in this case WordPress with PHPMyAdmin as an extra.

What are MySQL and MariaDB?> What are MySQL and MariaDB? # MySQL and MariaDB are relational database management systems. These tools can be used on your VPS server to manage the data from many different programs.

Introduction> Introduction # There are many implementations of the SQL database language available on Linux and Unix-like systems. MySQL and MariaDB are two popular options for deploying relational databases in server environments.

Introduction> Introduction # 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 and potentially numerous queries ran against the database per second.

Introduction> Introduction # MariaDB is an open-source database management system (DBMS), commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It’s intended to be a drop-in replacement for MySQL and Debian now only ships with MariaDB packages.

The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Introduction> Introduction # Importing and exporting databases is a common task in software development.

Introduction> Introduction # MariaDB is an open-source database management system, commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.

Introduction> Introduction # 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, a more traditional DBMS can improve performance in production.

Introduction> Introduction # MySQL is an open-source database management system, commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data.

Introduction> Introduction # 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.

Introduction> Introduction # 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.

Introduction> Introduction # While many users need the functionality of a database management system like MariaDB, they may not feel comfortable interacting with the system solely from the MariaDB prompt.