Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are supported, and we’re not going for any flavor of openSUSE or SUSE (that for sure will work), but for a Debian 11 client. As our server is running…
Most of you probably heard of Red Hat Satellite, a product which is used to manage Linux infrastructures. Maybe you also heard about SUSE Manager, which does more or less the same thing. Both solutions traditionally used Spacewalk as the underlying system management solution, but Spacewalk discontinued on May 31 2020. While Red Hat went for Foreman as a replacement…
This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL. At first some requirements, in my case…
Virtualisation is now possible on the ODA whatever it is an ODA Lite or HA. The virtualisation is based on KVM and integrated with odacli for Bare Metal installation. Virtualisation has got the advantage to allocate resources to databases and applications on the same physical server. But what is the High Availability solution I have for virtualization on the ODA?…
What is Redis streams?? (Definition from Redis.io ) A Redis stream is a data structure that acts like an append-only log. You can use streams to record and simultaneously syndicate events in real time. Examples of Redis stream use cases include: Redis generates a unique ID for each stream entry. You can use these IDs to retrieve their associated entries…
How to secure your SQL script and remove password using Oracle wallets
By Mouhamadou Diaw We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to OEM 13cR5 Update 11. For this I used the following patches Patch 34601305: Oracle Enterprise Manager 13c Release 5 Update 11 (13.5.0.11) for Oracle…
What is Redis? Redis which stands for Remote Dictionary Server is “an in-memory data structure store, used as a distributed, in-memory key–value database, cache and message broker, with optional durability” It is a Nosql database which offer you many ways to search and store your data. Wat is Redis Insight? RedisInsight is a powerful tool for visualizing and optimizing data…
In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still in progress to further reduce maintenance tasks which require superuser privileges. Today another patch was committed which brings even more delegation for maintenance operations. One more, a simple setup to demonstrate what has…
As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be returned if the cast fails. Before looking at the new functions in PostgreSQL 16, lets have a look at what happens…
In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while developing your code. But still, at least when compared to other languages, the possibilities for debugging your code in PL/pgSQL are quite limited in vanilla…
