Not the answer you need? Try our search, browse our categories, or register and ask your own question!

Does Percona MyRocks support blind writes?

VamsiVamsi Active Member Contributor
hi Folks,
FB MyRocks seems to support blind deletes, blind replace etc (refer Yoshinori's response in https://www.facebook.com/groups/MyRocks/permalink/2744769962253842/ )

Does Percona MyRocks 8.0 support those?

When I looked for variables like '%blind%' or '%replace%' or '%delete%' I could not find any options for blind deletes or blind replace.

Thanks,
Vamsi

Answers

  • George LorchGeorge Lorch Percona Percona Moderator
    This was introduced as a part of Percona Server 5.7.30-33 https://www.percona.com/doc/percona-server/5.7/myrocks/variables.html#rocksdb_blind_delete_primary_key
    and will be released as a part of 8.0.20 which is likely to release some time in August 2020.

    I would like to offer one word of caution, you must be very careful with any of these blind operations as their use can lead to index inconsistencies if you tables key structures do not comply with the requirements.  There are some protections in place to try to detect and prevent these situations, but, there may be ways around the protections.

    -- 
    George O. Lorch III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
  • VamsiVamsi Active Member Contributor
    Thank you. When you talk about index inconsistencies, are you talking about primary index or secondary indexes or both?
  • George LorchGeorge Lorch Percona Percona Moderator
    It can be both depending on the specific situation, but usually the PK is always considered the index of truth and secondaries can be inconsistent with either additional or missing records.
    --
    George O. Lorch III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.