mariadb
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
mariadb
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
db2
In the last article we installed IBM Db2 11.5 on Red Hat, and we also created the SAMPLE database using the db2sampl command, so in this article we will see how to use the restore redirect script to move that database to a different location. So let's
db2
In this article we are installing IBM Db2 on Red Hat linux. We can download Db2 from here - A free IBM account is required to download Db2 software. Once we've downloaded the software from the IBM website and uploaded to the Red Hat VM. root@redhat:/root&
mariadb
In this article, we are installing MariaDB alongside MySQL as seen on this article. Execute the following commands to install MySQL 8. dbuser@redhat:/home/dbuser> $ sudo yum install @mysql dbuser@redhat:/home/dbuser> $ sudo systemctl enable --now mysqld dbuser@redhat:/home/dbuser> $ sudo systemctl status mysqld
mariadb
In this article, we are installing MariaDB Community Edition on Red Hat Enterprise. In a previous one, we saw how to register and attach the Red Hat system. MariaDB 10.6.5 GA can be downloaded from here MariaDB Community Server: Lightweight but powerful, innovative but mature, and 100% open
redhat
In this article, we are installing Red Hat Enterprise 8.5 at no cost for education and testing purposes. First, you'd have to register here to join the Red Hat Developer program. The no-cost Red Hat Developer Subscription for Individuals is available and includes Red Hat Enterprise Linux
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
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
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
In this article, I'm installing Graylog on Ubuntu 20.04 on the Raspberry Pi 4 8GB. Graylog is a leading centralized log management solution for capturing, storing, and enabling real-time analysis of terabytes of machine data. I'm following the steps described here: Prereqs: $ sudo apt-get update
In this article, I'm installing Elasticsearch on Ubuntu for the Raspberry Pi 8GB, Elasticsearch is a distributed, RESTful search and analytics engine capable of addressing a growing number of use cases. because it's a requirement for Graylog, which I'll install in a next post.
In this article I'm installing MongoDB Community Edition on Ubuntu 20.04 on the Raspberry Pi 4 8GB. The steps (official docs) can be found here. I tried to install MongoDB CE 5.0, but it didn't work, I got the following message. ubuntu@ubuntu:~$ sudo
In this article, we are installing MariaDB Community Edition on Ubuntu 20.04 LTS, and, a in future post we will configure replication. I followed these steps from the MariaDB docs, here: But first, since this is a new server, let's upgrade it. Update the package lists for
Last week, I was trying to check the version of my Db2 client on my laptop and I got an unexpected error message. This was odd as my laptop had plenty of memory, so I tried a couple more commands. C:\WINDOWS\system32>db2licm -l Product name: "IBM
Last week a colleague contacted me about a PostgreSQL installation where the privileges of the postgres user suddenly "disappeared". I searched around a bit and found this really useful article in stackoverflow. However, his server was Windows, so I tried and replicated this issue on a Windows 2019
Last year, I installed SQL Server Management Studio 18.0 on a server tested the connection to the SQL Instance and everything looked OK. SSMS was exiting immediately after showing the splash screen. But months later, I tried again and SSMS was not starting. To troubleshoot this, let's
A few weeks ago I had the task to install SQL Server 2014 Express Edition and SQL Server Management Studio (SSMS) 18.4 and what it was going to be no more than an hour ended in a 16 hours change. Actually, I did install successfully one of the servers,
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