domingo, 10 de octubre de 2021

Instalando MySQL Server Community 8.0 en Oracle Linux OCI

 
Primero que todo, la presente instalación se ha hecho sobre una VM creada en un ambiente OCI con el shape Standard E3.Flex, con 16GB de memoria RAM, con 1 (uno) AMD FLEXIBLE OCPU.


Antes de proceder con la instalación del motor de base de datos comunitario de MYSQL, primero que todo proceda a realizar una actualización de la máquina virtual de Oracle Linux con el comando:

Primero que todo necesitamos tener privilegios de root en el server
sudo -s /bin/bash

Luego podemos utilizar la herramienta YUM para realizar la actualización
[root@oracle-mysql-server opc]# yum update

Una vez que concluya la actualización del sistema operativo Oracle Linux procedemos a hacer la instalación de algunos paquetes ligados al software de MySQL.

[root@oracle-mysql-server opc]# yum install mysql*
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package mysql-connector-java.noarch 1:5.1.25-3.el7 will be installed
--> Processing Dependency: java >= 1:1.6.0 
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: jta >= 1.0 
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: jpackage-utils for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: slf4j 
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
---> Package mysql-connector-odbc.x86_64 0:5.2.5-8.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) 
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) 
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) 
or package: mysql-connector-odbc-5.2.5-8.el7.x86_64
---> Package mysql-release-el7.x86_64 0:1.0-5.el7 will be installed
--> Running transaction check
---> Package geronimo-jta.noarch 0:1.1.1-17.el7 will be installed
---> Package javapackages-tools.noarch 0:3.4.1-11.el7 will be installed
--> Processing Dependency: python-javapackages = 3.4.1-11.el7 
for package: javapackages-tools-3.4.1-11.el7.noarch
--> Processing Dependency: libxslt 
for package: javapackages-tools-3.4.1-11.el7.noarch
---> Package jre1.8.x86_64 0:1.8.0_301-fcs will be installed
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be installed
---> Package slf4j.noarch 0:1.7.4-4.el7_4 will be installed
--> Processing Dependency: mvn(ch.qos.cal10n:cal10n-api) 
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(commons-lang:commons-lang) 
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(commons-logging:commons-logging) 
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(javassist:javassist) 
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(log4j:log4j) 
for package: slf4j-1.7.4-4.el7_4.noarch
---> Package unixODBC.x86_64 0:2.3.1-14.0.1.el7 will be installed
--> Processing Dependency: libltdl.so.7()(64bit) 
for package: unixODBC-2.3.1-14.0.1.el7.x86_64
--> Running transaction check
---> Package apache-commons-lang.noarch 0:2.6-15.el7 will be installed
---> Package apache-commons-logging.noarch 0:1.1.2-7.el7 will be installed
--> Processing Dependency: mvn(avalon-framework:avalon-framework-api) 
for package: apache-commons-logging-1.1.2-7.el7.noarch
--> Processing Dependency: mvn(logkit:logkit) 
for package: apache-commons-logging-1.1.2-7.el7.noarch
---> Package cal10n.noarch 0:0.7.7-4.el7 will be installed
---> Package javassist.noarch 0:3.16.1-10.el7 will be installed
---> Package libtool-ltdl.x86_64 0:2.4.2-22.el7_3 will be installed
---> Package libxslt.x86_64 0:1.1.28-6.0.1.el7 will be installed
---> Package log4j.noarch 0:1.2.17-16.el7_4 will be installed
--> Processing Dependency: mvn(javax.mail:mail) 
for package: log4j-1.2.17-16.el7_4.noarch
--> Processing Dependency: mvn(org.apache.geronimo.specs:geronimo-jms_1.1_spec) 
for package: log4j-1.2.17-16.el7_4.noarch
---> Package python-javapackages.noarch 0:3.4.1-11.el7 will be installed
--> Processing Dependency: python-lxml 
for package: python-javapackages-3.4.1-11.el7.noarch
--> Running transaction check
---> Package avalon-framework.noarch 0:4.3-10.el7 will be installed
--> Processing Dependency: xalan-j2 
for package: avalon-framework-4.3-10.el7.noarch
---> Package avalon-logkit.noarch 0:2.1-14.el7 will be installed
--> Processing Dependency: tomcat-servlet-3.0-api 
for package: avalon-logkit-2.1-14.el7.noarch
---> Package geronimo-jms.noarch 0:1.1.1-19.el7 will be installed
---> Package javamail.noarch 0:1.4.6-8.el7 will be installed
---> Package python-lxml.x86_64 0:3.2.1-4.el7 will be installed
--> Running transaction check
---> Package tomcat-servlet-3.0-api.noarch 0:7.0.76-16.el7_9 will be installed
---> Package xalan-j2.noarch 0:2.7.1-23.el7 will be installed
--> Processing Dependency: osgi(org.apache.xerces) 
for package: xalan-j2-2.7.1-23.el7.noarch
--> Processing Dependency: xerces-j2 for package: xalan-j2-2.7.1-23.el7.noarch
--> Running transaction check
---> Package rh-maven36-xerces-j2.noarch 0:2.12.0-3.2.el7 will be installed
--> Processing Dependency: rh-maven36-xalan-j2 >= 2.7.1 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-xml-commons-apis >= 1.4.01 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-xml-commons-resolver >= 1.2 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: java-headless 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: osgi(javax.xml) 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: osgi(org.apache.xml.resolver) 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-javapackages-tools 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-mvn(xml-apis:xml-apis) 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-runtime 
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
---> Package xerces-j2.noarch 0:2.11.0-17.el7_0 will be installed
--> Processing Dependency: xml-commons-apis >= 1.4.01 
for package: xerces-j2-2.11.0-17.el7_0.noarch
--> Processing Dependency: xml-commons-resolver >= 1.2 
for package: xerces-j2-2.11.0-17.el7_0.noarch
--> Running transaction check
---> Package java-1.8.0-openjdk-headless.x86_64 1:1.8.0.302.b08-0.el7_9 will be installed
--> Processing Dependency: copy-jdk-configs >= 3.3 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: tzdata-java >= 2021a 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: cups-libs(x86-64) 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit) 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: lksctp-tools(x86-64) 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: pcsc-lite-libs(x86-64) 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit) 
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
---> Package rh-maven36-javapackages-tools.noarch 0:5.3.1-4.2.el7 will be installed
--> Processing Dependency: rh-maven36-javapackages-filesystem = 5.3.1-4.2.el7 
for package: rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarc
---> Package rh-maven36-runtime.x86_64 0:1-1.el7 will be installed
---> Package rh-maven36-xalan-j2.noarch 0:2.7.2-1.2.el7 will be installed
---> Package rh-maven36-xml-commons-apis.noarch 0:1.4.01-26.2.el7 will be installed
---> Package rh-maven36-xml-commons-resolver.noarch 0:1.2-27.2.el7 will be installed
---> Package xml-commons-apis.noarch 0:1.4.01-16.el7 will be installed
---> Package xml-commons-resolver.noarch 0:1.2-15.el7 will be installed
--> Running transaction check
---> Package copy-jdk-configs.noarch 0:3.3-10.el7_5 will be installed
---> Package cups-libs.x86_64 1:1.6.3-51.el7 will be installed
---> Package libjpeg-turbo.x86_64 0:1.2.90-8.el7 will be installed
---> Package lksctp-tools.x86_64 0:1.0.17-2.el7 will be installed
---> Package pcsc-lite-libs.x86_64 0:1.8.8-8.el7 will be installed
---> Package rh-maven36-javapackages-filesystem.noarch 0:5.3.1-4.2.el7 will be installed
---> Package tzdata-java.noarch 0:2021a-1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================
 Package                                             Arch                    Version                                    Repository
