Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Clone in Desktop Download ZIP

Loading…

mysqldump supporting RocksDB #24

Closed
yoshinorim opened this Issue · 3 comments

2 participants

@yoshinorim
Owner

Now we have CONSISTENT SNAPSHOT in RocksDB, it's time to make mysqldump work for RocksDB.
At least two features are needed.

  • START TRANSACTION WITH CONSISTENT ROCKSDB SNAPSHOT instead of INNODB SNAPSHOT. This can be done by either passing an option (i.e. --rocksdb) or by detecting if there are RocksDB tables.
  • Adding an option to take dump by descending order -- adding an option --order-by-primary-desc then taking backup by descending order. This is efficient if primary key is reverse order.
@yoshinorim yoshinorim self-assigned this
@mdcallag
Owner

Is the descending order option there to support desc order keys?
What about a key like (a asc, b desc, c asc, d desc)?
Doesn't MySQL ignore "desc" in DDL, see http://mysqlha.blogspot.com/2009/01/parsed-but-ignored.html?

@yoshinorim
Owner

It won't support mixed order. All ASC or all DESC.

@yoshinorim yoshinorim closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.