Tech by KJ

This article demonstrates Oracle GoldenGate 19c downstream Integrated Extract using archived redo cascaded through an Oracle Active Data Guard standby. FETCHUSERIDALIAS is used to redirect supported runtime fetch operations to the ADG standby, reducing the need for Extract to query the production primary database directly. Oracle GoldenGate downstream capture is specifically designed to offload the primary/production database from where the data is being captured. This architecture is useful for reducing the source database involvement and overhead but at the cost of additional implementation complexity compared to the normal GoldenGate configuration.

Continuous Integration and Continuous Deployment, commonly known as CI/CD, has become an important part of modern application delivery. Instead of manually packaging application files, copying them to servers, restarting services and validating the deployment each time, a CI/CD workflow allows these steps to be automated and repeated with less manual effort. In this article, I will provide an overview of how a CI/CD workflow can be designed using OCI DevOps and other Oracle Cloud Infrastructure services by referencing a CI/CD deployment project I created. The goal of the project was to build a practical deployment workflow for a multi component Laravel based application consisting of a frontend, backend and middleware layer. The project uses OCI DevOps build pipelines, deployment pipelines, OCI Vault, OCI Artifact Registry, OCI Compute, OCI Networking, OCI Load Balancer, OCI Logging, OCI Notifications and GitHub integration.