=====================================================================
Installing:
 mysql-connector-java                                noarch                  1:5.1.25-3.el7                             ol7_latest
 mysql-connector-odbc                                x86_64                  5.2.5-8.el7                                ol7_latest
 mysql-release-el7                                   x86_64                  1.0-5.el7                                  ol7_latest
Installing for dependencies:
 apache-commons-lang                                 noarch                  2.6-15.el7                                 ol7_latest
 apache-commons-logging                              noarch                  1.1.2-7.el7                                ol7_latest
 avalon-framework                                    noarch                  4.3-10.el7                                 ol7_latest
 avalon-logkit                                       noarch                  2.1-14.el7                                 ol7_latest
 cal10n                                              noarch                  0.7.7-4.el7                                ol7_latest
 copy-jdk-configs                                    noarch                  3.3-10.el7_5                               ol7_latest
 cups-libs                                           x86_64                  1:1.6.3-51.el7                             ol7_latest
 geronimo-jms                                        noarch                  1.1.1-19.el7                               ol7_latest
 geronimo-jta                                        noarch                  1.1.1-17.el7                               ol7_latest
 java-1.8.0-openjdk-headless                         x86_64                  1:1.8.0.302.b08-0.el7_9                    ol7_latest
 javamail                                            noarch                  1.4.6-8.el7                                ol7_latest
 javapackages-tools                                  noarch                  3.4.1-11.el7                               ol7_latest
 javassist                                           noarch                  3.16.1-10.el7                              ol7_latest
 jre1.8                                              x86_64                  1.8.0_301-fcs                              ol7_oci_included
 libjpeg-turbo                                       x86_64                  1.2.90-8.el7                               ol7_latest
 libtool-ltdl                                        x86_64                  2.4.2-22.el7_3                             ol7_latest
 libxslt                                             x86_64                  1.1.28-6.0.1.el7                           ol7_latest
 lksctp-tools                                        x86_64                  1.0.17-2.el7                               ol7_latest
 log4j                                               noarch                  1.2.17-16.el7_4                            ol7_latest
 mariadb-libs                                        x86_64                  1:5.5.68-1.el7                             ol7_latest
 pcsc-lite-libs                                      x86_64                  1.8.8-8.el7                                ol7_latest
 python-javapackages                                 noarch                  3.4.1-11.el7                               ol7_latest
 python-lxml                                         x86_64                  3.2.1-4.el7                                ol7_latest
 rh-maven36-javapackages-filesystem                  noarch                  5.3.1-4.2.el7                              ol7_software_collect
 rh-maven36-javapackages-tools                       noarch                  5.3.1-4.2.el7                              ol7_software_collect
 rh-maven36-runtime                                  x86_64                  1-1.el7                                    ol7_software_collect
 rh-maven36-xalan-j2                                 noarch                  2.7.2-1.2.el7                              ol7_software_collect
 rh-maven36-xerces-j2                                noarch                  2.12.0-3.2.el7                             ol7_software_collect
 rh-maven36-xml-commons-apis                         noarch                  1.4.01-26.2.el7                            ol7_software_collect
 rh-maven36-xml-commons-resolver                     noarch                  1.2-27.2.el7                               ol7_software_collect
 slf4j                                               noarch                  1.7.4-4.el7_4                              ol7_latest
 tomcat-servlet-3.0-api                              noarch                  7.0.76-16.el7_9                            ol7_latest
 tzdata-java                                         noarch                  2021a-1.el7                                ol7_latest
 unixODBC                                            x86_64                  2.3.1-14.0.1.el7                           ol7_latest
 xalan-j2                                            noarch                  2.7.1-23.el7                               ol7_latest
 xerces-j2                                           noarch                  2.11.0-17.el7_0                            ol7_latest
 xml-commons-apis                                    noarch                  1.4.01-16.el7                              ol7_latest
 xml-commons-resolver                                noarch                  1.2-15.el7                                 ol7_latest
