Consejos para almacenar Percona Backup en la nube






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 , , .












All Articles