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:
1. Create a MySQL DB System:
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:
1. Create a MySQL DB System:
2. Note that there are different shutdown types:
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@dbexamstudy ~]$ 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@dbexamstudy ~]$
===
[opc@dbexamstudy ~]$ 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@dbexamstudy ~]$
Then connect to your DB System using the MySQL client:
mysqlsh ICO@10.0.0.3
[opc@dbexamstudy ~]$ 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@dbexamstudy ~]$
My suggestion is to start from the MySQL Database Service Overview.
Posts
0 comments:
Post a Comment