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
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
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
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&
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
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
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.
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
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
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
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
databases
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
sqlserver
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,
arm
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
homelab
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
ubuntu
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:
mariadb
In this article we are installing MariaDB 10.5.8 Community Edition on Centos 8.2. MariaDB is free and open source software The MariaDB database server is published as free and open source software under the General Public License version 2. You can download and use it as much
worldcommunitygrid
A few weeks ago I came across a really interesting blog post while searching for articles for dbplatz.com. And actually it was pretty good timing as weeks before we bought a Raspberry Pi 4B 8GB (Ubuntu 20.4 64-bit) as our pre-production server As we can donate spare time,
db2
A few days ago I had this issue while running a Db2 online backup to TSM. db2inst1@ubusrvdb2:~ $ db2 "backup db SAMPLE online use TSM compress" SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code :"106" so I