Transaction Summary
=====================================================================
Install  3 Packages (+38 Dependent packages)
Total download size: 106 M
Installed size: 313 M
Is this ok [y/d/N]: y
Downloading packages:
(1/41): apache-commons-logging-1.1.2-7.el7.noarch.rpm
(2/41): avalon-framework-4.3-10.el7.noarch.rpm
(3/41): avalon-logkit-2.1-14.el7.noarch.rpm
(4/41): cal10n-0.7.7-4.el7.noarch.rpm
(5/41): copy-jdk-configs-3.3-10.el7_5.noarch.rpm
(6/41): cups-libs-1.6.3-51.el7.x86_64.rpm
(7/41): geronimo-jms-1.1.1-19.el7.noarch.rpm
(8/41): geronimo-jta-1.1.1-17.el7.noarch.rpm
(9/41): apache-commons-lang-2.6-15.el7.noarch.rpm
(10/41): javamail-1.4.6-8.el7.noarch.rpm
(11/41): javapackages-tools-3.4.1-11.el7.noarch.rpm
(12/41): javassist-3.16.1-10.el7.noarch.rpm
(13/41): libjpeg-turbo-1.2.90-8.el7.x86_64.rpm
(14/41): libtool-ltdl-2.4.2-22.el7_3.x86_64.rpm
(15/41): libxslt-1.1.28-6.0.1.el7.x86_64.rpm
(16/41): lksctp-tools-1.0.17-2.el7.x86_64.rpm
(17/41): log4j-1.2.17-16.el7_4.noarch.rpm
(18/41): mariadb-libs-5.5.68-1.el7.x86_64.rpm
(19/41): mysql-connector-java-5.1.25-3.el7.noarch.rpm
(20/41): mysql-connector-odbc-5.2.5-8.el7.x86_64.rpm
(21/41): mysql-release-el7-1.0-5.el7.x86_64.rpm
(22/41): pcsc-lite-libs-1.8.8-8.el7.x86_64.rpm
(23/41): python-javapackages-3.4.1-11.el7.noarch.rpm
(24/41): rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch.rpm
(25/41): python-lxml-3.2.1-4.el7.x86_64.rpm
(26/41): rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch.rpm
(27/41): rh-maven36-runtime-1-1.el7.x86_64.rpm
(28/41): rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch.rpm
(29/41): rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch.rpm
(30/41): rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch.rpm
(31/41): rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch.rpm
(32/41): slf4j-1.7.4-4.el7_4.noarch.rpm
(33/41): tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch.rpm
(34/41): tzdata-java-2021a-1.el7.noarch.rpm
(35/41): unixODBC-2.3.1-14.0.1.el7.x86_64.rpm
(36/41): xalan-j2-2.7.1-23.el7.noarch.rpm
(37/41): xerces-j2-2.11.0-17.el7_0.noarch.rpm
(38/41): xml-commons-apis-1.4.01-16.el7.noarch.rpm
(39/41): xml-commons-resolver-1.2-15.el7.noarch.rpm
(40/41): java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64.rpm
(41/41): jre-8u301-linux-x64.rpm
--------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                   909
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : jre1.8-1.8.0_301-fcs.x86_64
Unpacking JAR files...
        plugin.jar...
        javaws.jar...
        deploy.jar...
        rt.jar...
        jsse.jar...
        charsets.jar...
        localedata.jar...
  Installing : libxslt-1.1.28-6.0.1.el7.x86_64
  Installing : python-lxml-3.2.1-4.el7.x86_64
  Installing : python-javapackages-3.4.1-11.el7.noarch
  Installing : javapackages-tools-3.4.1-11.el7.noarch
  Installing : xml-commons-apis-1.4.01-16.el7.noarch
  Installing : xml-commons-resolver-1.2-15.el7.noarch
  Installing : geronimo-jms-1.1.1-19.el7.noarch
  Installing : tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch
  Installing : javamail-1.4.6-8.el7.noarch
  Installing : log4j-1.2.17-16.el7_4.noarch
  Installing : apache-commons-lang-2.6-15.el7.noarch
  Installing : cal10n-0.7.7-4.el7.noarch
  Installing : javassist-3.16.1-10.el7.noarch
  Installing : geronimo-jta-1.1.1-17.el7.noarch
  Installing : copy-jdk-configs-3.3-10.el7_5.noarch
  Installing : rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch
  Installing : pcsc-lite-libs-1.8.8-8.el7.x86_64
  Installing : 1:mariadb-libs-5.5.68-1.el7.x86_64
  Installing : 1:cups-libs-1.6.3-51.el7.x86_64
  Installing : lksctp-tools-1.0.17-2.el7.x86_64
  Installing : libtool-ltdl-2.4.2-22.el7_3.x86_64
  Installing : unixODBC-2.3.1-14.0.1.el7.x86_64
  Installing : tzdata-java-2021a-1.el7.noarch
  Installing : libjpeg-turbo-1.2.90-8.el7.x86_64
  Installing : 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
  Installing : rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch
  Installing : rh-maven36-runtime-1-1.el7.x86_64
  Installing : rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch
  Installing : rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch
  Installing : xalan-j2-2.7.1-23.el7.noarch
  Installing : xerces-j2-2.11.0-17.el7_0.noarch
  Installing : rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
  Installing : rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch
  Installing : avalon-logkit-2.1-14.el7.noarch
  Installing : apache-commons-logging-1.1.2-7.el7.noarch
  Installing : avalon-framework-4.3-10.el7.noarch
  Installing : slf4j-1.7.4-4.el7_4.noarch
  Installing : 1:mysql-connector-java-5.1.25-3.el7.noarch
  Installing : mysql-connector-odbc-5.2.5-8.el7.x86_64
  Installing : mysql-release-el7-1.0-5.el7.x86_64
  Verifying  : rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch
  Verifying  : libjpeg-turbo-1.2.90-8.el7.x86_64
  Verifying  : avalon-logkit-2.1-14.el7.noarch
  Verifying  : tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch
  Verifying  : javamail-1.4.6-8.el7.noarch
  Verifying  : libxslt-1.1.28-6.0.1.el7.x86_64
  Verifying  : xml-commons-resolver-1.2-15.el7.noarch
  Verifying  : unixODBC-2.3.1-14.0.1.el7.x86_64
  Verifying  : xml-commons-apis-1.4.01-16.el7.noarch
  Verifying  : log4j-1.2.17-16.el7_4.noarch
  Verifying  : apache-commons-lang-2.6-15.el7.noarch
  Verifying  : avalon-framework-4.3-10.el7.noarch
  Verifying  : python-javapackages-3.4.1-11.el7.noarch
  Verifying  : tzdata-java-2021a-1.el7.noarch
  Verifying  : libtool-ltdl-2.4.2-22.el7_3.x86_64
  Verifying  : xerces-j2-2.11.0-17.el7_0.noarch
  Verifying  : lksctp-tools-1.0.17-2.el7.x86_64
  Verifying  : 1:cups-libs-1.6.3-51.el7.x86_64
  Verifying  : geronimo-jms-1.1.1-19.el7.noarch
  Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64
  Verifying  : mysql-connector-odbc-5.2.5-8.el7.x86_64
  Verifying  : rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch
  Verifying  : cal10n-0.7.7-4.el7.noarch
  Verifying  : rh-maven36-runtime-1-1.el7.x86_64
  Verifying  : rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch
  Verifying  : apache-commons-logging-1.1.2-7.el7.noarch
  Verifying  : pcsc-lite-libs-1.8.8-8.el7.x86_64
  Verifying  : xalan-j2-2.7.1-23.el7.noarch
  Verifying  : javapackages-tools-3.4.1-11.el7.noarch
  Verifying  : jre1.8-1.8.0_301-fcs.x86_64
  Verifying  : mysql-release-el7-1.0-5.el7.x86_64
  Verifying  : rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch
  Verifying  : rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch
  Verifying  : 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
  Verifying  : 1:mysql-connector-java-5.1.25-3.el7.noarch
  Verifying  : python-lxml-3.2.1-4.el7.x86_64
  Verifying  : rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
  Verifying  : slf4j-1.7.4-4.el7_4.noarch
  Verifying  : javassist-3.16.1-10.el7.noarch
  Verifying  : geronimo-jta-1.1.1-17.el7.noarch
  Verifying  : copy-jdk-configs-3.3-10.el7_5.noarch
