iln-systemdesign
spilgame-mpserver
Spilgames Distributed Storage Platform
Spilgames Distributed Storage Platform
Role: System Design/Lead developer
Client: Spilgames
from November 2011
until September 2012
Together with the Company Architect
Sascha van Gemmert I designed and built an Erlang based application that abstracted the existing data in the company's MySQL databases, with the following features:.
- the data were accessed via a single key (key-value store).
- the actual storage initially remained on MySQL, but gradual extension and replacement with other storage back-ends was fairly easy and well documented.
- query level attributes defined what version of storage was accessed. This allowed a gradual migration of storage from for instance a legacy SQL join to a clean storage schema.
- fault tolerance and horizontal scalability of the platform were achieved by building on Erlang OTP and by sharding the MySQL databases.
This system was explained in some detail by my former Spilgames colleague Enrique Paz-Pérez in this Erlang Factory conference talk
References: