You are right in saying that MemSQL is wire compatible with MySQL however for modelling your DW in Memsql would need few more considerations for physical data model. Memsql has many features which are not available in MySQL which needs special syntax and snippets in DDLs. For example
- Selecting type of memsql tables (memory, Column store , reference tables etc)
- Selecting Shard keys
Also do you have any support for Data Vault ?
Customer support service by UserEcho