{"action":"created","comment":{"url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/comments/57794495","id":57794495,"diff_hunk":"@@ -0,0 +1,67 @@\n+{{{\n+ \"title\": \"Relational DB Backups and Restores\",\n+ \"date\": \"03-30-2016\",\n+ \"author\": \"Christine Parr\",\n+ \"attachments\": [],\n+ \"related-products\" : [],\n+ \"contentIsHTML\": false\n+ }}}\n+\n+ #### Audience\n+\n+ This article is to support customers of Relational DB Service, CenturyLink's MySQL compatible database-as-a-service product.  Additionally, these instructions are specific to performing backups and restores through the CenturyLink Control portal.\n+\n+ ## Overview\n+\n+ CenturyLink's Relational DB Service is a MySQL-compatible database-as-a-service that provides instant access to a database instance with SSL support, daily backups, restore functionality, basic monitoring and a replication option.  Users can configure the amount of CPU, Memory and Storage based on their database needs and can choose to replicate their instance in datacenter for a more highly available solution.  As customers' capacity needs grown, they can easily scale their CPU, RAM and/or Storage through the click of a button.\n+\n+ #### Prerequisites\n+\n+ Access to the CenturyLink Cloud Platform as an authorized user\n+\n+\n+## Relational DB Backups\n+The Relational DB service includes daily, automated hot backups as well as the ability to take a backup on demand.  Users have the ability to define the time of day backups are run as well as a data retention policy.  Backups are held off-site at least 350 miles from the datacenter of the Relational DB instance.  Backups will always be held in the same country as the Relational DB instance as well to maintain data sovereignty.\n+\n+## Defining your Backup Policy\n+\n+1. Upon provisioning of a Relational DB instance, the user is asked to define their Backup Schedule and their Backup Retention.  Backup Schedule will govern the time of day all automated, daily backups are taken.  Backup retention can be set to any value between 1 and 35 days.  Please note that increasing your backup retention period may increase the backup storage consumed by your instance.  Your Relational DB subscription includes up to 100% of your allocated storage amount in backup storage.  Backup storage that exceeds the size of your allocated storage will be billed at the Additional Backup Storage rate defined in the [pricing catalogue](https://www.ctl.io/pricing/#/va1).\n+<p>\n+<p>![DefineBackupPolicy](../images/rdbs-define-backup-policy.png)\n+<p>\n+2. Users may also change the backup policy of an existing Relational DB instance from the subscription details page.  The details page includes a \"Backup Policy\" section with an \"Edit\" option.\n+<p>\n+<p>![BackupPolicy](../images/rdbs-backup-policy.png)\n+<p>\n+3. When a user clicks on the 'edit' button a new section appears that allows the user to make changes to the backup policy.  Simply change the backup time and/or backup retention to the new desired settings and click save.  The request will result in the Relational DB instance being in a \"Configuring\" status for a few minutes at which point, no additional policy changes, backups or restores can occur.\n+<p>\n+<p>![EditBackupPolicy](../images/rdbs-edit-backup-policy.png)\n+\n+## Taking a Manual Backup\n+Users may choose to take a backup at any time.  Manual backups will be retained in accordance with the defined backup policy for that instance, but can also be deleted at any time by the user.\n+\n+1.  Identify the Relational DB instance to be backed up and click on that instance to navigate to the details page.\n+\n+2.  Click on the \"backup\" button on the action bar.\n+\n+3.  The action bar will now indicate that there is a \"backup in process\" and the status of the instance will be changed to \"Backing Up\".\n+\n+4.  Upon successful completion, the backup will now be listed and will be marked as \"Manual\".\n+<p>\n+<p>![ManualBackup](../images/rdbs-manual-backup.png)\n+\n+## Restoring from Backup","path":"Database/backups-and-restores","position":53,"original_position":53,"commit_id":"9c538f1cf75f32db374f200a65ecfeaeff69de28","original_commit_id":"9c538f1cf75f32db374f200a65ecfeaeff69de28","user":{"login":"srveit","id":6688,"avatar_url":"https://avatars.githubusercontent.com/u/6688?v=3","gravatar_id":"","url":"https://api.github.com/users/srveit","html_url":"https://github.com/srveit","followers_url":"https://api.github.com/users/srveit/followers","following_url":"https://api.github.com/users/srveit/following{/other_user}","gists_url":"https://api.github.com/users/srveit/gists{/gist_id}","starred_url":"https://api.github.com/users/srveit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srveit/subscriptions","organizations_url":"https://api.github.com/users/srveit/orgs","repos_url":"https://api.github.com/users/srveit/repos","events_url":"https://api.github.com/users/srveit/events{/privacy}","received_events_url":"https://api.github.com/users/srveit/received_events","type":"User","site_admin":false},"body":"Change to `###`","created_at":"2016-03-29T20:29:17Z","updated_at":"2016-03-29T20:29:17Z","html_url":"https://github.com/CenturyLinkCloud/PublicKB/pull/924#discussion_r57794495","pull_request_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924","_links":{"self":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/comments/57794495"},"html":{"href":"https://github.com/CenturyLinkCloud/PublicKB/pull/924#discussion_r57794495"},"pull_request":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924"}}},"pull_request":{"url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924","id":64498659,"html_url":"https://github.com/CenturyLinkCloud/PublicKB/pull/924","diff_url":"https://github.com/CenturyLinkCloud/PublicKB/pull/924.diff","patch_url":"https://github.com/CenturyLinkCloud/PublicKB/pull/924.patch","issue_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/924","number":924,"state":"open","locked":false,"title":"RelationalDB-KBUpdates-Restores","user":{"login":"christineparr11","id":11301417,"avatar_url":"https://avatars.githubusercontent.com/u/11301417?v=3","gravatar_id":"","url":"https://api.github.com/users/christineparr11","html_url":"https://github.com/christineparr11","followers_url":"https://api.github.com/users/christineparr11/followers","following_url":"https://api.github.com/users/christineparr11/following{/other_user}","gists_url":"https://api.github.com/users/christineparr11/gists{/gist_id}","starred_url":"https://api.github.com/users/christineparr11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christineparr11/subscriptions","organizations_url":"https://api.github.com/users/christineparr11/orgs","repos_url":"https://api.github.com/users/christineparr11/repos","events_url":"https://api.github.com/users/christineparr11/events{/privacy}","received_events_url":"https://api.github.com/users/christineparr11/received_events","type":"User","site_admin":false},"body":"Adds new KB article to cover Backups and Restores.  Edits the FAQ KB to\nreference new KB.","created_at":"2016-03-29T17:00:03Z","updated_at":"2016-03-29T20:29:17Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6f0466a1557f965a6e9c97f47c023ef5955fa2e8","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924/commits","review_comments_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924/comments","review_comment_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/comments{/number}","comments_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/924/comments","statuses_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/statuses/9c538f1cf75f32db374f200a65ecfeaeff69de28","head":{"label":"christineparr11:RelationalDB-KB-Restores","ref":"RelationalDB-KB-Restores","sha":"9c538f1cf75f32db374f200a65ecfeaeff69de28","user":{"login":"christineparr11","id":11301417,"avatar_url":"https://avatars.githubusercontent.com/u/11301417?v=3","gravatar_id":"","url":"https://api.github.com/users/christineparr11","html_url":"https://github.com/christineparr11","followers_url":"https://api.github.com/users/christineparr11/followers","following_url":"https://api.github.com/users/christineparr11/following{/other_user}","gists_url":"https://api.github.com/users/christineparr11/gists{/gist_id}","starred_url":"https://api.github.com/users/christineparr11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christineparr11/subscriptions","organizations_url":"https://api.github.com/users/christineparr11/orgs","repos_url":"https://api.github.com/users/christineparr11/repos","events_url":"https://api.github.com/users/christineparr11/events{/privacy}","received_events_url":"https://api.github.com/users/christineparr11/received_events","type":"User","site_admin":false},"repo":{"id":37332438,"name":"PublicKB","full_name":"christineparr11/PublicKB","owner":{"login":"christineparr11","id":11301417,"avatar_url":"https://avatars.githubusercontent.com/u/11301417?v=3","gravatar_id":"","url":"https://api.github.com/users/christineparr11","html_url":"https://github.com/christineparr11","followers_url":"https://api.github.com/users/christineparr11/followers","following_url":"https://api.github.com/users/christineparr11/following{/other_user}","gists_url":"https://api.github.com/users/christineparr11/gists{/gist_id}","starred_url":"https://api.github.com/users/christineparr11/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christineparr11/subscriptions","organizations_url":"https://api.github.com/users/christineparr11/orgs","repos_url":"https://api.github.com/users/christineparr11/repos","events_url":"https://api.github.com/users/christineparr11/events{/privacy}","received_events_url":"https://api.github.com/users/christineparr11/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/christineparr11/PublicKB","description":"Help Docs ","fork":true,"url":"https://api.github.com/repos/christineparr11/PublicKB","forks_url":"https://api.github.com/repos/christineparr11/PublicKB/forks","keys_url":"https://api.github.com/repos/christineparr11/PublicKB/keys{/key_id}","collaborators_url":"https://api.github.com/repos/christineparr11/PublicKB/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/christineparr11/PublicKB/teams","hooks_url":"https://api.github.com/repos/christineparr11/PublicKB/hooks","issue_events_url":"https://api.github.com/repos/christineparr11/PublicKB/issues/events{/number}","events_url":"https://api.github.com/repos/christineparr11/PublicKB/events","assignees_url":"https://api.github.com/repos/christineparr11/PublicKB/assignees{/user}","branches_url":"https://api.github.com/repos/christineparr11/PublicKB/branches{/branch}","tags_url":"https://api.github.com/repos/christineparr11/PublicKB/tags","blobs_url":"https://api.github.com/repos/christineparr11/PublicKB/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/christineparr11/PublicKB/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/christineparr11/PublicKB/git/refs{/sha}","trees_url":"https://api.github.com/repos/christineparr11/PublicKB/git/trees{/sha}","statuses_url":"https://api.github.com/repos/christineparr11/PublicKB/statuses/{sha}","languages_url":"https://api.github.com/repos/christineparr11/PublicKB/languages","stargazers_url":"https://api.github.com/repos/christineparr11/PublicKB/stargazers","contributors_url":"https://api.github.com/repos/christineparr11/PublicKB/contributors","subscribers_url":"https://api.github.com/repos/christineparr11/PublicKB/subscribers","subscription_url":"https://api.github.com/repos/christineparr11/PublicKB/subscription","commits_url":"https://api.github.com/repos/christineparr11/PublicKB/commits{/sha}","git_commits_url":"https://api.github.com/repos/christineparr11/PublicKB/git/commits{/sha}","comments_url":"https://api.github.com/repos/christineparr11/PublicKB/comments{/number}","issue_comment_url":"https://api.github.com/repos/christineparr11/PublicKB/issues/comments{/number}","contents_url":"https://api.github.com/repos/christineparr11/PublicKB/contents/{+path}","compare_url":"https://api.github.com/repos/christineparr11/PublicKB/compare/{base}...{head}","merges_url":"https://api.github.com/repos/christineparr11/PublicKB/merges","archive_url":"https://api.github.com/repos/christineparr11/PublicKB/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/christineparr11/PublicKB/downloads","issues_url":"https://api.github.com/repos/christineparr11/PublicKB/issues{/number}","pulls_url":"https://api.github.com/repos/christineparr11/PublicKB/pulls{/number}","milestones_url":"https://api.github.com/repos/christineparr11/PublicKB/milestones{/number}","notifications_url":"https://api.github.com/repos/christineparr11/PublicKB/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/christineparr11/PublicKB/labels{/name}","releases_url":"https://api.github.com/repos/christineparr11/PublicKB/releases{/id}","deployments_url":"https://api.github.com/repos/christineparr11/PublicKB/deployments","created_at":"2015-06-12T16:27:17Z","updated_at":"2016-02-08T22:40:42Z","pushed_at":"2016-03-29T17:00:02Z","git_url":"git://github.com/christineparr11/PublicKB.git","ssh_url":"git@github.com:christineparr11/PublicKB.git","clone_url":"https://github.com/christineparr11/PublicKB.git","svn_url":"https://github.com/christineparr11/PublicKB","homepage":null,"size":176538,"stargazers_count":0,"watchers_count":0,"language":"Shell","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"CenturyLinkCloud:master","ref":"master","sha":"f6670a5dda16aec83e8946da0157bd2e437d5f65","user":{"login":"CenturyLinkCloud","id":5995824,"avatar_url":"https://avatars.githubusercontent.com/u/5995824?v=3","gravatar_id":"","url":"https://api.github.com/users/CenturyLinkCloud","html_url":"https://github.com/CenturyLinkCloud","followers_url":"https://api.github.com/users/CenturyLinkCloud/followers","following_url":"https://api.github.com/users/CenturyLinkCloud/following{/other_user}","gists_url":"https://api.github.com/users/CenturyLinkCloud/gists{/gist_id}","starred_url":"https://api.github.com/users/CenturyLinkCloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenturyLinkCloud/subscriptions","organizations_url":"https://api.github.com/users/CenturyLinkCloud/orgs","repos_url":"https://api.github.com/users/CenturyLinkCloud/repos","events_url":"https://api.github.com/users/CenturyLinkCloud/events{/privacy}","received_events_url":"https://api.github.com/users/CenturyLinkCloud/received_events","type":"Organization","site_admin":false},"repo":{"id":23715715,"name":"PublicKB","full_name":"CenturyLinkCloud/PublicKB","owner":{"login":"CenturyLinkCloud","id":5995824,"avatar_url":"https://avatars.githubusercontent.com/u/5995824?v=3","gravatar_id":"","url":"https://api.github.com/users/CenturyLinkCloud","html_url":"https://github.com/CenturyLinkCloud","followers_url":"https://api.github.com/users/CenturyLinkCloud/followers","following_url":"https://api.github.com/users/CenturyLinkCloud/following{/other_user}","gists_url":"https://api.github.com/users/CenturyLinkCloud/gists{/gist_id}","starred_url":"https://api.github.com/users/CenturyLinkCloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenturyLinkCloud/subscriptions","organizations_url":"https://api.github.com/users/CenturyLinkCloud/orgs","repos_url":"https://api.github.com/users/CenturyLinkCloud/repos","events_url":"https://api.github.com/users/CenturyLinkCloud/events{/privacy}","received_events_url":"https://api.github.com/users/CenturyLinkCloud/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/CenturyLinkCloud/PublicKB","description":"Help Docs ","fork":false,"url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB","forks_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/forks","keys_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/keys{/key_id}","collaborators_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/teams","hooks_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/hooks","issue_events_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/events{/number}","events_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/events","assignees_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/assignees{/user}","branches_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/branches{/branch}","tags_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/tags","blobs_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/git/refs{/sha}","trees_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/git/trees{/sha}","statuses_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/statuses/{sha}","languages_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/languages","stargazers_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/stargazers","contributors_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/contributors","subscribers_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/subscribers","subscription_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/subscription","commits_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/commits{/sha}","git_commits_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/git/commits{/sha}","comments_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/comments{/number}","issue_comment_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/comments{/number}","contents_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/contents/{+path}","compare_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/compare/{base}...{head}","merges_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/merges","archive_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/downloads","issues_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues{/number}","pulls_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls{/number}","milestones_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/milestones{/number}","notifications_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/labels{/name}","releases_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/releases{/id}","deployments_url":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/deployments","created_at":"2014-09-05T19:31:50Z","updated_at":"2016-02-17T18:42:38Z","pushed_at":"2016-03-29T20:28:30Z","git_url":"git://github.com/CenturyLinkCloud/PublicKB.git","ssh_url":"git@github.com:CenturyLinkCloud/PublicKB.git","clone_url":"https://github.com/CenturyLinkCloud/PublicKB.git","svn_url":"https://github.com/CenturyLinkCloud/PublicKB","homepage":null,"size":180097,"stargazers_count":19,"watchers_count":19,"language":"Shell","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":129,"mirror_url":null,"open_issues_count":7,"forks":129,"open_issues":7,"watchers":19,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924"},"html":{"href":"https://github.com/CenturyLinkCloud/PublicKB/pull/924"},"issue":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/924"},"comments":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/issues/924/comments"},"review_comments":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924/comments"},"review_comment":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/pulls/924/commits"},"statuses":{"href":"https://api.github.com/repos/CenturyLinkCloud/PublicKB/statuses/9c538f1cf75f32db374f200a65ecfeaeff69de28"}}}}