How to run MySQL Enterprise Edition on Oracle Cloud Infrastructure from Marketplace ?

 Deploy MySQL Enterprise Edition with OCI Market Place Application

In this blog we will look into the process to deploy MySQL Enterprise Edition in to Oracle Cloud Infrastructure.

In this blog we will discuss the below agenda

1. Introduction about MySQL EE and OCI Market place

2. Deploy MySQL EE into Oracle Cloud Infrastructure

3. Accessing MySQL database from On-premises.

4. Licensing/Purchase model of using MySQL EE from OCI marketplace

5. Conclusion

Introduction

If you wanted to run MySQL Enterprise Edition (EE) in Oracle Cloud Compute Instance (VM) then generally what we do is first download the MySQL EE binaries from the oracle website and manually push to the Oracle Cloud Instance where, MySQL EE needed to be installed and follow the steps to get installed.

Another approach is going with MySQL EE image from Oracle Cloud Marketplace.

It automates this manual process to download the binaries and push to oracle cloud and then follow the step to install the MySQL binaries, it is pre-loaded package which by default install below software

 MySQL Server EE

 MySQL Enterprise Backup

 MySQL Shell

 MySQL Router

 MySQL Enterprise Thread pool

The MySQL Enterprise Edition Marketplace Application is an OCI compute instance, running Oracle Linux 7.7, with MySQL EE 8.0.x.

The MySQL EE installation on the deployed image is similar to the RPM installation.

This solutions is user-managed, meaning you are responsible for upgrades and maintenance.

MySQL Enterprise Edition version 8.0 is available in OCI Marketplace. MySQL 5.7 nor 5.6 are not available in Oracle Cloud Infrastructure Marketplace. If the user needs previous versions, you need to create an OCI Compute Linux, download and install MySQL EE by themselves, similar to on-prem.

What is Oracle Cloud Infrastructure Marketplace?

Oracle Cloud Infrastructure Marketplace is an online store that offers solution specifically for customers of Oracle Cloud Infrastructure.

you can find listings for two types of solutions from Oracle and trusted partners:

1. Image

Images are templates of virtual hard drives that determine the operating system and software to run on an instance. You can deploy image listings on an Oracle Cloud Infrastructure Compute instance.

2. Stack

Stacks represent definitions of groups of Oracle Cloud Infrastructure resources that you can act on as a group.

More info:- https://docs.oracle.com/en-us/iaas/Content/Marketplace/Concepts/marketoverview.htm

What is MySQL Enterprise Edition?

MySQL Enterprise Edition is a commercial product. Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise Edition includes the following components designed to provide monitoring and online backup, as well as improved security and scalability, high availability.

More info:- https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise.html

Deploy MySQL EE into Oracle Cloud Infrastructure

Prerequisite:-

 Make sure You have have create an account with Oracle Cloud.

 Make sure virtual cloud network(VCN) is created

https://docs.oracle.com/en-us/iaas/Content/GSG/Tasks/creatingnetwork.htm

Step 1:- Create compute instance 

Step 2 : Change the shape based on the requirements(in terms of CPU , RAM )

Step 03:-Configure the Network

Step 04:- Add SSH key files

Step 05 :- Create the Instance

Step 06:- View the created Instance

Step 07:- Note down the Instance details

Instance Public IP : 140.238.166.106

Instance User Name:   opc

Instance Private IP: 10.0.0.92

MySQL Host Name: localhost

MySQL UserName: root

MySQL Port: 3306

Step 08:- Let’s connect the Instance from On-premises network using Putty

Make sure putty is installed in your local machine, if not then please install by downloading from the web links:- https://www.putty.org/

Enter the correct public IP address as well as .ppk file to connect , refer below screenshot .

When you click on OPEN, you will see that you are connected to Oracle Cloud Infrastructure.

Step 09:- Get the temporary password

$sudo grep 'temporary password' /var/log/mysqld.log

Step 10:- Login to MySQL DB

Step 11:- Change the Password for the root user from temporary password to NEW password

alter user root@'localhost' identified by 'MySQL8.0';

Step 12:- Next is you can ready to execute the commands with MySQL Enterprise Edition

That’s it.

You can also connect MySQL Server using MySQL shell utility

So you may noticed that I have not install manually any mysql clients , libraries its dependencies , MySQL shell because it is bundled and available as pre-installed image at Oracle Cloud Marketplace.

It’s easy to plug in and play with MySQL Enterprise Edition.

More info available at MySQL Website:-

https://dev.mysql.com/doc/refman/8.0/en/mysql-oci-marketplace.html

Licensing Model

This is a BYOL (bring your own license) product with there are additional fees for the infrastructure usage."

Hence,

Price of MySQL EE OCI Marketplace = Price of MySQL EE + Price of Oracle Cloud Infrastructure VM usage

Price for MySQL EE goes via MySQL Sales , you can talk with sales to get the details pricing matrix(https://www.mysql.com/about/contact/).

More info :- https://www.mysql.com/products/

Price of Oracle Cloud Infrastructure VM usage, it depends on kind of shape (comprises of OCPU, RAM, Storage) you are going to configured to run MySQL Enterprise Edition (EE).

You can calculate using OCI cost estimator: - https://www.oracle.com/in/cloud/cost-estimator.html

If you are bringing your “on-premise license”, so this offering is available at no additional charge. Fees for usage of Oracle infrastructure resources, such as compute instances, are charged separately and based on the rate of usage. Learn about pricing" linked to

https://www.oracle.com/cloud/compute/pricing.html

Conclusion:-

MySQL Enterprise Edition include most comprehensive set of advanced features (solutions for scalability, performance, high availability, securities), management tools (unified monitoring and hot/online backup) and technical supports(24*7 support backed by MySQL engineering team)

It’s easy to deploy on private cloud , public cloud and available as “Managed Service” at Oracle Cloud named as MySQL Database Service (MDS).

MySQL Enterprise Edition is BYOL product and it is annual subscription product which has to be renewed annually.