NOSQL GAMES Patrick Huesler wooga GmbH D o you like to play? - PowerPoint PPT Presentation

NOSQL GAMES Patrick Huesler wooga GmbH

D o you like to play?

technical challenges

monthly acti v e use r s 20,543,500 f o r D iamond D ash http:/ /www.appdata.com/apps/facebook/127995567256931-diamond-dash (03/10/2012)

daily acti v e use r s 3,871,133 f o r D iamond D ash http:/ /www.appdata.com/apps/facebook/127995567256931-diamond-dash (03/10/2012)

b ackend t r affic up to 6,500 RPS f o r M onste r W o r ld

w hat does mean that f o r a Database?

r ead /wr ite r atio ? write heavy

W ooga ’ s EVOLUTION o f a r chitectu r e

Facebook Game backend Flash Reporting iOS

B uilt w ith LAMP ... w ell , nginx instead o f apache

mys q l does scale

f o r ce r tain use cases

w ith the r ight people

T o the cloud

L et ’ s use Rails instead o f PHP

load balancer app server app server app server master shard 1 master shard 2 slave shard 2 slave shard 2

long story sho r t

load balancer app app app app app app app app app app app app app app app app app app app app app app app app db db db db db db db db db db db db db db db db

diffe r ent use case

a r cade games Are NOT f a r ming games

Tis is NOT going to w o r k

b ut the r e is Light at the end o f the tunnel

M o v e SLOW PARTS to r edis

rinsE and REPEAT

b ack to dedicated

M o r e bang f o r the b uck

F aste r Machines

f aste r network

L et ’ s use REdis all the w ay

load balancer app server app server app server redis redis slave

REDIS HASH

all is w ell in Redis Land

Memory Leaks

ho w does BGSAVE w o r k again ?

dumps a r e no longer w o r king

Tis is NOT going to w o r k

Fx it w ith Restore on Demand

R edis Disk Store ( ne v e r r eally suppo r ted )

L et ’ s go Stateful

no database is f aste r than no data b ase

L et ’ s use S3 all the w ay

L et ’ s use erlang

http://www.slideshare.net/wooga/from-0-to-1000000-daily-users-with-erlang

http://www.slideshare.net/wooga/from-0-to-1000000-daily-users-with-erlang

p r oject SPARTAN

it has to b e ready yeste r day

I t has to scale eno r mously

node.js

W hat DB Scales w ithout sha r ding ?

w hat DB has masterless replication?

Async Saving

Riak

good enough for now

good enough for good

li f e w ith Riak

1 { 2 "userId" : 1000000011100 , 3 "xp" : 20 , 4 "coins" : 400 , 5 "cash" : 300 , 6 "rooms" : [ 7 { 8 "id" : 1 , 9 "type" : "x-ray", 10 "status" : "busy" 11 } 12 ] 13 } 14

no SPoF is plain a w esome

b itcask w as suboptimal f o r ou r use case

D o not map/reduce o v e r all keys !

d r eadfl ulimit

the tale o f riak Attach

M onste r s go Mobile

A n i OS client is NOT a flash client

do w e need a database at all ?

C ould w e just use s3 in a stateless a r chitectu r e ?

do w e need a backend at all ?

w hat i f the client wr ites to S3?

wooga.com/ jobs