For the sake of brevity, i had a script in mysql that would do this:
con = mdb.connect('localhost', 'root', '', 'engine') cur = con.cursor() cur.execute("SELECT * FROM " + table + " WHERE date_added <= " + timestamp) with open(filename, "wb") as csv_file: csv_writer = csv.writer(csv_file) csv_writer.writerows(cur)
So its dumping everything in the past minute into a file. It would get sent to another server.
My question for aerospike. Can the backup client export to a csv format based on a specific bin and a specifix index or secondary index?
I’m hoping so, that I dont have to write something multi-threaded in python. As usually backup clients run very fast.