Connecting to MemSQL from PHP codeigniter application
echo '<pre>';mysql_connect(":var/lib/memsql-ops/data/=memsql.sock",'root','');$q = mysql_query('SHOW DATABASES;');while ( $row = mysql_fetch_array($q, MYSQL_ASSOC) ) : print_r($row);endwhile;
In theory it should.
Take a look here to see all the supported/unsupported commands
http://developers.memsql.com/docs/1b/
The one big downside i can see so far is there is a limit 2 two table joins per statement.
Ruby active record works with MemSQL. You can use mysqldump to port the data over.