Database Migration Service を使用した MySQL データの Cloud SQL への移行: チャレンジラボ のレビュー

Boralkar Sarthak · 2年以上前にレビュー済み

yadav sumesh · 2年以上前にレビュー済み

Zinchenko Yevgeniy · 2年以上前にレビュー済み

Env running so slow

Ostretsov Dmytro · 2年以上前にレビュー済み

WEE KIAT FOO · 2年以上前にレビュー済み

Choudhari Vishal · 2年以上前にレビュー済み

LEON PEREZ FERNANDO · 2年以上前にレビュー済み

Rodriguez Vera Annelly · 2年以上前にレビュー済み

M Roman · 2年以上前にレビュー済み

does not update

Comoe Adoni · 2年以上前にレビュー済み

LEON PEREZ FERNANDO · 2年以上前にレビュー済み

Gupta Sneha · 2年以上前にレビュー済み

Agarwal Manish · 2年以上前にレビュー済み

Muñoz Alessandra · 2年以上前にレビュー済み

GOOGLEUSER Santosh · 2年以上前にレビュー済み

Soni Vishal · 2年以上前にレビュー済み

Ahmed Ishfaq · 2年以上前にレビュー済み

Kumar Aniket · 2年以上前にレビュー済み

SARKAR SUBHAJIT · 2年以上前にレビュー済み

I've seen updated values in cloud sql but check my progress not completed. Names were used wrong for migration job name , I used same name as mysql-eng-24x-cont, working as expected

k suresh · 2年以上前にレビュー済み

Tolmachov Oleh · 2年以上前にレビュー済み