Installed:
  mysql-connector-java.noarch 1:5.1.25-3.el7                
mysql-connector-odbc.x86_64 0:5.2.5-8.el7                
mysql-release-el7.x86_6
Dependency Installed:
  apache-commons-lang.noarch 0:2.6-15.el7                                         
apache-commons-logging.noarch 0:1.1.2-7.el7
  avalon-framework.noarch 0:4.3-10.el7                                            
avalon-logkit.noarch 0:2.1-14.el7
  cal10n.noarch 0:0.7.7-4.el7                                                     
copy-jdk-configs.noarch 0:3.3-10.el7_5
  cups-libs.x86_64 1:1.6.3-51.el7                                                 
geronimo-jms.noarch 0:1.1.1-19.el7
  geronimo-jta.noarch 0:1.1.1-17.el7                                              
java-1.8.0-openjdk-headless.x86_64 1:1.8.0.302.b08-0.el7_9
  javamail.noarch 0:1.4.6-8.el7                                                   
javapackages-tools.noarch 0:3.4.1-11.el7
  javassist.noarch 0:3.16.1-10.el7                                                
jre1.8.x86_64 0:1.8.0_301-fcs
  libjpeg-turbo.x86_64 0:1.2.90-8.el7                                             
libtool-ltdl.x86_64 0:2.4.2-22.el7_3
  libxslt.x86_64 0:1.1.28-6.0.1.el7                                               
