I have a chat app made in node/socket.io.
Scalability factors have made us choose Erlang/Ejabberd/xmpp and it will replace node/socket.
I have a few questions:
Currently using MySql for chat storage. Best alternative considering scaling and consistency as major factor?
Reason why I am switching : a row for single message is not the best thing to do, but since I am using MySql I am not left with any other option. Growing userbase doesn't help either.(Mnesia|Riak|MySql|PosgreSQL??)