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 tables to be
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 mariadb01 (PRIMARY) and mariadb02
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 connect to
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> $ ls -lrt
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 ● mysqld.service -
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 along with
homelab
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
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
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
graylog
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 && sudo apt-get upgrade $ sudo
elasticsearch
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. Graylog is a leading centralized log
mongodb
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 systemctl status mongod ● mongod.
mariadb
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 upgrades for
db2
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 DB2 Developer-C
postgresql
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 server. First