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??)How to send my chat messages from javascript to my Erlang code for storing/processing. I have done web development in past and ajax made my task very simple for client-server interaction. Node/socket event handler made my job easy while developing chat app. How will server and client interact in this scenario?