Hi there. I got a lab system that was recently migrated from MySQL to Cassandra. It was noted that the SLDMADB folder didn't contain any folders or files for about an hour and a half. Does writing to the disk really take that long? If so, what are the implications if the server or Cassandra were to suddenly crash? Would the information that was in memory and not yet in the disk be gone forever? Thank you!
Hi Luis,
I Suppose you are talking about the online migration from MySQL to Cassandra (the deprecated migration from MySQL to 'Standard Cassandra setup without Elasticsearch' from the Supported System Data Storage Architectures - DataMiner Dojo)?
In that case, the following steps will be performed:
- Installation of Cassandra
- DataMiner will start to forward data to the Cassandra DB and the requests will check both MySQL and Cassandra.
- Migration will take place to push all data from the MySQL DB to Cassandra.
- Once migration is completed, DataMiner will change the DB.xml file and only communicate with the Cassandra DB from that point onwards.
You can see the summary progress in 'C:/Skyline Dataminer/Logging/SLCassandraMigration.txt'. Can you look into that file and see if the DB.xml is already pointing towards your Cassandra DB?