search

manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
8.89k stars 492 forks source link

LOCK #1251

Open sanikolaev opened 1 year ago

sanikolaev commented 1 year ago

We have FREEZE which prevents the table from being updated on disk, so it can be safely copied when frozen. It's great for physical backup. Now that we support logical backup via mysqldump it makes sense to implement LOCK which would prevent the table from being modified in any way while it's locked. A better specification is to be discussed.

sanikolaev commented 1 year ago

As discussed on "Dev call of January the 26th, 2023", it would be quite difficult to implement LOCK, so that write queries are waiting for the table to be unlocked. What's easier and may even make more sense at least as the default is to reject those queries while the table is locked.