Transition from MySQL to SingleStore
On this page
SingleStore is wire-compatible with MySQL, which makes it easy to transition your data and application from MySQL to SingleStore.
To transition your data and application from MySQL to SingleStore:
-
Migrate your data with SingleStore Flow.
-
Transition your application.
1. Migrate your Data with Flow
Use SingleStore Flow to migrate your data from MySQL to SingleStore.
SingleStore intentionally does not support all the MySQL features.
You can also migrate your data using mysqldump
, although it may require manual scripting and operational effort.
2. Transition your Application
Update the connection configuration and credentials in your application to connect to a SingleStore deployment.
A key consideration to note is Code Generation, which plays a significant role in SingleStore's superior query execution performance.
Similarly, when using mysqldump
to migrate your data, the INSERT
queries generated by mysqldump
also have to be compiled exactly once.
When transitioning your application:
-
Even if you’re connecting to SingleStore locally, use the explicit host
127.
instead of0. 0. 1 localhost
.Most MySQL clients will resolve localhost
to use the global MySQL socket file and ignore the port setting.Refer to FAQ for more information. -
As you run through the application, monitor the memsql.
log file. -
Queries that throw errors most likely correspond to unsupported syntax (refer to SQL Reference for supported SQL surface area).
Last modified: September 10, 2025