MySQL has been for a long time second next to Oracle in the DB-Engines rankings. Moreover, MySQL was their 2019 Database of the Year!
Now, MySQL is also available as DB System on Oracle Cloud Infrastructure. The database version is 8.0.21 with InnoDB Storage Engine. Here is how the set-up works:
2. Note that there are different shutdown types:
3. Connect to a MySQL DB system:
It is not possible to connect directly from a remote IP to the MySQL DB System endpoint. You must connect to a Compute Instance, and from the Compute Instance to the MySQL DB System.
We first install MySQL Shell on the Compute instance:
[opc@julian ~]$ sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Loaded plugins: ulninfo, versionlock mysql80-community-release-el7-3.noarch.rpm | 25 kB 00:00 Examining /var/tmp/yum-root-X8dAdb/mysql80-community-release-el7-3.noarch.rpm: mysql80-community-release-el7-3.noarch Marking /var/tmp/yum-root-X8dAdb/mysql80-community-release-el7-3.noarch.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package mysql80-community-release.noarch 0:el7-3 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: mysql80-community-release noarch el7-3 /mysql80-community-release-el7-3.noarch 31 k Transaction Summary ================================================================================ Install 1 Package Total size: 31 k Installed size: 31 k Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Warning: RPMDB altered outside of yum. Installing : mysql80-community-release-el7-3.noarch 1/1 Verifying : mysql80-community-release-el7-3.noarch 1/1 Installed: mysql80-community-release.noarch 0:el7-3 Complete! [opc@julian ~]$ === [opc@julian ~]$ sudo yum install mysql-shell Loaded plugins: ulninfo, versionlock mysql-connectors-community | 2.5 kB 00:00 mysql-tools-community | 2.5 kB 00:00 mysql80-community | 2.5 kB 00:00 ol7_UEKR5 | 2.5 kB 00:00 ol7_latest | 2.7 kB 00:00 (1/3): mysql80-community/x86_64/primary_db | 115 kB 00:00 (2/3): mysql-connectors-community/x86_64/primary_db | 62 kB 00:00 (3/3): mysql-tools-community/x86_64/primary_db | 76 kB 00:00 (1/5): ol7_UEKR5/x86_64/updateinfo | 72 kB 00:00 (2/5): ol7_latest/x86_64/group | 660 kB 00:00 (3/5): ol7_latest/x86_64/updateinfo | 2.9 MB 00:00 (4/5): ol7_UEKR5/x86_64/primary_db | 12 MB 00:00 (5/5): ol7_latest/x86_64/primary_db | 36 MB 00:00 Excluding 238 updates due to versionlock (use "yum versionlock status" to show them) Resolving Dependencies --> Running transaction check ---> Package mysql-shell.x86_64 0:8.0.21-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: mysql-shell x86_64 8.0.21-1.el7 mysql-tools-community 31 M Transaction Summary ================================================================================ Install 1 Package Total download size: 31 M Installed size: 106 M Is this ok [y/d/N]: y Downloading packages: warning: /var/cache/yum/x86_64/7Server/mysql-tools-community/packages/mysql-shell-8.0.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Public key for mysql-shell-8.0.21-1.el7.x86_64.rpm is not installed mysql-shell-8.0.21-1.el7.x86_64.rpm | 31 MB 00:02 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Importing GPG key 0x5072E1F5: Userid : "MySQL Release Engineering " Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5 Package : mysql80-community-release-el7-3.noarch (@/mysql80-community-release-el7-3.noarch) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Is this ok [y/N]: y Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : mysql-shell-8.0.21-1.el7.x86_64 1/1 Verifying : mysql-shell-8.0.21-1.el7.x86_64 1/1 Installed: mysql-shell.x86_64 0:8.0.21-1.el7 Complete! [opc@julian ~]$
Then connect to your DB System using the MySQL client:
mysqlsh ICO@10.0.0.3 [opc@julian ~]$ mysqlsh ICO@10.0.0.3 Please provide the password for 'ICO@10.0.0.3': ************ MySQL Shell 8.0.21 Copyright (c) 2016, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. Creating a session to 'ICO@10.0.0.3' [opc@julian ~]$
My suggestion is to start from the MySQL Database Service Overview.
MySQL database is also available from GCP, Azure and AWS but check the pricing: