shushu
April 17, 2022, 11:31am
1
Hi,
We are currently migrating from mysqldb to singlestore.
We are using flyway in order to have versioned automated db migrations.
Flyway does not work out of the box with singlestore/memsql, but it does support adding database integration via JDBC drivers: Contributing Database Compatibility to Flyway .
According to the link above the way to add a new database is:
Have a JDBC driver (singlestore has one )
Implement the support in the flyway source code (as shown here )
There is an open pull request (since 2016) on this issue in the flyway github repository:
flyway:master
← pradheeps:master
opened 03:16PM - 01 Aug 16 UTC
Pull Request to address Issue [#1385](https://github.com/flyway/flyway/issues/13… 85)
Added the support for MemSQL. I have also included the MySQL Jdbc Driver along with the commit. MemSQL intentionally dropped certain MySQL features and hence needs separate implementation for it.
Also the flyway metadata table would be created as a MemSQL Reference table of row store type(will be kept in-memory) which would place this table in the master and all the leaf nodes.
In order to find out if it is a mysql or MemSQL connection,
i get the catalog from the database and see if it contains the ‘memsql’ and decide if it is mysql or MemSQL as memsql has a built-in database named memsql
I have extended the MigrationTestCase and passed all except for the ones that are unsupported.
ConcurrentMigrationTest is not supported as SELECT FOR UPDATE like syntax is not supported in MemSQL.
This is my first open source contributions and i hope it goes well.
Can this be addressed please ?
mkumar
April 19, 2022, 12:43am
2
Thank you for reaching out.
We will evaluate the work internally and provide you an update on when we can get something ready to be tested.
Regards,
Manish Kumar
1 Like
smaher
July 11, 2022, 8:49pm
3
mkheir
February 24, 2023, 3:04pm
4
Please be informed that SingleStoreDB Support was added to Flyway Teams & Enterprise Editions