According to document memsql is advisable to use OLTP. How to maintain the foreign key relationship between two tables in memsql?
Regarding OLTP vs OLAP it really depends on your usecase.
Foreign keys are not supported right now. It’s on our roadmap.