Connect to MemSQL from a PHP codeigniter application

Question

MemSQL is new . Stackoverflow did not return a search result with the keyword "MemSQL". MemSQL claims absolute resemblance to MySQL, except that MemSQL is 30 times faster. I just studied MemSQL and came across this thought. Failed to try, but I have a very simple question related to DataBaseConnector.

There is no specific instruction that I could learn about how to connect an existing PHP application with MySQL SQL to the MemSQL database. However, this MemSQL page says:

To translate the application, just change the connection to point to MemSQL.

Now, someone with experience will find out if I only changed the port number in my MemSQL service, then all the currently written SQL files will work fine, since they worked with MySQL? Will it also work with currently written Active-Records operations in my codeigniter application?

[ps considering that I exported my data from MySQL and imported my data into MemSQL, as indicated on the same page.]

Answer 1

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; 

Answer 2

In theory, this should be.

Look here to see all supported / unsupported commands.

http://developers.memsql.com/docs/1b/

The only big drawback that I see so far is the restriction on two tables for each statement.

Answer 3

Active Ruby Record works with MemSQL. You can use mysqldump to transfer data.