Tag: MariaDB

Keeping your data safe and easy to access is essential to keep your organization compliant with government and industry policies, manage internal policies, protect against cyber security attacks, and simply ensure your data performs appropriately. To do this, you need to complete a database audit.

Many database solutions are available today, and MySQL and MariaDB are some of the best ones you can use. However, while they share a lot of similarities, such as syntax and architecture, there are some key differences you should keep in mind, including performance, licensing, and support, among others.

MySQL is a popular, modern, and fully featured relational database management software that is free and open source. It is used by companies worldwide for mission-critical enterprise data storage and processing, as the backend for large customer-facing applications, and as a component of robust, well-established web software stacks.

Strict mode in MySQL and MariaDB controls the handling of invalid or missing values in data-changing queries. This includes INSERT, UPDATE, and CREATE TABLE statements. With MySQL strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.

Previous Series:
MySQL via Command Line 101: Basic Database Interaction

MariaDB is a free, open-source database management system that replaces the proprietary MySQL database management system. Many new features and changes have been added and improved in each MariaDB version. For version 10.8.0, some new features include:

The MariaDB server is a popular, open-source relational database known in the standard repositories of all major Linux distributors.

Introduction

Zabbix is an open-sourced tool used to monitor various IT components such as servers and hardware that they are running, cloud services, whole networks, etc. Zabbix can monitor the network health and integrity of your servers. All monitoring can be done through Zabbix’s web-based frontend. This means that you can quickly check the status of your servers from anywhere! This article describes how to install the Zabbix monitoring tool, create a database, and configure the frontend on Ubuntu 20.04.

What is ClickHouse?

ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.

Introduction

In this tutorial, we will examine what Neo4j is, what it is used for, and how it is implemented. We will also install and configure the installation on an Ubuntu 20.04 server. Neo4j is a graphical database used to create data relationships. Other examples of graphical databases include: