Category: Database

This category about database technology, free software such as: mysql, mariadb, influxdb, mongodb.

How to set up HTTPS for InfluxDB server? You know, in today’s internet environment, data security is very important. Using HTTPS in database will make the data transfer between client and database server safer. This article will show you how to enable HTTPS in the InfluxDB server. Set up HTTPS for InfluxDB with a self-signed

How to install InfluxDB in CentOS 7? In this article, I will guide you step by step to install InfluxDB time series database in CentOS 7. You can install it for testing before using it. Preparation steps before installation Server information OS: CentOS Linux release 7.6.1810 (Core). RAM: For testing, you can choose 1GB of

Introduction to InfluxDB time series database. In this article, I will introduce you to InfluxDB. There are many people who have never heard of this type of database. What is time series database? You may have worked with database software such as MySQL, MariaDB, MSSQL server. You may be familiar with these types of databases,

How to install MongoDB in CentOS 7? This article will guide you step by step how to install it successfully. MongoDB is a well-known database type, many large systems are using it, especially the development of IoT. Add MongoDB repository to the server First, just like database types like MariaDB, MongoDB allows you to install

This article will show you how to create read-only user in MySQL. In which case do you need to use user read-only in MySQL? Normally in monitor systems, at the dashboard, you only need to use a read-only user. This user will read data from the database and display information to the dashboards. Commands to

How to install MariaDB 10.3 in Debian 8 Jessie. This article will guide you step by step to do that. Add MariaDB repository to the server You execute the commands below to add MariaDB repository to the server. Note that all of the following commands use the root user privilege. First, install packages that need

In this article, I will guide you step by step to install MariaDB 10.3 in Debian 9. The installation steps have been tested in Debian 9 (Stretch). Add MariaDB repository to the server First, we need to install some dependencies. # apt update && apt-get install software-properties-common dirmngr -y Next, we add the key of

This article will show you how to install MariaDB 10.2 in Ubuntu 16.04. MariaDB supports repository for operating systems based Redhat and Debian . Add MariaDB repository MariaDB has a page, allowing you to choose the repository that fits your OS. You can access this link to get the configuration for Ubuntu 16.04. Or you

This article will show you how to install MariaDB 10.3 in CentOS 6. Version 10.3 is the latest MariaDB version at this time. Configure server requirements The following is the recommended configuration to use the server when installing MariaDB. OS: CentOS 6.10 (Final) 64bit. RAM: minimum 1GB memory. HDD: free more then 5GB space. Most

In this article, I will show you how to install MariaDB 10.2 on CentOS 6. Server requirements Here are the minimum requirements for the server, I have used a virtual server with such requirements. OS: CentOS 6.9 (Final) 64 bit RAM: minimum 1GB memory HDD: over 5GB free space. Maybe you need more for store