Browsing all articles from April, 2017
Apr
6

Optimized database maintenance

This is yet another update that might only be interested to the geekiest part of our customer base… but will definitely improve the lives of all of our customers, so it was well worth the effort.

(And yes, our engineering team has been on fire lately!)

Every software that deals with a database (of users, of synonyms, of articles, of categories, etc.) needs to make sure that its database and all of the tables inside the database are always in top-notch working shape.

Anything less than top-notch shape and you’re risking data loss, data corruption and possibly even security issues. And we’re always working crazy hard to stay not 1 step, but 20 steps ahead of all of these issues. 😀

This time around we rehauled the system we use for checking the condition of all our databases across our servers. Our previous system worked really well, however as the numbers of users/articles/synonyms in our databases kept on growing, it started to slow down the rest of our systems from time to time.

It was nothing too drastic, but in some cases our services became noticeably slower for about 20-25 seconds once or twice an hour. And our team was super happy to attack this not-even-an-issue-yet with all their technological might.

The new system is working like a charm, and the improved robustness and responsiveness of Spin Rewriter is something that I’m sure all our users will appreciate. 😀

Follow me on Twitter! Follow me on Twitter!
You can always stay up-to-date with our latest and craziest projects ...

Categories:

Monthly Archives:

I mostly write about:

Who is Aaron?

I'm a guy who started his own successful online business back in 2007. I was lucky enough to see my business expand 300+% every year.

At the moment my team and I reach over a million unique customers each month and always do our best to deliver the best quality services.