lksctp-tools.x86_64 0:1.0.17-2.el7
  log4j.noarch 0:1.2.17-16.el7_4                                                  
mariadb-libs.x86_64 1:5.5.68-1.el7
  pcsc-lite-libs.x86_64 0:1.8.8-8.el7                                             
python-javapackages.noarch 0:3.4.1-11.el7
  python-lxml.x86_64 0:3.2.1-4.el7                                                
rh-maven36-javapackages-filesystem.noarch 0:5.3.1-4.2.el7
  rh-maven36-javapackages-tools.noarch 0:5.3.1-4.2.el7                            
rh-maven36-runtime.x86_64 0:1-1.el7
  rh-maven36-xalan-j2.noarch 0:2.7.2-1.2.el7                                      
rh-maven36-xerces-j2.noarch 0:2.12.0-3.2.el7
  rh-maven36-xml-commons-apis.noarch 0:1.4.01-26.2.el7                            
h-maven36-xml-commons-resolver.noarch 0:1.2-27.2.el7
  slf4j.noarch 0:1.7.4-4.el7_4                                                    
tomcat-servlet-3.0-api.noarch 0:7.0.76-16.el7_9
  tzdata-java.noarch 0:2021a-1.el7                                                
unixODBC.x86_64 0:2.3.1-14.0.1.el7
  xalan-j2.noarch 0:2.7.1-23.el7                                                  
xerces-j2.noarch 0:2.11.0-17.el7_0
  xml-commons-apis.noarch 0:1.4.01-16.el7                                         
xml-commons-resolver.noarch 0:1.2-15.el7
Complete!

Los paquetes de MySQL están firmados con una llave pública GPG. Vamos a descargar las llaves públicas desde el sitio oficial, utilizando para ello la herramienta WGET

[root@oracle-mysql-server opc]# cd /etc/pki/rpm-gpg
[root@oracle-mysql-server rpm-gpg]# wget https://repo.mysql.com/RPM-GPG-KEY-mysq                                                            l
--2021-09-17 16:47:13--  https://repo.mysql.com/RPM-GPG-KEY-mysql
Resolving repo.mysql.com (repo.mysql.com)... 23.66.97.60
Connecting to repo.mysql.com (repo.mysql.com)|23.66.97.60|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 27824 (27K) [text/plain]
Saving to: ‘RPM-GPG-KEY-mysql’
100%[======================================>] 27,824      --.-K/s   in 0.001s
2021-09-17 16:47:13 (28.9 MB/s) - ‘RPM-GPG-KEY-mysql’ saved [27824/27824]
[root@oracle-mysql-server rpm-gpg]# ls -la
total 52
drwxr-xr-x.  2 root root  4096 Sep 17 16:47 .
drwxr-xr-x. 10 root root  4096 Aug 18 17:24 ..
-rw-r--r--.  1 root root  1011 Sep 30  2020 RPM-GPG-KEY
-rw-r--r--.  1 root root  1519 Sep 30  2020 RPM-GPG-KEY-fedora
-rw-r--r--.  1 root root  1076 Sep 30  2020 RPM-GPG-KEY-fedora-test
-rw-r--r--.  1 root root 27824 Jan 18  2019 RPM-GPG-KEY-mysql
-rw-r--r--.  1 root root  1011 Sep 30  2020 RPM-GPG-KEY-oracle

En el directorio del repositorio de YUM, verifica que tengas el archivo mysql-community.repo. Si no es así, puedes copiar el siguiente contenido dentro de tu archivo de repo de facto.

[root@oracle-mysql-server rpm-gpg]# vi /etc/yum.repos.d/mysql-community.repo
==========================================
[ol7_optional_latest]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7Server
baseurl = https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/optional/latest/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7Server/ol7_optional_latest
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = True
enablegroups = True
exclude =
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
hdrdir = /var/cache/yum/x86_64/7Server/ol7_optional_latest/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = Oracle Linux 7Server Optional Latest (x86_64)
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest
pkgdir = /var/cache/yum/x86_64/7Server/ol7_optional_latest/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = ol7_optional_latest/x86_64
ui_repoid_vars = releasever,
   basearch
username =
==================================================================== 
repo: ol7_software_collections 
[ol7_software_collections]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7Server
baseurl = https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/SoftwareCollections/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7Server/ol7_software_collections
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = True
enablegroups = True
exclude =
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
hdrdir = /var/cache/yum/x86_64/7Server/ol7_software_collections/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = Software Collection Library release 3.0 packages for Oracle Linux 7 (x86_64)
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections
pkgdir = /var/cache/yum/x86_64/7Server/ol7_software_collections/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = ol7_software_collections/x86_64
ui_repoid_vars = releasever,
   basearch
username =

Iniciamos la instalación del motor de la base de datos MySQL

