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
[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.
[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
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
[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
[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.
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
[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
[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
[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.
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.