Preetam Jinka

Recent Posts

Published by Preetam Jinka on Jun 22, 2017 4:45:00 PM

Exponential Smoothing for Time Series Forecasting

Time series anomaly detection is a complicated problem with plenty of practical methods. It’s easy to find yourself getting lost in all of the topics it encompasses. Learning them is certainly an issue, but implementing them is often more complicated. A key element of anomaly detection is forecasting - taking what you know about a time series, either based on a model or its history, and making decisions about values that arrive later.

Read More
Published by Preetam Jinka on Jan 27, 2017 3:20:50 PM

Three Things That Differentiate Amazon Aurora From MySQL

It's not always obvious what makes one database type distinct from another. What are the most significant ways that Amazon Aurora is different from MySQL? Clear separators aren't always featured or widely known, but even slight variables between two databases can prove valuable in choosing which one is right for you and your organization.

In the case of Aurora, there are at least three interesting things that make it unique and that present opportunities for particular uses. (Thanks in advance to @saileshkrish for helping us stay in-the-know on what Aurora can do.)

Read More
Published by Preetam Jinka on Nov 9, 2016 10:15:00 AM

What is ACID and How Should I Think About It As a Developer?

For the average reader, the phrase “expert in ACID” most likely evokes a picture of either an eminent chemist or a jolly Deadhead. However, in the world of computer science, an understanding of "ACID" means something a bit different (though not mutually exclusive!). When dealing with relational databases, the term refers to a set of properties that describe certain characteristics of transactions.

Read More
Published by Preetam Jinka on Sep 28, 2016 3:43:12 PM

Optimizing VividCortex’s Samples View: Part 2

A few weeks ago, I wrote a blog post explaining how sketch sampling methods can be employed to achieve fast 30-day data visibility for monitoring users. The problem we faced was that with that standard of retention, we’ve frequently seen systems that involve nearly a million query samples in a 30-day window, meaning that special solutions are needed in order to avoid overloading users’ browsers.

The solution we’ve found lies in a hash ordering that's proven to be both surprisingly simple and efficient. In this Part 2 post, I’ll look at why it works so well.

Read More
Published by Preetam Jinka on Sep 23, 2016 3:32:59 PM

How Color Schemes and Query Latency Bands Help With Database Monitoring

In this post, we’ll explore some powerful visualizations that are vital to monitoring, and we’ll take a look at a few of the attributes that make them so effective—specifically, color schemes. Colors are a central element for many effective visual tools, and whether colors are used to communicate information more clearly; to emphasize certain nuances of data; or to achieve an aesthetic or emotional response, they are a major part of a visual’s impact.  To keep things simple, this blog post will focus our examination on metrics that show us how work is distributed.

Read More
Published by Preetam Jinka on Aug 25, 2016 4:48:32 PM

Optimizing VividCortex’s Samples View: Part 1

Deterministically Subsampling Queries: A Million Samples?!

VividCortex lets users drill-down into their data up to a single-second granularity, and, using specialized sketch sampling methods (check out our free ebook about Sampling a Stream of Events With a Probabilistic Sketch for a look at one way we employ sampling to handle big data sets) we’re able to offer customers up to 30 days of data retention. As you can imagine, 30 days of samples represents a lot of data. Exactly how much?

Read More
Published by Preetam Jinka on May 4, 2016 1:44:52 PM

How VividCortex Uses the New Generated Virtual Columns Feature in MySQL

In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.

Read More
Published by Preetam Jinka on Jun 30, 2015 4:54:00 AM

Authentication with Middleware using Siesta

We recently added a token-based authentication example to the Siesta repository that provides an excellent starting point for building authenticated APIs using our lightweight HTTP handler library for Go. This example, modeled after our own internal API services, demonstrates features and practices that we’ve developed and found useful after using Siesta in production for many months.

Read More

Subscribe to Email Updates

Posts by Topic

see all