How FriendFeed uses MySQL to store schema-less data (backchannel.org)
- Highlight Loc. 22-25 | Added on Wednesday, April 04, 2012, 05:52 PM
We index data in these entities by storing indexes in separate MySQL tables. If we want to index three properties in each entity, we will have three MySQL tables - one for each index. If we want to stop using an index, we stop writing to that table from our code and, optionally, drop the table from MySQL. If we want a new index, we make a new MySQL table for that index and run a process to asynchronously populate the index without disrupting our live service.
