Composite index to evaluate ORDER BY and PREDICATE togetherA few weeks back I have written a story regarding the indexing strategy on database table to improve the performance of a query in one of…Jan 29, 2021Jan 29, 2021
Micro Services communication — Synchronous/Asynchronous, Pull/Push or queue basedWhile everyone understand that micro service based applications has its own set of benefits like scaling individual component, independent…Dec 30, 2020Dec 30, 2020
API driven application Vs API Drive businessMicro service based application is the new trend now. The foundation of this architecture is the capability of the various application…Nov 30, 2020Nov 30, 2020
Auto Scaling in CF based PaaS cloud — Myths Vs realityRecently while exploring the best way to scale our CF based application on IBM cloud, we busted one of our belief on the auto scaling part…Nov 20, 2020Nov 20, 2020
What’s better — Horizontal or Vertical Scaling for effective resources managementAuto scaling generally comes with its 2 flavors- Horizontal and vertical scaling. While horizontal means increasing the number of…Nov 17, 2020Nov 17, 2020
Importance of timeouts for webpages, APIs and SQLs micro service based applicationIn a micro service based application, we generally have independent applications (aka micro services) developed based on the single…Nov 12, 2020Nov 12, 2020
Selecting the correct Index for better database query performanceBeing an SRE lead, my first responsibility is always to make sure that system is performing at optimal level and remain stable…Nov 4, 2020Nov 4, 2020
Best place to enforce Business Rules and constraints on Data attributesRecently as part of the activity of making our application more stable and improve performance, we were trying to find out the best…Oct 29, 2020Oct 29, 2020
DB migration — Monolithic to Micro Services — Challenges and guidelinesTo continue from where I left in my last story, today I like to list down few of the guidelines/challenges we face during our DB migration…Oct 10, 2020Oct 10, 2020
Database Journey from Monolithic to Micro serviceMicro service based architecture for the applications are quite a trend today. This popularity is backed by the advantages like…Oct 7, 2020Oct 7, 2020