[root@oracle-mysql-server rpm-gpg]# yum install install mysql-community-server
Loaded plugins: langpacks, ulninfo
ol7_MySQL80
ol7_MySQL80_connectors_community
ol7_MySQL80_tools_community
ol7_UEKR6
ol7_addons
ol7_ksplice
ol7_latest
ol7_oci_included
ol7_optional_latest
ol7_software_collections
No package install available.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.26-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.26-1.el7 
for package: mysql-community-server-8.0.26-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 
for package: mysql-community-server-8.0.26-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.26-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.26-1.el7 
for package: mysql-community-client-8.0.26-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 
for package: mysql-community-client-8.0.26-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.26-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) 
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) 
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.26-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.26-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-connector-odbc.x86_64 0:5.2.5-8.el7 will be updated
---> Package mysql-connector-odbc.x86_64 0:8.0.26-1.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================
 Package                                           Arch                      Version                          Repository
=====================================================================
Installing:
 mysql-community-libs                              x86_64                    8.0.26-1.el7                     ol7_MySQL80
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-server                            x86_64                    8.0.26-1.el7                     ol7_MySQL80
Installing for dependencies:
 mysql-community-client                            x86_64                    8.0.26-1.el7                     ol7_MySQL80
 mysql-community-client-plugins                    x86_64                    8.0.26-1.el7                     ol7_MySQL80
 mysql-community-common                            x86_64                    8.0.26-1.el7                     ol7_MySQL80
Updating for dependencies:
 mysql-connector-odbc                              x86_64                    8.0.26-1.el7                     ol7_MySQL80_connectors_communi
Transaction Summary
=====================================================================
Install  2 Packages (+3 Dependent packages)
Upgrade             ( 1 Dependent package)
Total download size: 493 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/6): mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm
(2/6): mysql-community-common-8.0.26-1.el7.x86_64.rpm
(3/6): mysql-community-libs-8.0.26-1.el7.x86_64.rpm
(4/6): mysql-connector-odbc-8.0.26-1.el7.x86_64.rpm
(5/6): mysql-community-client-8.0.26-1.el7.x86_64.rpm
https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/MySQL80_community/x86_64/getPackage/mysql-community-server-8.0.26-1.el7.x86_64.rpm:://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/MySQL80_community/x86_64/getPackage/mysql-community-server-8.0.26-1.el7.x86_64.rpm: (28,han 1000 bytes/sec transferred the last 30 seconds')
Trying other mirror.
(6/6): mysql-community-server-8.0.26-1.el7.x86_64.rpm
---------------------------------------------------------------------
Total                                                                                                                                   607
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-client-plugins-8.0.26-1.el7.x86_64
  Installing : mysql-community-common-8.0.26-1.el7.x86_64
  Installing : mysql-community-libs-8.0.26-1.el7.x86_64
  Installing : mysql-community-client-8.0.26-1.el7.x86_64
  Installing : mysql-community-server-8.0.26-1.el7.x86_64
  Updating   : mysql-connector-odbc-8.0.26-1.el7.x86_64
Success: Usage count is 1
Success: Usage count is 1
  Cleanup    : mysql-connector-odbc-5.2.5-8.el7.x86_64
  Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64
  Verifying  : mysql-community-libs-8.0.26-1.el7.x86_64
  Verifying  : mysql-community-common-8.0.26-1.el7.x86_64
  Verifying  : mysql-community-server-8.0.26-1.el7.x86_64
  Verifying  : mysql-community-client-plugins-8.0.26-1.el7.x86_64
  Verifying  : mysql-connector-odbc-8.0.26-1.el7.x86_64
  Verifying  : mysql-community-client-8.0.26-1.el7.x86_64
  Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64
  Verifying  : mysql-connector-odbc-5.2.5-8.el7.x86_64
Installed:
  mysql-community-libs.x86_64 0:8.0.26-1.el7                                        
mysql-community-server.x86_64 0:8.0.26-1.el7
Dependency Installed:
  mysql-community-client.x86_64 0:8.0.26-1.el7         
mysql-community-client-plugins.x86_64 0:8.0.26-1.el7         
mysql-community-common.x
Dependency Updated:
  mysql-connector-odbc.x86_64 0:8.0.26-1.el7
Replaced:
  mariadb-libs.x86_64 1:5.5.68-1.el7
Complete!

Seguidamente, vamos a arrancar los servicios del motor de MySQL

[root@oracle-mysql-server rpm-gpg]# systemctl enable mysqld.service
[root@oracle-mysql-server rpm-gpg]# systemctl start mysqld.service

Verificamos el estado del servicio que se encuentre ejecutando.

[root@oracle-mysql-server rpm-gpg]# systemctl status mysqld.service
? mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2021-09-17 17:05:36 GMT; 6s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 23329 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 23492 (mysqld)
   Status: "Server is operational"
   Memory: 484.3M
   CGroup: /system.slice/mysqld.service
           +-23492 /usr/sbin/mysqld
Sep 17 17:05:28 oracle-mysql-server systemd[1]: Starting MySQL Server...
Sep 17 17:05:36 oracle-mysql-server systemd[1]: Started MySQL Server.

En el proceso de instalación de MySQL, se ha creado en el archivo de log, una línea con el password temporal de la cuenta administradora en la base de datos. Busca en el mismo con el siguiente comando:

[root@oracle-mysql-server rpm-gpg]# grep 'A temporary password is generated' /var/log/mysqld.log | tail -1
2021-09-17T17:05:32.078599Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ai.8Vo5OuaFO

Ahora procedemos a hacer el cambio de la clave del usuario root dentro de la base de datos MySQL llamanda a MYSQL_SECURE_INSTALLATION. También se configuran algunos atributos relacionados con la gestión del password.

