What kind of data storage and processing is needed
-
Hi,
So after reading a few posts here I have realised it a big deal to crawl the web and index all the links.
For that I appreciate seomoz.org's efforts .
I was wondering what kind of infrastructure they might need to get this done ?
cheers,
Vishal
-
Thank you so much Kate for the explanation. It is quite helpful to better understand the process.
-
Hi vishalkhialani!
I thought I would answer your question with some detail that might satisfy your curiosity (although I know more detailed blog posts are in the works).
For Linkscape:
At the heart of our architecture is our own column oriented data store - much like Vertica, although far more specialized for our use case - particularly in terms of the optimizations around compression and speed.
Each month we crawl between 1-2 petabytes of data, strip out the parts we care about (links, page attributes, etc) and then compute a link graph of how all those sites link to one another (typically between 40-90 billion urls) and then calculate our metrics using those results. Once we have all of that we then precompute lots of views of the data, which is what gets displayed in Open SIte Explorer or retrieved via the Linkscape api. These resulting views of the data is over 12 terabytes (and this is all raw text compressed data - so it is a LOT of information). Making this fast and scalable is certainly a challenge.
For the crawling, we operate 10-20 boxes that crawl all the time.
For processing, we spin up between 40-60 instances to create the link graph, metrics and views.
And the API servers the index from S3 (Amazon's cloud storage) with 150-200 instances (but this was only 10 1 year ago, so we are seeing a lot of growth).All of this is Linux and C++ (with some python thrown in here and there).
For custom crawl:
We use similar crawling algorithms to Linkscape, only we keep the crawls per site, and also compute issues (like which pages are duplicates of one another). Then each of those crawls are processed and precomputed to be served quickly and easily within the web app (so calculating the aggregates and deltas you see in the overview sections).
We use S3 for archival of all old crawls. Cassandra for some of the details you see in detailed views, and a lot of the overviews and aggregates are served with the web app db.
Most of the code here is Ruby, except for the crawling and issue processing which is C++. All of it runs on Linux.
Hope that helps explain! Definitely let me know if you have more questions though!
Kate -
It is no where near that many. I attached an image of when I saw Rand moving the server to the new building. I think this may be the reason why there have been so many issues with the Linkscape crawl recently.
-
@keri and @Ryan
will ask them. my guess is around a thousand server instances.
-
Good answer from Ryan, and I caution that even then you may not get a direct answer. It might be similar to asking Google just how many servers they have. SEOmoz is fairly open with information, but that may be a bit beyond the scope of what they are willing to answer.
-
A question of this nature would probably be best as your one private question per month. That way you will be sure to receive a directly reply from a SEOmoz staff member. You could also try the help desk but it may be a stretch.
All I can say is it takes tremendous amounts of resources. Google does it very well, but we all know they have over 30 billion in revenue generated annually.
There are numerous crawl programs available, but the problem is the server hardware to run them.
I am only responding because I think your question may otherwise go unanswered and I wanted to point you in a direction where you can receive some info.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Help! Need to Get Traffic Back Up in Saturated Market
I was looking in one of my client's Google Analytics profiles, and noticed that they had two major drops in traffic before we started working with them—and they've never really recovered. The first, and most significant drop was around January 2015. And then the again, but not as drastic of a drop, was around September 2015. They are a heating and cooling company, but they are located out west so this shouldn't be a seasonality thing. Here is a link to what the BIG drop is traffic looks like in January 2015: http://imgur.com/a/Y1s8U To get a clearer picture, here are the numbers for the overall website traffic:
Reporting & Analytics | | BlueCorona
September 1, 2015 - September 30, 2015: 30,923 sessions
September 1, 2015 - September 30, 2016: 13,768 sessions Year over year traffic to the website dropped by 55%. Here is a link to what year over year looks like in Google Analytics: http://imgur.com/a/TPdJQ Like I said, we weren't working with them at the time so I don't know specifics about what might have caused this, but their numbers have never even come close to reaching what they used to be prior to the noticeable drop after September 2015. Does anyone have any insights into why this might be? Was there an algorithm change back then that could still be impacting them? Any ideas how to get them back to where they once were? Any input is greatly appreciated! Thanks.1 -
Conflicting data in Google Analytics
Hi Guys I've been looking at the data for a client in Google analytics and I was wondering if anyone knows why some of the data doesn't tally up. In my case its the following: Under Aquisition
Reporting & Analytics | | Relative
No of Sessions for a Keyword shown in Organic Search tab (compared to)
No of Clicks for a Query in the Search Engine Optimisation tab For example, for a brand term, Google are showing 17 Sessions in Organic Search.
For the same term Google are showing 90 Clicks in the Queries section of Search Engine Optimisation OK, we know that Google are a little cloak and dagger regarding keyword data but surely Sessions and Clicks for the same keyword should be identical unless I'm missing something.0 -
Need help with excluding IP addresses in Google Analytics
In Google Analytics, are you able to add more than 1 IP address to an exclude filter? I found this article, http://www.creare.co.uk/filter-multiple-ip-addresses-in-google-analytics, but wasn't sure if it was the right way to do this or if I should create a new filter for each IP address. Also, when I try to create a new filter, it only will let me select from a list of profiles I have created whereas on other accounts I've been able to create several new filters without any problems. Does anyone know why this might be?
Reporting & Analytics | | jfeitlinger0 -
How can we stop Google analytics pulling in data from another site?
We have a few accounts under one Google login. They all have separate Google analytics codes but one of the sites is somehow pulling in some data from another site but the other site has not got the same analytics code on it. Not sure how this is happening and what we can do about this, is it a bug in the Google Analytics system? Any help would be appreciated.
Reporting & Analytics | | dentaldesign0 -
Google Analytics showing discrepancy in Geo data
My site is related to UAE and the Gulf region. An year ago, Google Analytics abruptly started showing high incoming traffic from USA (Visits grew from 50k/month to 500k/month) while the overall traffic was stagnant. An year down the line, this has now been reverted back to normal nos and the overall traffic is still maintained. What could be a possible explanation for this discrepancy? Since this reversal has also now boosted traffic nos for other countries, should we rely on this data? Or is it polluted?
Reporting & Analytics | | vivekrathore0 -
URL String Tracking Question--Need help!
I am doing some research for a freelance project and found a URL receiving a decent amount of traffic from search with this url string after the normal page url (xxx.com/credit-card-counseling.aspx?match=e&query=debthelper.com&id=22097628847&id=1810807655) Is this some sort of GA tracking code? Why would it be used on that page to track organic search hits if that happens automatically? Would love some help figuring this out! Thanks,
Reporting & Analytics | | RickyShockley0 -
Google Making all searches secure - "Not provided" data to increase in Analytics
A lot of you might already be aware of the recent Google change at encrypting all search activity except for clicks on ads. Rand did a whiteboard session on this recently. How is everyone planning to adjust their research data to accommodate for this change?
Reporting & Analytics | | SEO5Team0 -
I have data missing in Google and don't know who to turn to for help
Hi everyone, I know this isn't the 'Google help forum' but I'm stuck and I hope someone here might be able to point me in the right direction. For a period last month - Thursday 22nd to Sunday 25th November Google Analytics reports our site as having 0 visits. In addition we have two days which were strangely low - Weds 21st 105 visits, Weds 28th Nov 78 visits. We normally get between 1000 and 1200 visits on a weekday from a global audience (I know that was the Thanksgiving weekend, but the US accounts for ~10% of total traffic). Has anyone else had this problem? If so, what did you do? The "report a bug" board on the Google help forum has a few entries like this, people with 0 visits shouting "help!" into the void with no response. Ideas?
Reporting & Analytics | | StevenHowe0