Databases

NoSQL databases are an alternative to the traditional SQL databases. They are more flexible, scalable and functional for working with big data. There are different types of NoSQL databases. The most widely used types include: key-value databases, document databases, wide-column databases, and graph databases.

Need to install the ELK stack to manage server log files on your CentOS 8? Follow this step-by-step guide and set up each layer of the stack - Elasticsearch, Logstash, and Kibana.

Learn about the difference between Cassandra and MongoDB. These NoSQL databases have some similarities, but many more differences. Examine these factors and decide which database is better for you.

Once you install MariaDB, one of the first things you need to do is to create a new MariaDB user. This article explains how to create a MariaDB user, and then how to grant privileges to the newly created user.

Learn how to export a PostgreSQL table to a .csv file. This feature is especially helpful when transferring the table to a different system or importing it to another database application. The guide shows you how to use either the COPY or the /copy command to export PostgreSQL databases and columns as .csv files.

MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure your databases.

Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to spin up since they share the kernel and libraries of the host while packaging the deployed application.

ClickHouse is an open-source column-oriented database management system. It is a fast, scalable, and efficient software to use for data analysis updated in real-time. If you are interested in getting started with the software, this article will guide you how to install and use ClickHouse on your CentOS 7 server.

It is essential to know which version of MySQL you have installed. The version number helps to determine if a specific feature is available or compatible with your system. This article provides five options to check your version of MySQL in Linux Operating Systems.

MySQL is an open-source relational database server tool for Linux operating systems. It is widely used in modern web-based technology, and it forms part of the popular “LAMP” stack of software.  The LAMP stack includes the Linux operating system, Apache web services, MySQL database (or sometimes MariaDB), and the PHP programming language.