Percona . Percona — MySQL MongoDB. .
. , , .
, . , .
.
, , . , . , , . / . , .
. , . , mysqldump .
.
Percona Backup (Percona XtraBackup Percona Backup for MongoDB).
$ openssl rand -base64 24 > /root/isolated_directory/keyfile.key
, , . , , .
$ chmod -R 400 /root/isolated_directory
/usr/bin/mysqldump --defaults-file=/etc/my.cnf --flush-privileges --hex-blob --opt --master-data=2 --single-transaction --skip-lock-tables --triggers --routines --events --gtid --databases db1 db2 db3 db4 |gzip -6 -c | openssl enc -aes-256-cbc -pass file:/root/isolated_directory/keyfile.key > /root/mysqldump_2020-12-27_schemaanddata.sql.gz
, Database Backup Encryption - Best Practices.
/ (vault). , Hashicorp Vault. , Hashicorp Vault, .
, AWS Secrets Manager. Amazon, Amazon KMS. , ssh.
. - . , , , , . , Amazon S3, Google Cloud Storage Azure Blob Storage. : Exoscale, Backblaze S3- . , , TLS / SSL. AWS S3 TLS/SSL. , :
{
"Id": "ExamplePolicy",
"Version": "2012-10-17",
"Statement": [
{
"Sid": "AllowSSLRequestsOnly",
"Action": "s3:*",
"Effect": "Deny",
"Resource": [
"arn:aws:s3:::DOC-EXAMPLE-BUCKET",
"arn:aws:s3:::DOC-EXAMPLE-BUCKET/*"
],
"Condition": {
"Bool": {
"aws:SecureTransport": "false"
}
},
"Principal": "*"
}
]
}
, , Exoscale, .s3cfg
, :
[default] host_base = sos-{zone}.exo.io host_bucket = %(bucket)s.sos-{zone}.exo.io access_key = $EXO_SOS_KEY secret_key = $EXO_SOS_SECRET use_https = True
, TLS / SSL . TLS — SSL, TLS.
, , . , , RPO (Recovery Point Objective), . . . , .
, , . , . , RTO (Recovery Time Objective) . , , , , , , . .
. , , , . . , .
, , Google Drive Microsoft OneDrive.
, , . , ACL ( ), , . , : , , / , / .
.
Amazon AWS S3 Standard . , S3 Standard , . AWS S3.
(US N. Virginia) :
50 / |
$0.023 |
450 / |
$0.022 |
500 / |
$0.021 |
( ), US West (Northern California) .
50 / |
$0.026 |
450 / |
$0.025 |
500 / |
$0.024 |
, .
, Google Cloud Storage Standard Storage (us-east1) (South Carolina) $0,20 . US-EAST1 NORTHAMERICA-NORTHEAST1, $0,01 .
Oracle Storage Cloud, $0,0255, $0,0034. , Block Volume Performance Units, $0,0017, VPU.
, . , , , , (SLA) , .
, Percona Server for MySQL/MariaDB Percona Server for MongoDB, , .
, . Ansible, Chef, Puppet SaltStack. ClusterControl, , . Percona Server for MySQL, Percona Server for MongoDB, MySQL, MariaDB MongoDB. , Percona Backup Tools, ClusterControl.
ClusterControl . , : . AWS, GCP Azure. , .
Backup Ninja — SaaS- (Software-as-a-Service), , . Backup Ninja , , , , . , . . , , , , . , . , . . c $40. Backup Ninja , , .
« ».
- : «MySQL NDB Cluster — ». NDB , , .