Have a look into singlestore - it seems like a nice fit for this use case.