DBplatz. Where all databases are welcome. SQL and NoSQL. #useThemAll

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. [[email protected] ~]$ 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

IBM Db2 restore redirect

IBM Db2 restore redirect

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

Installing IBM Db2 11.5 on Red Hat.

Installing IBM Db2 11.5 on Red Hat.

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. [email protected]:/root> $ ls -lrt

Installing MariaDB 10.6 alongside MySQL 8.0.26 on Red Hat 8.5

Installing MariaDB 10.6 alongside MySQL 8.0.26 on Red Hat 8.5

In this article, we are installing MariaDB alongside MySQL as seen on this article. Execute the following commands to install MySQL 8. [email protected]:/home/dbuser> $ sudo yum install @mysql [email protected]:/home/dbuser> $ sudo systemctl enable --now mysqld [email protected]:/home/dbuser> $ sudo systemctl status mysqld ● mysqld.service -

Installing MariaDB 10.6.5 Community Server on Red Hat Enterprise Linux release 8.5

Installing MariaDB 10.6.5 Community Server on Red Hat Enterprise Linux release 8.5

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

Installing Red Hat Enterprise for free.

Installing Red Hat Enterprise for free.

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: 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 Graylog on Ubuntu 20.04 on the Raspberry Pi.

Installing Graylog on Ubuntu 20.04 on the Raspberry Pi.

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

Installig Elasticsearch on Ubuntu 20.04 on the Raspberry Pi.

Installig Elasticsearch on Ubuntu 20.04 on the Raspberry Pi.

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

Installing MongoDB Community Edition on Ubuntu 20.04.3 LTS on the Raspberry Pi.

Installing MongoDB Community Edition on Ubuntu 20.04.3 LTS on the Raspberry Pi.

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. [email protected]:~$ sudo systemctl status mongod ● mongod.

Installing MariaDB Community Server 10.5 on Ubuntu 20.04 LTS

Installing MariaDB Community Server 10.5 on Ubuntu 20.04 LTS

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

SQL1022C There is not enough memory available to process the command.

SQL1022C There is not enough memory available to process the command.

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 - default superuser privileges were removed.

PostgreSQL - default superuser privileges were removed.

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

SQL Server - SSMS exiting immediately after showing the splash screen.

SQL Server - SSMS exiting immediately after showing the splash screen.

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 cd to

SQL Server - Could not find the Database Engine Startup handle.

SQL Server - Could not find the Database Engine Startup handle.

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,

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:

How To Install MariaDB 10.5.8 on Centos 8.2

How To Install MariaDB 10.5.8 on Centos 8.2

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

We’ve joined the World Community Grid and you can join too!

worldcommunitygrid Featured

We’ve joined the World Community Grid and you can join too!

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,

SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "106".

SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "106".

A few days ago I had this issue while running a Db2 online backup to TSM. [email protected]:~ $ 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 executed db2 ? SQLXXXX to

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