This lab should have mentioned that it expects certain migration job name for it to pass. I also correctly completed Task4. However it didn't pass. Here's the repsonse: { "labInstanceId": 76351645, "assessmentInfo": { "completion_only": null, "pass": false, "total_steps": 5, "completed_steps": "4", "percent_complete": 80, "total_score": "80", "perfect_score": "100", "remaining_points": "20", "step_scores": [ "20", "20", "20", "0", "20" ], "step_points": [ 20, 20, 20, 20, 20 ], "step_titles": [ "Check that the Database m...", "Check that there is a Clo...", "Check that there is a con...", "Check that the record 974...", "Check that the Cloud SQL ..." ], "step_full_titles": [ "Check that the Database migration source profile for the stand-alone VM has been created.", "Check that there is a Cloud SQL instance with instance ID as per dynamic value and one time migration is performed.", "Check that there is a continuous migration job that is running.", "Check that the record 974 has been updated in both places.", "Check that the Cloud SQL for MySQL destination instance for continuous migration has been promoted." ], "step_done": [ null, null, null, null, null ], "step_complete": [ true, true, true, false, true ], "student_messages": [ "Assessment Completed!", "Assessment Completed!", "Assessment Completed!", "Please ensure you have successfully updated data in the stand alone DB through to the Cloud SQL instance.", "Assessment Completed!" ], "messages": [ "Assessment Completed!", "Success: Migrated from stand-alone MySQL database to Cloud SQL.", "Success: Migrated from continuous MySQL database to Cloud SQL.", "Please ensure you have successfully updated data in the stand alone DB through to the Cloud SQL instance.When adding a new IP address to authorized networks, make sure to also\n include any IP addresses that have already been authorized. \nOtherwise, they will be overwritten and de-authorized.\n\nDo you want to continue (Y/n)? \nThe following message will be used for the patch API method.\n{\"project\": \"qwiklabs-gcp-04-c0eef9b7811b\", \"name\": \"mysql-fin-m5t-cont\", \"settings\": {\"ipConfiguration\": {\"authorizedNetworks\": [{\"value\": \"34.122.26.47/32\"}]}}}\nFEMALE\nMALE\n", "Assessment Completed!" ], "step_completion": [ { "passed": null, "score": 100, "message": "Assessment Completed!" }, { "passed": null, "score": 100, "message": "Success: Migrated from stand-alone MySQL database to Cloud SQL." }, { "passed": null, "score": 100, "message": "Success: Migrated from continuous MySQL database to Cloud SQL." }, { "passed": null, "score": 0, "message": "Please ensure you have successfully updated data in the stand alone DB through to the Cloud SQL instance.When adding a new IP address to authorized networks, make sure to also\n include any IP addresses that have already been authorized. \nOtherwise, they will be overwritten and de-authorized.\n\nDo you want to continue (Y/n)? \nThe following message will be used for the patch API method.\n{\"project\": \"qwiklabs-gcp-04-c0eef9b7811b\", \"name\": \"mysql-fin-m5t-cont\", \"settings\": {\"ipConfiguration\": {\"authorizedNetworks\": [{\"value\": \"34.122.26.47/32\"}]}}}\nFEMALE\nMALE\n" }, { "passed": null, "score": 100, "message": "Assessment Completed!" } ] }, "resourceData": { "project_0": { "project_id": "qwiklabs-gcp-04-c0eef9b7811b", "console_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fconsole.cloud.google.com%2Fhome%2Fdashboard%3Fproject%3Dqwiklabs-gcp-04-c0eef9b7811b#Email=student-02-d3a7247d975c@qwiklabs.net", "default_zone": "us-central1-b", "default_region": "us-central1", "startup_script": { "lab_zone": "us-central1-b", "lab_prefix": "tst", "lab_region": "us-central1", "org_prefix": "fin", "source_mysql_vm_name": "tst-fin-m5t", "cloud_sql_for_vm_one_time": "mysql-fin-m5t", "cloud_sql_for_vm_continuous": "mysql-fin-m5t-cont" } }, "user_0": { "username": "student-02-d3a7247d975c@qwiklabs.net", "local_username": "student-02-d3a7247d975c", "password": "otIe9a0tZEdn", "ssh_key": "-----BEGIN RSA PRIVATE KEY-----\nMIIEowIBAAKCAQEAqtKJr/7IlHtagxO0NAYQO6wT7nkna+JbP8fpB2V7/fcFsLN8\nKbnQJE+tSgml9qUcTz/8f3oN6HwA5tEpjY05T7M5OdGjnKzNe3OueOt4akz8uGV/\njvrUA8HlkB6zAYr6x8ZEnxosjyff6f7pCsDGgQrHFuHVqvmL3u3jR9zXk+oP1gHZ\nX4WX7Rz+9i+i+IADd5IkS93ufx6wkM+2fa4oiNawJpQShErMvMMBKtnR7khDgBfg\neNFum6H3hdxluY13Ace1h/nRcc86GJ0BeLWWL7EFeTW9acWerTWFeAThfxISZ/Rw\n2EeM1ofN25R3N3zF6JbPn7URSbYfG8MnCO8MCwIDAQABAoIBABu8egkevFBzo6jY\nfbAxcy2lN/VG1xJK24MZ1r9R3etI0ok0PiBY9dq3fzfKz5eii9wIU9tvpNYksFF0\nu85VPxgu+HHoFVdJWEdHwMK3L8L0Li1TTv4XFxlnFdBWqRJtOmFOqEdnIhNlJ5PL\nGpQZj1cA5NOqe/Lkza5hqj+PCbKP5kivXwXi08qgHp2hhg7bi1MD0cw/9d1eVr15\nUCMsbX19uEhtmRHUxJLxCe+WQ4lis2ZdcfgvrlW7Bl4oU6fH/akaR6RpqRdK+vHr\nUfHF0G9hpBr9soChysiPZYtID30C3Qc0kRjpEMjIpj+jIyR9nGlIONFR5WOFj5Hs\nqFyvtsUCgYEA1CQsAFqU83M2u4Boa1DTbiTNeOJTmS2AAFED9EAMPpf2xhSP4fQc\npN240y2RplLkpsFElV5JqoeUP0inTFt3FwHeGPfPpzxrwx1ZicUzy9lLPueMgNhQ\nsBKLxK7VflJDMxa9XiyTYE3Pcv0132mc2YJLIbmrokFgQ2w1oO79TkcCgYEAziOD\n8F1sUme0w22QLmlnH/gm8/ngDjJoi1+gctPFE/WVuvx71vychZkpeTCtDXOJQFzs\nTBAR2PdlfbwfRXp3vbzNMZpSXGK4HQlxbcFUb91Qc/fl8iV4txIpEy/EkMhHgf4T\n/mozBUF6uxmMuoMZDORPRwood4be//LkcNSKYh0CgYBx8CeN3RjJFKVd2V673MJi\nEvQkq/JYf/6SrPChu9CXwcixpJOOuSy1Q7yj94KVwUm7YmwyiVypcX4m6x+nvCxf\nOAqQgHCQErySI+5WN4tVPhTS6UwmW4giuSNGdNyHpykehGUa8ngJLmFwEh1gK/op\nPHib2Xwcfl50d+bp09JKuwKBgQDAHdt+biNhXaPbq0X/614gLm9nXM9Ti+lhU7s+\nqV14b56fiWaFhCMAZDGB8DqoWbBmGvRjI2ru0gt1tplScIQeglKe0xvFXIAJF97u\nEot2QkYT/ssA9alevX8okZFZ+j6iyUCrESEB2fffXj2JKltzZ2j3ZWE3nKxC0IXV\nHlDmhQKBgA5+fppxWUFwBYKwIqkUkOmaFEQEu9cYibDZSygEcWi7RA/FH1yny3Uu\n99enP2Z7lZof/D6H0XFe9o8dUSNie6+MhamN8BdONfGjxO3VHUQjQmSciUETQh84\nsSkh+uu/aqQNUpKS0+zZFdLJdKvvQWswXJ5LkBkdHUepXCL65shp\n-----END RSA PRIVATE KEY-----\n", "access_token": "PERMISSION_DENIED", "docs_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fdocs.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "sheets_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fsheets.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "slides_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fslides.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "gmail_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fmail.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "drive_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fdrive.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "calendar_url": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fcalendar.google.com#Email=student-02-d3a7247d975c@qwiklabs.net", "app_sheet_url": "https://www.appsheet.com/Account/Login?utm_source=qwiklabs", "startup_script": {}, "public_key": "ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCq0omv/siUe1qDE7Q0BhA7rBPueSdr4ls/x+kHZXv99wWws3wpudAkT61KCaX2pRxPP/x/eg3ofADm0SmNjTlPszk50aOcrM17c65463hqTPy4ZX+O+tQDweWQHrMBivrHxkSfGiyPJ9/p/ukKwMaBCscW4dWq+Yve7eNH3NeT6g/WAdlfhZftHP72L6L4gAN3kiRL3e5/HrCQz7Z9riiI1rAmlBKESsy8wwEq2dHuSEOAF+B40W6bofeF3GW5jXcBx7WH+dFxzzoYnQF4tZYvsQV5Nb1pxZ6tNYV4BOF/EhJn9HDYR4zWh83blHc3fMXols+ftRFJth8bwycI7wwL" } }, "terminalUrl": null, "gameLeaderboard": null, "isExpired": false, "labControlButton": { "disabled": false, "pending": false, "running": true }, "labTimer": { "ticking": true, "secondsRemaining": 832 }, "billingLimitRemainder": null, "provisioning": false, "provisioningSecondsRemaining": null, "labDetails": [ { "text": "Open Google Cloud console", "property": "console_url", "resource": "project_0", "href": "https://accounts.google.com/AddSession?service=accountsettings\u0026sarp=1\u0026continue=https%3A%2F%2Fconsole.cloud.google.com%2Fhome%2Fdashboard%3Fproject%3Dqwiklabs-gcp-04-c0eef9b7811b#Email=student-02-d3a7247d975c@qwiklabs.net", "type": "button" }, { "label": "Username", "property": "username", "resource": "user_0", "value": "student-02-d3a7247d975c@qwiklabs.net", "type": "credential" }, { "label": "Password", "property": "password", "resource": "user_0", "value": "otIe9a0tZEdn", "type": "credential" }, { "label": "Project_ID", "property": "project_id", "resource": "project_0", "value": "qwiklabs-gcp-04-c0eef9b7811b", "type": "credential" }, { "label": "MySQL source instance", "property": "source_mysql_vm_name", "resource": "project_0", "value": "tst-fin-m5t", "type": "credential" }, { "label": "Cloud SQL one-time migration target", "property": "cloud_sql_for_vm_one_time", "resource": "project_0", "value": "mysql-fin-m5t", "type": "credential" }, { "label": "Cloud SQL continuous migration target", "property": "cloud_sql_for_vm_continuous", "resource": "project_0", "value": "mysql-fin-m5t-cont", "type": "credential" } ], "connectionFiles": [] }

Nationalwala Devendra · 2年以上前にレビュー済み

I've seen updated values in cloud sql but check my progress not completed.

k suresh · 2年以上前にレビュー済み

Alvarez Sebastian · 2年以上前にレビュー済み

Wanjari Ketan · 2年以上前にレビュー済み