|
|
|
|
|
by husainfazel
1520 days ago
|
|
- Works on large database (> 10GB) (read Design)
Can anyone explain to me how this works in RepliByte? The design document only talked about Postgres.For example let's say I have a MySQL database, how does RepliByte copy that database into S3? Does it use mysqldump or are they coping the database index files? We have a script that automatically backs up our production database at intervals to S3 and then a program to download the latest backup and scrub the data. It takes a heck of a long time to download and impacts the server when it happens... it's been on my todo list to replace with Percona's Xtrabackup [1] but doesn't look that's what these guys are doing? - Database Subsetting: Scale down a production database to a more reasonable size
What about this? Does the database need foreign keys to prevent related rows in tables being lost and are they just randomly deleting rows as the config seems to indicate [2][1] https://www.percona.com/software/mysql-database/percona-xtra... [2] https://github.com/qovery/replibyte#configuration |
|