Author: parwez
My Experience: Replicating On-Prem Oracle CDC to BigQuery Using Debezium and Pub/Sub
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
Modernizing Legacy Middleware: Migrating from TIBCO EMS to GCP Pub/Sub
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
Create a Cloud SQL PostgreSQL/MySQL database
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
Creating vpc peering with on prem network in GCP
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
Create a 3 node docker mysql database which will be orchestrated by GKE
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
How to access ec2 instance residing in private subnet
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
Patch db node(linux server node) for ExaCC from oel6 to oel7
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
Check the PostgreSQL plan for visualization
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 partition in PostgreSQL
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
Files and Forks in Postgres
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