Dear all, especially VRM users,
As you have noticed, VRM is not behaving to its usual performance. In this central thread, I would like to shed some light on the situation and give you updates. Hopefully soon, I can update the post-mortem of what happened and how we solved it soon.
Influx database issues
About 2 weeks ago, we started noticing that on Monday mornings, the Influx database was slower than usual. To try and improve it, we upgraded to a new Influx release. Unfortunately, that led to a worsened state. With the amount of data flowing into VRM, a small queue of database queries quickly escalates to overall slow performance and sometimes even downtime. For some days in between, we thought the database recovered, only to be followed up with more queries being slow and eventually timing out. We are now in the situation where our devs as well as Influx engineers need to manually tend to the database for it to run smoothly.
Temporary damage control
Some things that we did (and still do) as soon as we notice the database having issues is:
- Disabling forecasts
- Putting ‘State advanced widgets’ behind a button instead of auto-loading them
All to prevent you from noticing the issues in your day to day.
Obviously in the regressed state of the database in the last couple of days, you did notice it everywhere in VRM.
Fallbacks / Long term solutions
I have already seen some suggestions as to how we can in the future make sure you have some data in VRM, even when our database has issues like this. I truly appreciate your suggestions, but I also hope that you understand that at this moment in time, all of our efforts are going into fixing the database. After it is stable again, we will definitely look into long term solutions and plan B (C and D) in case this happens again. We have the blessing and the curse to work on a platform that doesn’t have many equals in the wild, so it is not as easy to borrow ideas from how other platforms deal with these kind of things.
Thank you for your patience
Rest me to thank you for your patience. We know that many of you are using VRM every day, and we want it to be as fast as it can for you. We are really proud of the VRM platform and how it kept up with the growth in data so far, so I am sure we will get back to that state very soon.
On behalf of the VRM team,
Barbara