Agenda: In this article, I intend to provide a high level overview about connection management in databases, quick comparison of implementation approaches for connection pooling and towards the end provide an example of connection pooling in Cloud SQL MySQL in Google Cloud Platform (GCP). Introduction: Applications these days tend to…

One size fits All approach has seldom worked; neither in human lives nor in technology world. Right choices have to be made to thrive and succeed. Coming to the main point — databases have always been primarily used as persistent stores for data with appropriate data models to insert and…

Yes, you read it right. I am talking about a huge, incredibly busy Internet/Web Scale application running with Oracle Relational Database at its backend. While Oracle database has been time tested over decades to run the biggest of OLTP and OLAP implementations (packaged and bespoke stacks) across the industries right…

In Part 1 of this series, we had a quick introduction of Oracle GoldenGate as a Master of all Trades tool in terms of being a true Enterprise Data Integration software. In this article, Part 2, I am going to cover one of the most industry relevant use-case of Oracle…

In this 2 series blog, I am going to talk about Oracle GoldenGate. Part 1 is about quick introduction and tells us about Oracle GoldenGate capabilities. Preface Data availability and Data Dissemination have become quintessential need of today’s world where everything needs to be known and made available in real-time…