0
Ülevaatamisel

Support for Memsql DB

Deepak Jain 5 aastat tagasi uuendatud 4 aastat tagasi 2

Is there any plan to provide support for MemSQL in near future?

Vasta

Vasta
Ülevaatamisel

Hello Deepak,

We have no dedicated support for MemSQL DB, but this database is wire-compatible with MySQL. I'm guessing then that maybe MySQL DDL script will work. However, I haven't tested it, so treat this only as a clue.

We will definitely investigate this further.

Regards,

Luke

Vasta
Ülevaatamisel

Hello Deepak,

We have no dedicated support for MemSQL DB, but this database is wire-compatible with MySQL. I'm guessing then that maybe MySQL DDL script will work. However, I haven't tested it, so treat this only as a clue.

We will definitely investigate this further.

Regards,

Luke

Hi Luke,

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 ?

Regards

Deepak