DBplatz Blog » Homelab
35 FOLLOWERS
Find articles featuring Database News, Databases, Db2, SQL Server, MongoDB, Oracle, MySQL, Development, Security, News, Tips, Articles, Cloud, HomeLab, Infrastructure, Systems, IT, PostgreSQL.
DBplatz Blog » Homelab
2y ago
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 - mariadb01We connect to mariadb01 as Primary. [centos@mariadb01 ~]$ mysql -u root -p --prompt "Primary> "We set all tables to be ..read more
DBplatz Blog » Homelab
2y ago
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 MariaDBI've used this guide to install MariaDB 10.3 on 2 Hyper-V VM servers called mariadb01 (PRIMARY) and mariadb02 (REPLICA ..read more
DBplatz Blog » Homelab
2y ago
In a previous post, we learned about installing Db2. Now I'm installing SQL Server. Photo by Tadas Sar / Unsplash 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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more
DBplatz Blog » Homelab
2y ago
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 ..read more