by Angela Guess
Matt Weinberger of DevopsAngle reports, “MySQL familiarity or NoSQL scalability seems like a binary choice. But Google’s F1 – the new relational database management system (RDBMS) underpinning several of Google’s customer-facing, business-critical advertising services – lays claim to combining the best of both worlds. The F1 system is detailed in a paper/presentation entitled “F1 – The Fault-Tolerant Distributed RDBMS Supporting Google’s Ad Business,” co-authored by several Googlers and published earlier this month. ‘F1 implements rich relational database features, including a strictly enforced schema, a powerful parallel SQL query engine, general transactions, change tracking and notification, and indexing, and is built on top of a highly distributed storage system that scales on standard hardware in Google data centers,’ as the abstract puts it.”
He continues, “This comes at a cost of higher write latencies, when compared to Google’s legacy MySQL deployments. But thanks to F1′s distributed nature, it was apparently relatively simply to deploy it underneath those aforementioned ad services with no downtime. Both the simplicity and the lack of downtime are critical, given the fact that Google’s ad business handles tens of terabytes replicated across thousands of machines over any given 24-hour period, as per the presentation. The presentation describes the underlying architecture of F1 better than I could, but the general idea is that it was developed alongside Spanner, Google’s new low-level storage system and the descendent of BigTable. In addition to the stateless server and a pool of workers for query execution, F1 consists of sharded Spanner servers, with data stored in Google File System (GFS) and in memory.”
photo credit: Google
