Does Percona MyRocks support blind writes?

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

1 Like

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 IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup

1 Like

Thank you. When you talk about index inconsistencies, are you talking about primary index or secondary indexes or both?

1 Like

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 IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup

1 Like

Hi George,

Looks like 8.0.20-11 has been released. I see a new variable rocksdb_blind_delete_primary_key, but what about inserts and updates?

Thanks!

Vamsi

1 Like

pinging again on my previous question,
Thanks,
Vamsi

1 Like