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