[root@oracle-mysql-server rpm-gpg]# mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:
The existing password for the user account root has expired. Please set a new password.
New password:
Re-enter new password:
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.
Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y
New password:
Re-enter new password:
Estimated strength of the password: 50
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
 ... Failed! Error: Your password does not satisfy the current policy requirements
New password:
Re-enter new password:
Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : yes
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y|Y for Yes, any other key for No) : yes
Success.

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : yes
Success.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : no
 ... skipping.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.
All done!

Una vez que recibamos el mensaje de que todo esta hecho, probamos conectarnos al motor de base de datos. Aquí utilizarás el password que recientemente haz creado.
[root@oracle-mysql-server rpm-gpg]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.26 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Ejecuta el siguiente comando para revisar las bases de datos creadas de facto.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

Nos salimos de la línea de comando dentro de la consola de MySQL.
mysql> quit
Bye

Ahora bien, si es tu primer contacto con una base de datos MySQL, vamos a importar una base de datos, con objetos y registros que nos permitan servir de DEMO o LAB para iniciar nuestro proceso de aprendizaje.

En el navegador de tu computadora, anda a la dirección:
https://dev.mysql.com/doc/employee/en/employees-installation.html

Descarga del GitHUB, el archivo de la base de datos EMPLOYEES en tu máquina. Utiliza un cliente de SFTP para conectarte a tu VM en el OCI utilizando la IP Pública o la IP Privada si tienes configurado un VPN con el OCI de antemano.

Crea un directorio en el servidor y descarga ahí el archivo test_db-1.0.7.tar.gz

[root@oracle-mysql-server rpm-gpg]# mkdir /opt/testdb
[root@oracle-mysql-server rpm-gpg]# cd /opt/testdb
[root@oracle-mysql-server testdb]# ls -la
total 0
drwxr-xr-x. 2 root root  6 Sep 17 17:35 .
drwxr-xr-x. 5 root root 62 Sep 17 17:35 ..
[root@oracle-mysql-server testdb]# pwd
/opt/testdb
[root@oracle-mysql-server testdb]# cd /home/opc
[root@oracle-mysql-server opc]# ls -la
total 34796
drwx------. 5 opc  opc      4096 Sep 17 17:36 .
drwxr-xr-x. 3 root root       17 Sep 17 16:14 ..
-rw-r--r--. 1 opc  opc        18 Nov 22  2019 .bash_logout
-rw-r--r--. 1 opc  opc       193 Nov 22  2019 .bash_profile
-rw-r--r--. 1 opc  opc       231 Nov 22  2019 .bashrc
drwxrwxr-x. 3 opc  opc        18 Sep 17 16:15 .cache
drwxrwxr-x. 3 opc  opc        18 Sep 17 16:15 .config
-rw-r--r--. 1 opc  opc       172 Apr  1  2020 .kshrc
drwx------. 2 opc  opc        29 Sep 17 16:14 .ssh
-rw-rw-r--. 1 opc  opc  35607473 Sep 17 17:33 test_db-1.0.7.tar.gz
[root@oracle-mysql-server opc]# mv test_db-1.0.7.tar.gz /opt/testdb/
[root@oracle-mysql-server opc]# cd /opt/testdb
[root@oracle-mysql-server testdb]# ls -la
total 34776
drwxr-xr-x. 2 root root       34 Sep 17 17:37 .
drwxr-xr-x. 5 root root       62 Sep 17 17:35 ..
-rw-rw-r--. 1 opc  opc  35607473 Sep 17 17:33 test_db-1.0.7.tar.gz

Procede a desempacar el archivo de la base de datos de prueba.

[root@oracle-mysql-server testdb]# gunzip test_db-1.0.7.tar.gz
[root@oracle-mysql-server testdb]# ls -la
total 171740
drwxr-xr-x. 2 root root        31 Sep 17 17:37 .
drwxr-xr-x. 5 root root        62 Sep 17 17:35 ..
-rw-rw-r--. 1 opc  opc  175861760 Sep 17 17:33 test_db-1.0.7.tar

El archivo que viene dentro del GZIP, es un archivo en formato TAR. Procede con el siguiente comando a descomprimir la carpeta.

[root@oracle-mysql-server testdb]# tar -xvf test_db-1.0.7.tar
test_db/Changelog
test_db/README.md
test_db/employees.sql
test_db/employees_partitioned.sql
test_db/employees_partitioned_5.1.sql
test_db/images/employees.gif
test_db/images/._employees.jpg
test_db/images/employees.jpg
test_db/images/employees.png
test_db/load_departments.dump
test_db/load_dept_emp.dump
test_db/load_dept_manager.dump
test_db/load_employees.dump
test_db/load_salaries1.dump
test_db/load_salaries2.dump
test_db/load_salaries3.dump
test_db/load_titles.dump
test_db/objects.sql
test_db/sakila/README.md
test_db/sakila/sakila-mv-data.sql
test_db/sakila/sakila-mv-schema.sql
test_db/show_elapsed.sql
test_db/sql_test.sh
test_db/test_employees_md5.sql
test_db/test_employees_sha.sql
test_db/test_versions.sh

Verifica el contenido descomprimido del archivo.
[root@oracle-mysql-server testdb]# ls -la
total 171744
drwxr-xr-x. 3 root root        46 Sep 17 17:37 .
drwxr-xr-x. 5 root root        62 Sep 17 17:35 ..
drwxr-xr-x. 4 root root      4096 Sep 17 17:37 test_db
-rw-rw-r--. 1 opc  opc  175861760 Sep 17 17:33 test_db-1.0.7.tar

