Tag: databases
How to Install MariaDB 10.3 on FreeBSD 12
How do I install MariaDB 10.3 on FreeBSD 12?, How to Install MariaDB 10.3 Database Server on FreeBSD 12?. MariaDB 10.3 is a multi-user, multi-threaded SQL database server. It is a community-developed fork of the MySQL relational database management system. MariaDB 10.3 Features: InnoDB is used as the default storage engine instead of XtraDB. System-versioned tables FOR loops…
SQL from scratch: how to get started learning databases?
(: July 1, 2019) It’s no secret how important database skills are for modern tech. Skilled engineers are highly sought after and have no problems landing high-profile jobs. Regardless of whether you need database skills to change career or manage personal projects, they are certainly worth exploring. The foundation of database knowledge starts from familiarizing…
How to Install MariaDB 10.3 on Fedora 30/29/28
(: May 9, 2019) In this guide, we will cover the installation of MariaDB 10.3 on Fedora 30/29/28. MariaDB is a drop-in replacement for MySQL. It is a robust, resilient, scalable and reliable RDBMS with features previously only available in costly proprietary databases. Fedora 30 has MariaDB 10.3 available in its repositories. For Fedora 29/28,…
How to Install MariaDB on Debian 10 Buster
(: March 31, 2019) In this tutorial, I’ll show you how you can install MariaDB 10.3 on Debian 10 (Buster). MariaDB is a relational database management system forked from MySQL. MariaDB is fully open source and is released under the General Public License version 2. There is no additionally repository need for installation of MariaDB…
How to Install ClickHouse analytic DBMS on Ubuntu 18.04 / CentOS 7
(: March 26, 2019) In this tutorial, we will cover the steps to install ClickHouse on Ubuntu 18.04 / CentOS 7. ClickHouse is a free and open-source column-oriented database management system that allows generating analytical data reports in real time. ClickHouse is multi platform and can run on any Linux, FreeBSD or Mac OS X…
Install Dgraph on CentOS 7 / Ubuntu 18.04
(: February 25, 2019) Question: How to install Dgraph on CentOS 7?, How to install Dgraph on Ubuntu 18.04. Dgraph is an open source distributed graph database built from ground up for a rich set of queries. Features of Dgraph DISTRIBUTED: Dgraph shards the data to horizontally scale to hundreds of servers. It is designed…
How to convert all MySQL tables from MyISAM into InnoDB Storage engine
(: January 12, 2019) Do you have some tables in your MySQL database still using MyISAM and would like to convert them to use InnoDB Storage engine?. This guide has been written to walk you through the conversion of MyISAM into InnoDB Storage engine. InnoDB has a strong focus on performance, support for transactions and…
Install and Configure Redis Server on RHEL 8 / CentOS 8
(: January 9, 2019) How can I install Redis on RHEL 8?. This guide will help you to install and configure Redis server on RHEL 8. Redis is a free and open Source in-memory data structure store. It can be used as a database server, as a message broker or for caching data in memory…
How to Install Redis on Ubuntu 18.04 / Debian 9
In this tutorial, I’ll walk you through the steps to install Redis Server on Ubuntu 18.04 / Debian 9. Redis is an Open Source in-memory data structure store. Redis can be used as a database server, as a message broker or for caching data in memory for faster retrieval. Redis supported data structures are: Hashes…
How To Install Latest Redis on CentOS 7
In this tutorial, we will cover step by step ways to install Redis on CentOS 7. Redis is an Open Source in-memory data structure store. Redis can be used as a database server, as a message broker or for caching data in memory for faster retrieval. Among the data structures supported by Redis are: Hashes…