{"id":3459,"date":"2020-06-23T13:49:56","date_gmt":"2020-06-23T08:19:56","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/?p=3459"},"modified":"2020-07-21T17:34:13","modified_gmt":"2020-07-21T12:04:13","slug":"automatically-backup-restore-alibaba-mysql-using-grandfather-father-son-strategy","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2020\/06\/23\/automatically-backup-restore-alibaba-mysql-using-grandfather-father-son-strategy\/","title":{"rendered":"Automatically Backup Alibaba MySQL using Grandfather-Father-Son Strategy"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

 <\/p>\n\n\n\n

So, basically what is Grandfather-father-son or GFS?<\/em><\/strong><\/h2>\n\n\n\n<\/p>\r\n

GFS backup<\/em><\/strong> is a common rotation scheme for backup, in which there are three or more backup cycles, such as daily, weekly, and monthly. Typically, It consists of daily backups (son, at fixed intervals of hours in a day), a weekly full backup (father, once a week), and monthly full backup (Grandfather, once a month)<\/em>.<\/p>\r\n

<\/p>\r\n

\n\n\n\n<\/p>\r\n

It helps to restore the database from the most possible recovery points in case of any requirement or disaster.<\/em><\/p>\r\n

\n\n\n\n<\/p>\r\n

To achieve this, we are using the python script and running the script via Jenkins in a docker container for complete automation.<\/em><\/p>\r\n

\n\n\n\n

Something About Aliyun MySQL & Its features<\/em><\/strong><\/h2>\n\n\n\n<\/p>\r\n

Alibaba ApsaraDB for MySQL is an on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilities, etc. <\/em><\/p>\r\n

\n\n\n\n<\/p>\r\n

Features<\/em><\/strong>:<\/p>\r\n

\n\n\n\n

  1. Secure<\/strong> – It is certified by more than 10 authorities such as ISO 20000, SOC, PCI DSS, and Grade III Protection of Information Security.<\/em> It provides Access control<\/strong><\/em> for IP address whitelisting<\/em>, Protection, and encryption<\/strong> against DDOS & TDE to encrypt the data<\/em> and, SQL audit.<\/em><\/strong><\/li>
  2. Highly available<\/strong> –  It is the first database service that guarantees 99.99% availability in its Service Level Agreement (SLA).<\/em> It also provides the Primary\/secondary architecture, Local disaster recovery & Remote disaster recovery.<\/em><\/li>
  3. Flexible and scalable<\/strong> – Users can select subscription or pay-as-you-go billing to better meet your business needs<\/em>. Along with this provides the Creation of read-only instances, Automatic scaling, Allocation of dedicated resources, etc.<\/em><\/li>
  4. For more details, please click here<\/a><\/em>.<\/li><\/ol>\n\n\n\n

    How we are backing up & restoring the MySQL Database?<\/em><\/strong><\/h2>\n\n\n\n<\/p>\r\n

    For Backup, our script<\/a> will be doing below tasks using Alibaba python SDKs & OSS2<\/a> module:<\/em><\/p>\r\n

    \n\n\n\n

    \n