MySQL Installation on Oracle Cloud’s “Always Free” Compute Instance


I have configured MySQL Replication (Classic and DTID)  on  Oracle Public Cloud “Always Free”  that would like to share . I also would like to mention that It is unofficial  and testing purpose only.

1.Create free Oracle Cloud account

You need to go to Oracle's Could Free Website and register. This need you must give your email address and payment method. You won't be charged if you choose the Oracle Cloud free-tier products.


 

 

 

 

2. Create compute instance



 

 

 

 

3.Choose SSH key and provide Public Key.



 

 

 

4.After selection of ssh public key it shows like


 

 

 

 

5.Choose Show Advance Option


 

 

6.Choose Management with Proper Fault Domain and choose networking Tab.       



 

 

 

 

7.Choose Networking launch option.


 

 

 

 

8.Click on create


 

9.It start provisioning Status



 

 

 

 

10.Finally, Compute Instance status became running


 

 

 

 

11. Finally, you will have Compute Instance .Click on  instance to get details 

 

 

 

 

12. Public IP and Private IP details.

 

 

 

 

 

MySQL Database Installation

1.Download MySQL Community Edition.


 

 

 

 

 

2.Choose MySQL RPM bundle to download


 

 

3.Choose File Transfer Utility to upload to both machine I choose WinSCP.


 

 

 

 

4.Logon with Putty using Public IP .


      

5.Clich on SSH and Choose Auth and Provide Private Key .


 

 

 

 

 

 

 

 

 

6.Unzip RPM Bundle .


 

 

 

7.Install MySQL Server and Clients .

[root@instance-20200404-1109 opc]# yum install -y mysql-community-client-8.0.19-1.el7.x86_64.rpm mysql-community-common-8.0.19-1.el7.x86_64.rpm mysql-community-libs-8.0.19-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm mysql-community-server-8.0.19-1.el7.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining mysql-community-client-8.0.19-1.el7.x86_64.rpm: mysql-community-client-8.0.19-1.el7.x86_64
Marking mysql-community-client-8.0.19-1.el7.x86_64.rpm to be installed
Examining mysql-community-common-8.0.19-1.el7.x86_64.rpm: mysql-community-common-8.0.19-1.el7.x86_64
Marking mysql-community-common-8.0.19-1.el7.x86_64.rpm to be installed
Examining mysql-community-libs-8.0.19-1.el7.x86_64.rpm: mysql-community-libs-8.0.19-1.el7.x86_64
Marking mysql-community-libs-8.0.19-1.el7.x86_64.rpm to be installed
Examining mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm: mysql-community-libs-compat-8.0.19-1.el7.x86_64
Marking mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm to be installed
Examining mysql-community-server-8.0.19-1.el7.x86_64.rpm: mysql-community-server-8.0.19-1.el7.x86_64
Marking mysql-community-server-8.0.19-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be obsoleted
---> Package mysql-community-client.x86_64 0:8.0.19-1.el7 will be installed
---> Package mysql-community-common.x86_64 0:8.0.19-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.19-1.el7 will be obsoleting
---> Package mysql-community-libs-compat.x86_64 0:8.0.19-1.el7 will be obsoleting
---> Package mysql-community-server.x86_64 0:8.0.19-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package
     Arch   Version      Repository                                        Size
================================================================================
Installing:
 mysql-community-client
     x86_64 8.0.19-1.el7 /mysql-community-client-8.0.19-1.el7.x86_64      191 M
 mysql-community-common
     x86_64 8.0.19-1.el7 /mysql-community-common-8.0.19-1.el7.x86_64      8.6 M
 mysql-community-libs
     x86_64 8.0.19-1.el7 /mysql-community-libs-8.0.19-1.el7.x86_64         19 M
     replacing  mariadb-libs.x86_64 1:5.5.64-1.el7
 mysql-community-libs-compat
     x86_64 8.0.19-1.el7 /mysql-community-libs-compat-8.0.19-1.el7.x86_64 6.4 M
     replacing  mariadb-libs.x86_64 1:5.5.64-1.el7
 mysql-community-server
     x86_64 8.0.19-1.el7 /mysql-community-server-8.0.19-1.el7.x86_64      1.9 G

Transaction Summary
================================================================================
Install  5 Packages

Total size: 2.1 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-common-8.0.19-1.el7.x86_64                   1/6
  Installing : mysql-community-libs-8.0.19-1.el7.x86_64                     2/6
  Installing : mysql-community-client-8.0.19-1.el7.x86_64                   3/6
  Installing : mysql-community-server-8.0.19-1.el7.x86_64                   4/6
  Installing : mysql-community-libs-compat-8.0.19-1.el7.x86_64              5/6
  Erasing    : 1:mariadb-libs-5.5.64-1.el7.x86_64                           6/6
  Verifying  : mysql-community-libs-8.0.19-1.el7.x86_64                     1/6
  Verifying  : mysql-community-libs-compat-8.0.19-1.el7.x86_64              2/6
  Verifying  : mysql-community-client-8.0.19-1.el7.x86_64                   3/6
  Verifying  : mysql-community-common-8.0.19-1.el7.x86_64                   4/6
  Verifying  : mysql-community-server-8.0.19-1.el7.x86_64                   5/6
  Verifying  : 1:mariadb-libs-5.5.64-1.el7.x86_64                           6/6

Installed:
  mysql-community-client.x86_64 0:8.0.19-1.el7
  mysql-community-common.x86_64 0:8.0.19-1.el7
  mysql-community-libs.x86_64 0:8.0.19-1.el7
  mysql-community-libs-compat.x86_64 0:8.0.19-1.el7
  mysql-community-server.x86_64 0:8.0.19-1.el7

Replaced:
  mariadb-libs.x86_64 1:5.5.64-1.el7

Complete!

Comments

Post a Comment

Popular posts from this blog

MySQL Replication on Oracle Cloud’s “Always Free” Compute Instance

Always Free Compute Instance creation on OCI and MySQL Community Server installation Please refer to my previous blog MySQL Installation on Oracle Cloud’s “Always Free” Compute Instance and repeat same step for second instance.In this blog I used one compute Instance as  Master and Other as Slave. MySQL Replication Classic 1.Need to set following System Variable at /etc/my.cnf (Master Host). datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid server_id=1 bind-address=172.0.2.7 master_info_repository=TABLE relay_log_info_repository=TABLE log_bin=master_binlog binlog_format=row Property Value Description server_id 1 On a replication master and each replication slave, you must specify server_id to establish a unique replication ID master_info_repository TABLE The master info log contains status and current configuration informat...
Read more