edgelesssys / edgelessdb

EdgelessDB is a MySQL-compatible database for confidential computing. It runs entirely inside a secure enclave and comes with advanced features for collaboration, recovery, and access control.
https://edgeless.systems/products/edgelessdb
GNU General Public License v2.0
170 stars 17 forks source link

Does EdgelessDB support backup? #92

Closed water5-cmd closed 2 years ago

water5-cmd commented 2 years ago

Hi, @thomasten, Does EdgelessDB support the backup feature? I understand that MariaDB supports backups. When I searched for mariabackup, I saw a lot of source code for backups in edgeless-mariadb. But I'm not sure if it works and how to use it. Can you tell me more about it? And does EdgelessDB support Setting Up Replication?

thomasten commented 2 years ago

Hi, We haven't tried mariabackup yet. I just gave it a quick try and it failed to connect. Even if it would, I think it might fail because of the modified encryption at RocksDB level. So currently you have to stop EdgelessDB and copy the data folder to create a backup. Or use something like mysqldump.

There's currently no support for replication.

water5-cmd commented 2 years ago

Thanks for your reply! Is it safe to say that EdgelessDB is not suitable for distributed shared data scenarios? Suppose I deploy multiple EdgelessDB databases, which can only run services individually because the data in each database cannot be synchronized in real-time. If a database crashes, it cannot switch to another database to continue to provide services.

thomasten commented 2 years ago

Yes, this is true for the current version. It's on our long-term roadmap though.

water5-cmd commented 2 years ago

Hi, @thomasten, If use marblerun, deploy multiple edgelessdb services in a distributed environment, i.e. edgelessdb A, B, C. For databases A, B, and C: First, can A, B, and C interact securely and in real-time? Second, can A, B, and C data be synchronized in real-time? If not, is it possible to implement database backup in marblerun?

thomasten commented 2 years ago

No, unfortunately, none of this is supported yet.

water5-cmd commented 2 years ago

Understood, thanks for your reply!

gammelgaard52 commented 1 year ago

Is it supported today?

thomasten commented 1 year ago

No, all statements are still true.