Description Learn how I replicated on-prem Oracle CDC data to BigQuery using Debezium and Google Cloud Pub/Sub. A step-by-step guide based on real-world experience. Lately, I’ve been working on modernizing how we replicate data from […]
698 total views, 2 views today
Description If you are planning to modernize your legacy middleware stack by migrating from TIBCO EMS to GCP Pub/Sub. In this blog will see the key challenges, benefits, and step-by-step strategies for a smooth transition. […]
525 total views, 1 views today
In this post , I will demonstrate how to create a PostgreSQL and MySQL databases in GCP CloudSQL and how to access the database via cli and directly logging into the VM as well . […]
1,486 total views, 3 views today
Welcome to Cloud Shell! Type “help” to get started. Your Cloud Platform project in this session is set to qwiklabs-gcp-01 Use “gcloud config set project [PROJECT_ID]” to change to a different project. parwezgcp01@cloudshell:~ (qwiklabs-gcp-02-18918b9b83e4)$ bash […]
1,279 total views, 2 views today
1. Get the credential of the GKE Cluster Welcome to Cloud Shell! Type “help” to get started. Your Cloud Platform project in this session is set to qwiklabs-gcp-04-302f12498b68. Use “gcloud config set project [PROJECT_ID]” to […]
1,316 total views, 1 views today
Steps: Create a VPC It will by default create router,securty groups ,NACLS, route tables Create internet gateway Create 2 subnet in the VPC One public subnet, one private subnet Create one route table in which […]
1,681 total views
Updating the Exadata System Software on database servers is a process that entails patching the entire Oracle Linux operating system, and related Exadata software rather than just updating single packages. Updating the operating system does […]
1,485 total views, 1 views today
Today we will see how to generate plans in graphical form freely in PostgreSQL. Try to generate a plan in json format by using the below prefix before any query you want to check plan […]
1,130 total views
Table partitioning is the practice of splitting a large table into smaller sub-tables and each sub-table is created using separate CREATE TABLE commands. So every time you query data, PostgreSQL scan and process a smaller […]
1,120 total views, 1 views today
All information associated with a relation is stored in several different forks1 , each containing data of a particular type. At first, a fork is represented by a single file. Its filename consists of a […]
1,343 total views, 1 views today