Re:How We Built r/Place
by tupshin on Thursday April 13, 2017 @03:52PM
(#14110375)
Our initial approach was to store the full board in a single row in Cassandra and each request for the full board would read that entire row.
This is the epitome of an anti-pattern .I sincerely hope that this approach was floated by somebody who had never used Cassandra before.
Even if individual requests were reasonably fast, you are sticking all of your data in a single partition, creating the hottest of hot spots and failing to leverage the scale out nature of your database.
Re:How We Built r/Place
by spyspy on Thursday April 13, 2017 @04:06PM
(#14110483)
This entire project is just an elaborate hack day project. There's no reason to fault them for trying new and interesting hacks to get it off the ground. They realized it wasn't the right method and moved on. End of story.
This is the epitome of an anti-pattern .I sincerely hope that this approach was floated by somebody who had never used Cassandra before.
Even if individual requests were reasonably fast, you are sticking all of your data in a single partition, creating the hottest of hot spots and failing to leverage the scale out nature of your database.