I recently wrote about NGINX reverse proxy reconfiguration after creating or deleting a deployment in GoldenGate. It reminded me that there is an overlooked aspect of the reverse proxy configuration, which is important when trying to automate GoldenGate management with the REST API. In fact, when using a reverse proxy with a single deployment, some endpoints are different from a…
Configuring an NGINX reverse proxy for GoldenGate is well documented by Oracle, but what is not is the implication of adding or removing deployments. In fact, when modifying your GoldenGate deployments, you will have to reconfigure the NGINX reverse proxy. If you don’t, part of your installation will not be working anymore. This is what will happen in the web…
Recently, I wrote about deleting a GoldenGate deployment with the REST API, and when investigating this issue, I remembered a limitation of the configuration assistant, which I wanted to talk about. For more information about deployment removal with the configuration assistant, you can read a blog I wrote on the topic (for 23ai, but nothing changed in that regard in…
Recently, I was asked how to recreate a GoldenGate deployment if the password for the Security user (the first user created with the deployment) was lost. This is an interesting question that I figured was worth writing about. As a reminder, you have two main ways of creating and deleting deployments in GoldenGate: I already covered the creation and removal…
Among all the automation I was doing around a GoldenGate installation for DB2, I recently ended up with an INS-85037 error when running the configuration assistant oggca.sh. And because this error is quite common and has many different possible root causes, I wanted to write about it. Differences in GoldenGate setup between Oracle and DB2 If you’re wondering how to…
Is it possible to create a new GoldenGate deployment with the REST API ? This is the question I will try to answer in this blog, based on my experience with the REST API. I will dive in what is done by the oggca.sh script when adding a new deployment and see if we can replicate this with the REST…
You might have an existing unsecure GoldenGate installation that you would like to secure, whether it’s for security reasons or because you would like to dissociate the installation and its securing process. After searching everywhere in the Oracle documentation for how to proceed, I decided to try, investigate and eventually even asked Oracle directly. Here is the answer. For a…
26ai update: This article was originally written for 23ai. But not much changes when setting up GoldenGate 26ai. Just adapt the responseFileVersion when doing the silent installation, and that’s it ! As instructed in this other blog, use oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v26_1_0 Automating Oracle installations can sometimes be daunting, given the long list of parameters available. We’ll compare both graphic and silent installations…
When it comes to quickly provision a server in the Cloud, using an Infrastructure as Code (IaC) tool is a solution to consider. There are many IaC products available and among them, Terraform seems to be the most popular. The following is a non-exhaustive list of Terraform advantages : – Terraform can deploy infrastructure to multiple cloud service providers simultaneously…
What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines…
During the last DockerCon EU in Barcelona, I heard a lot about Helm with K8s architectures. It was also a good opportunity to write about it after attending to this conference. In a nutshell, Helm is a package manager for K8s and you may think of it like the other ones available on the Linux side with apt, yum or zypper to…
When your infrastructure landscape becomes larger and larger you definitely need a tool which helps you in managing your servers, no matter if pḧysical or virtual, running in the cloud or not. One tool (many others are around) which assists you in provisioning, configuration management and mass deployment is Ansible. If you look at the man page you can find…
