> I've seen multi-master HA architecture work out great for 10M+ DAU games
could you tell what kind of DB was that so we can understand if it is apple to apple comparison to multi-master PG?
could you tell what kind of DB was that so we can understand if it is apple to apple comparison to multi-master PG?
Nowadays it seems the answer has somehow become "Pay MongoDB a ton of money for a support contract" and call it a day (Fortnite by Epic Games). Let's just say this isn't really my style, but somehow the game does work. To be real with you, keeping track of player scores, doing lobby matchmaking, and storing a few hundred or thousand items is pretty straightforward, even at "high-scale".
MyISAM didn't support ACID transactions, thus can't be apples to apples comparison, its just very different niches.
There are plenty of distributed databases on the market today which could be used if you don't need ACID transactions.
MyISAM is mostly a huge "NOPE!" from me -_-
So it was sharded? And no cross-shard queries or txns were allowed?
Or it was replicated? And no FKs were allowed because of consistency problems?