Question
· Jan 18, 2017

Migrate Mysql to Cache

Hy.

 

Is there a way to migrate MySql db to Cache (like export from MySql and import to Cache - not just the data, but the properties of the table too)?

 

Thank you.

Discussion (3)0
Log in or sign up to continue

Just been in same situation yesterday and the migrate from ODBC worked for us. We needed the data in Cache for Reports, Dashboards, etc.

The new challenge is: the application that uses MySQL is not yet re-coded to use Cache, so the data is still written in MySQL. Using ODBC to do what we want was giving all sorts of errors... (due to restrictions and limitations for external sources as mentioned in these docs.).  After migrating the data, no issues at all.

Is there a way OR does anyone know how to keep the migrated data always in Sync? If data is written in MySQL it's automatically synced into Cache (... well in Cache speak this will be shadow, mirror, etc). Or custom polling needs to be written?

Regards;

Anzelem.