Live data from Hacker News

Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

ai.google

11–20 of 21 posts

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#11
huh...I interviewed with Google about 4-5 years ago and one of the interviewers spent a bunch of time asking me questions about something just like this, but from a "theoretical" perspective.

Pretty interesting to see this actually happen and see where Google ended up with it.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#12

The most scalable, fastest reaction time and simplest log processing tool is awk.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#14

Let me take this opportunity to say I'm appalled all research at Google has been rolled into "AI." Ubiq has nothing to do with machine learning, but you can't access it without wading through a swath of Google-branded AI marketing material. The domain research.google.com now redirects to ai.google. If you want to search for any research publications by Google employees, you will be searching on a domain that first an…

It's not just research. Android improves battery by 30%, no one bats an eye. But 1/3 of that improvement is thanks to machine learning - off to the Google IO we go!

30% and 1/3 not the exact real numbers, just showing a concept.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#15

The most scalable, fastest reaction time and simplest log processing tool is awk.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

SparkSQL doesn’t support gz. Are your logs splittable on a file-by-file basis or are they in gz format?

Where are your logs stored? Is that a distributed storage? Will SparkSQL not eat all of the bandwidth of it’s ethernet interfaces?

Yeah; sure.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#16

The most scalable, fastest reaction time and simplest log processing tool is awk.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

Off-topic, but do you actually run ad-hoc SparkSQL queries on the whole dataset sometimes? Are the logs actually stored as text files on disk? How long does such a query take and/or how many racks of machines do you need for that? Should be more than 1 million drive-seconds just to read the data from disk, right?

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#17

Earlier quoted context omitted.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

SparkSQL doesn’t support gz. Are your logs splittable on a file-by-file basis or are they in gz format? Where are your logs stored? Is that a distributed storage? Will SparkSQL not eat all of the bandwidth of it’s ethernet interfaces? Yeah; sure.

It's not so much that SparkSQL doesn't support gz as that gz is slow because you can't parallelize the reads. Regardless, parquet format in hdfs so yarn can allocate containers local to the chunk to be processed. Scales nicely.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#18

The most scalable, fastest reaction time and simplest log processing tool is awk.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

You don't, you process the logs right away with ask as in piping to awk store the statistics in a file.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#19

Earlier quoted context omitted.

Ok, I'll bite. Most scalable, you say. I have 250TB of Django logs, how do you recommend I use awk to process them to determine the 99th percentile response time that's faster than using SparkSQL?

SparkSQL doesn’t support gz. Are your logs splittable on a file-by-file basis or are they in gz format? Where are your logs stored? Is that a distributed storage? Will SparkSQL not eat all of the bandwidth of it’s ethernet interfaces? Yeah; sure.

> SparkSQL doesn’t support gz

Yes it does. Source - use Spark SQL routinely. You're right that multiple small Gzipped files are not an ideal input source as it'll create a bunch of small tasks, but Spark definitely does support GZ.

Re: Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)

#20

Earlier quoted context omitted.

SparkSQL doesn’t support gz. Are your logs splittable on a file-by-file basis or are they in gz format? Where are your logs stored? Is that a distributed storage? Will SparkSQL not eat all of the bandwidth of it’s ethernet interfaces? Yeah; sure.

It's not so much that SparkSQL doesn't support gz as that gz is slow because you can't parallelize the reads. Regardless, parquet format in hdfs so yarn can allocate containers local to the chunk to be processed. Scales nicely.

Yeah, but you are making an assumption I’ve got these 350Gb of logs in HDFS format. Which takes time to set up.
Post reply on HN