Backup data post minute (AER-4117)


#1

Hey,

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.

Thanks


#2

Currently the backup/restore is only in Aerospike format. We have a separate tool to do csv loading https://github.com/aerospike/aerospike-loader.

Created AER-4117 for this good feature request!


#3

Appreciate it. Would be nice!

For now, I think I’ll do in python/golang.