We have an application that we use for Network Monitoring and it uses a Cassandra database. Our Program is ending and the customer wants us to save our trending database for a period of time after the contract ends. I doubt the customer has any DBAs and I am the only software person on the program. My thought for ease of data retention and if the customer should want the data is to export the Cassandra keyspace and then import it to MySQL which may be an easier database for the poor shlap that gets tasked with using the data. So far I have been able to export the data into JSON files using cassandra-exporter. But when I try to import the JSON files (>1 GB) Mysql workbench crashes. I am not a DBA, just google a lot haha. Is there a better way to get the import the data to mysql? Should I even try this path? Should I just leave it as JSON? Or should I leave the data in Cassandra and just turn over the database file(s?) for the customer to deal with?
Tried Cassandra-exporter to get the tables into JSON files. Tried importing using MySQL Workbench but application crashes on large files.