Como puedes observar, se ha creado un directorio con el nombre <test_db>. Ingresa al directorio y revisa el contenido del mismo.
[root@oracle-mysql-server testdb]# cd test_db

[root@oracle-mysql-server test_db]# ls -la
total 168344
drwxr-xr-x. 4 root root      4096 Sep 17 17:37 .
drwxr-xr-x. 3 root root        46 Sep 17 17:37 ..
-rw-r--r--. 1  501 games      964 Aug 30  2015 Changelog
-rw-r--r--. 1  501 games     7948 Sep 24  2015 employees_partitioned_5.1.sql
-rw-r--r--. 1  501 games     6276 Sep 24  2015 employees_partitioned.sql
-rw-r--r--. 1  501 games     4193 Sep  4  2020 employees.sql
drwxr-xr-x. 2 root root        92 Sep 17 17:37 images
-rw-r--r--. 1  501 games      250 May 29  2020 load_departments.dump
-rw-r--r--. 1  501 games 14159880 Aug 31  2015 load_dept_emp.dump
-rw-r--r--. 1  501 games     1090 Aug 31  2015 load_dept_manager.dump
-rw-r--r--. 1  501 games 17722832 Aug 31  2015 load_employees.dump
-rw-r--r--. 1  501 games 39806034 Aug 31  2015 load_salaries1.dump
-rw-r--r--. 1  501 games 39805981 Aug 31  2015 load_salaries2.dump
-rw-r--r--. 1  501 games 39080916 Aug 31  2015 load_salaries3.dump
-rw-r--r--. 1  501 games 21708736 Aug 31  2015 load_titles.dump
-rw-r--r--. 1  501 games     4568 Sep 19  2015 objects.sql
-rw-r--r--. 1  501 games     4325 May 29  2020 README.md
drwxr-xr-x. 2 root root        77 Sep 17 17:37 sakila
-rw-r--r--. 1  501 games      272 May 29  2020 show_elapsed.sql
-rwxr-xr-x. 1  501 games     1800 Aug 31  2015 sql_test.sh
-rw-r--r--. 1  501 games     4711 Sep  7  2020 test_employees_md5.sql
-rw-r--r--. 1  501 games     4715 Sep  7  2020 test_employees_sha.sql
-rwxr-xr-x. 1  501 games     2013 Sep  4  2020 test_versions.sh

ahora vamos a importar la base de datos.
[root@oracle-mysql-server test_db]# mysql -u root -p testdb < employees.sql
Enter password:
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries
data_load_time_diff
00:00:58

Con el siguiente procedimiento, podemos validar que la importación se encuentre consistente.

[root@oracle-mysql-server test_db]# time mysql -u root -p testdb -t < test_employees_md5.sql
Enter password:
+----------------------+
| INFO                 |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+----------------------------------+
| table_name   | expected_records | expected_crc                     |
+--------------+------------------+----------------------------------+
| departments  |                9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_emp     |           331603 | ccf6fe516f990bdaa49713fc478701b7 |
| dept_manager |               24 | 8720e2f0853ac9096b689c14664f847e |
| employees    |           300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| salaries     |          2844047 | fd220654e95aea1b169624ffe3fca934 |
| titles       |           443308 | bfa016c472df68e70a03facafa1bc0a8 |
+--------------+------------------+----------------------------------+
+--------------+------------------+----------------------------------+
| table_name   | found_records    | found_crc                        |
+--------------+------------------+----------------------------------+
| departments  |                9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_emp     |           331603 | ccf6fe516f990bdaa49713fc478701b7 |
| dept_manager |               24 | 8720e2f0853ac9096b689c14664f847e |
| employees    |           300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| salaries     |          2844047 | fd220654e95aea1b169624ffe3fca934 |
| titles       |           443308 | bfa016c472df68e70a03facafa1bc0a8 |
+--------------+------------------+----------------------------------+
+--------------+---------------+-----------+
| table_name   | records_match | crc_match |
+--------------+---------------+-----------+
| departments  | OK            | ok        |
| dept_emp     | OK            | ok        |
| dept_manager | OK            | ok        |
| employees    | OK            | ok        |
| salaries     | OK            | ok        |
| titles       | OK            | ok        |
+--------------+---------------+-----------+
+------------------+
| computation_time |
+------------------+
| 00:00:54         |
+------------------+
+---------+--------+
| summary | result |
+---------+--------+
| CRC     | OK     |
| count   | OK     |
+---------+--------+
real    1m3.014s
user    0m0.007s
sys     0m0.002s
[root@oracle-mysql-server test_db]#

Listo, ya puedes empezar a utilizar tu base de datos MySQL V8.0x.
Recuerda que la diferencia entre la versión EE y la versión Community, es que Oracle libera con un retraso aproximado de 6 meses, las nuevas versiones y características al motor Community.

Por otro lado, después de cierta cantidad de usuarios concurrentes, la versión Community deja de escalar y pierde rendimiento significativamente.

Adicionalmente, no cuentas con soporte del fabricante, sólo de la comunidad de usuarios.

No hay comentarios:

Publicar un comentario

Te agradezco tus comentarios. Te esperamos de vuelta.

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar