homelab - DBplatz

homelab

A collection of 13 posts

MariaDB failing over primary to the replica.

MariaDB failing over primary to the replica.

In a previous post, we set up replication for MariaDB. This time we are failing over manually from the Primary node (master) to the Replica node (slave). Primary - mariadb01 We connect to mariadb01 as Primary. [centos@mariadb01 ~]$ mysql -u root -p --prompt "Primary> " We set all tables to be

Setting Up Replication - MariaDB 10.3

Setting Up Replication - MariaDB 10.3

In a previous post we learned how to install MariaDB on Centos. In this one we are setting up replication. Official docs are here. So, let's get to it. Installing MariaDB I've used this guide to install MariaDB 10.3 on 2 Hyper-V VM servers called mariadb01 (PRIMARY) and mariadb02

HomeLab: Creating a domain account and users.

HomeLab: Creating a domain account and users.

In a previous article we saw how to create a domain controller, now let's create domain users. Let's click on Start and then Server Manager. Go to Tools and then to Active Directory Users and Computers. Click on the domain (netplatz) and then go to users and right-click User. Provide

HomeLab: Creating a Domain Controller on Windows 2019.

HomeLab: Creating a Domain Controller on Windows 2019.

Now that we know how to create a VM using Hyper-V, let's configure a domain controller which is required for our HomeLab SQL Server Always On installation. There is a really helpful guide already here, but I'll be using Windows 2019 instead. So, once our VM is up and running,

HomeLab: Creating a Windows 2019 Virtual Machine with Hyper-V

HomeLab: Creating a Windows 2019 Virtual Machine with Hyper-V

Today, I'm creating a new Windows 2019 VM using Hyper-V for my home lab. The goal is to create a new SQL Server AlwaysOn and FCI cluster for testing. So let's see how we can start just creating a VM for my domain controller (DC). Official docs are here Open

Installing Grafana on Raspberry OS.

Installing Grafana on Raspberry OS.

In a previous post we’ve installed Prometheus on Raspberry, and this time we are installing Grafana on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB. So, let’s start with downloading the software first from

Installing Prometheus on Raspberry OS.

Installing Prometheus on Raspberry OS.

In a previous post we’ve installed Prometheus on Ubuntu, and this time we are installing Prometheus on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB. So, let’s start with downloading the software first from

Installing Prometheus 2.22.1 on Ubuntu Server 20.04

Installing Prometheus 2.22.1 on Ubuntu Server 20.04

What is Prometheus? Prometheus is an open-source systems monitoring and alerting toolkit originally built at SoundCloud. Since its inception in 2012, many companies and organizations have adopted Prometheus, and the project has a very active developer and user community. To download the software we click here, select our Operating System:

Install CockroachDB on Ubuntu 16.04.

Install CockroachDB on Ubuntu 16.04.

Every time I read an article about "10 Reasons You Should Start a Blog", there is always something about "learning new skills", and it sounds obvious but it's true. Lately, I'm always thinking about things to write about which makes me search more ... until I find something that gets my

How to install SQL Server Management Studio (SSMS).

How to install SQL Server Management Studio (SSMS).

In this post, we will install SQL Server Management Studio on a Windows Server 2019. We've downloaded the installation from here SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. So once the installation file is on the

How to install SQL Server 2019 on Windows Server 2019.

How to install SQL Server 2019 on Windows Server 2019.

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. I've download SQL Server Developer Edition from here. However, now you don't get the ISO or installation files anymore, what you get is a downloader. So, If the target server does not have access to the

Creating a Db2 v11.5 instance and the sample database.

Creating a Db2 v11.5 instance and the sample database.

In the last post I installed Db2 11.5 on Ubuntu 16.4 and here I'll show how to create a Db2 instance and the SAMPLE database. But first, I'll create the db2inst1 user (Db2 Instance user). # Create the dba group groupadd dba # Create the db2inst1 user and assign it

How to install IBM Db2 Database v11.5 on Ubuntu 16.4.

How to install IBM Db2 Database v11.5 on Ubuntu 16.4.

This is the first blog post of a series to try to install as many databases SQL and NoSQL (#useThemAll) as possible on VMs at home (Lab @ Home) in order to learn more about them. So let's start installing IBM Db2 on Ubuntu using Virtual Box So we go to