findmissing: Update to MySQL 8.0
MySQL 8.0 supports more operations than MySql 5.7, so let's update to it.
To do this, we had to create a new database and copy the contents of the
old database to it. Here we just need to update the pointers to the new
database.
BUG=None
TEST=Run helper command
Change-Id: Ifa183b273c3a12afe07767999c20d91f47802701
Reviewed-on: https://chromium-review.googlesource.com/c/chromiumos/platform/dev-util/+/2628706
Reviewed-by: Curtis Malainey <cujomalainey@chromium.org>
Commit-Queue: Guenter Roeck <groeck@chromium.org>
Tested-by: Guenter Roeck <groeck@chromium.org>
diff --git a/contrib/findmissing/config/systemd/cloud-sql-proxy.service b/contrib/findmissing/config/systemd/cloud-sql-proxy.service
index b351179..ba74d26 100644
--- a/contrib/findmissing/config/systemd/cloud-sql-proxy.service
+++ b/contrib/findmissing/config/systemd/cloud-sql-proxy.service
@@ -8,7 +8,7 @@
User=root
Type=simple
Environment="HOME=/home/chromeos_patches"
-ExecStart=/usr/bin/cloud_sql_proxy -instances=google.com:chromeos-missing-patches:us-central1:linux-patches-sql=tcp:3306 -credential_file=/home/chromeos_patches/secrets/linux_patches_robot_key.json
+ExecStart=/usr/bin/cloud_sql_proxy -instances=google.com:chromeos-missing-patches:us-central1:linux-patches-mysql-8=tcp:3306 -credential_file=/home/chromeos_patches/secrets/linux_patches_robot_key.json
Restart=on-failure
RestartSec=10
KillMode=process
diff --git a/contrib/findmissing/util.py b/contrib/findmissing/util.py
index 27d4503..08ad408 100755
--- a/contrib/findmissing/util.py
+++ b/contrib/findmissing/util.py
@@ -97,7 +97,7 @@
try:
set_gcloud_project_config()
sql_instance_cmd = ['gcloud', 'sql', 'instances', 'describe',
- 'linux-patches-sql', '--format=value[](connectionName)']
+ 'linux-patches-mysql-8', '--format=value[](connectionName)']
sql_instance = subprocess.check_output(sql_instance_cmd, encoding='utf-8').rstrip()
cloudsql_cmd = ['cloud_sql_proxy', '-instances=%s=tcp:3306' % sql_instance]
