Dbamohsin.wordpress.com Website Review

We have recently come across an interesting scenario whereby a ja*a application living within a container in Kubernetes in GCP needs to There are several things that are a given in these situations; that the latency in the chatter between a cloud environment and an on premise environment will be HIGHER than two services talking in the same DC, and depending on the way you look at it, creating a high latency that developers and ops were lucky enough to have… So, althougth there is short term pain, there is definately a lot to gain in spending the resource effort in creating efficiencies in the So how do you start investigating an application developer complaining that his database queries are taking 70-80 seconds since moving the application to the cloud, queries that used to take 2-3 seconds? Mainly by breaking down the problem and finding little nuggets (or red Although we like to trust our developers, we also like to have proven data or logs to back up slowness claims. Our developer provided us with Kibana Logs and Graphana dashboards which showed that in some cases a particular heavy query was taking a significant amount of time (greather than 30 seconds up to 80 seconds). The application had a timeout of 30 seconds so in these cases, it was user impacting. We also had the query which was causing the problem, and from the Kibana logs we could see that the issue was only happening on big data We knew we had a problem with the query in production, but I didnt want to affect Prod performance even more so we backported a copy of the poorly performing dataset into our QA database environment. As an example, if we continued to use prod to test the Select query, we may be inadvertantly flushing out hot data from the buffer pool and Generally when I am investigating a problem, my approach is normally scientific and make sure I am doing both a FAIR TEST and a CONTROLLED EXPERIMENT. A fair test is important as when changing variables you should only change one thing at a time, and controlling