MariaDB

How To Secure MySQL and MariaDB Databases in a Linux VPS — step-by-step Linux tutorial on Progressive Robot

How To Secure MySQL and MariaDB Databases in a Linux VPS

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 basic considerations and steps you can take to ensure that your data is more secure.

Read more
How To Configure a Galera Cluster with MariaDB on Debian 9 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MariaDB on Debian 9 Servers

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Debian 9 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 MariaDB on Ubuntu 20.04 [Quickstart] — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB on Ubuntu 20.04 [Quickstart]

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

Read more
How To Store and Retrieve Data in MariaDB Using Python on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Store and Retrieve Data in MariaDB Using Python on Ubuntu 18.04

In this tutorial you will connect a Python application to a database server using the MySQL connector. This module allows you to make queries on the database server from within your application. You’ll set up MariaDB for a Python environment on Ubuntu 18.04 and write a Python script that connects to and executes queries on MariaDB.

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

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

Replication allows your databases to distribute load among more than one computer. While MariaDB natively supports master-slave replication, which allows you to offload read operations to a a number of slave servers, this master-master replication, which allows you to write data to any node, is not implemented. With a Galera cluster, MariaDB incorporates some patches that allow for master-master replication. We will be setting this up using Ubuntu 12.04 servers.

Read more
CHAT