Transitioning Your Application

To transition your application, simply change the connection credentials to point to SingleStoreDB Cloud.

One thing to keep in mind is Code Generation. Code generation makes loading a schema into SingleStoreDB Cloud for the first time is slower than with MySQL. The first time SingleStoreDB Cloud encounters a table schema, it generates and compiles code that implements infrastructure around the table (memory allocation, inserts, deletes, iterations, etc.). Once a table is compiled, SingleStoreDB Cloud will be able to reuse it for the lifetime of your application — even if you restart the server or drop (and recreate) the table. The INSERT queries generated by mysqldump also have to be compiled exactly once.

When transitioning your application:

  • Queries that throw errors most likely correspond to unsupported syntax (see SQL Reference Overview for supported SQL surface area).