Lift and Shift your Zabbix to OCIwith MySQL Database Service

Vittorio Cioe
Senior Solution EngineerMySQL
vittorio.cioe@oracle.com

Safe harbor statement
The following is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, orfunctionality, and should not be relied upon in making purchasing decisions. The development, release,timing, and pricing of any features or functionality described for Oracle’s products may change and remains at thesole discretion of Oracle Corporation.

2

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

whoami• Linux and MySQL user since ≈ 2006
• Working at Oracle/MySQL since 2017
(lot of travel => lot of fun!)• Regularly speaking at conferences• Previously working in the Security and Digital Transformation (API)space• From Italy but based in Warsaw• Love movies, travelling, cooking...

3

Agenda1

Moving to the cloud2

Planning the migration

3

Migrating the application

4

Migrating the database to MySQL Database Service5

Next Steps

4

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Moving to the cloud5

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Data is moving to the Cloud49%of the world’s data willreside in public cloudenvironments by 2025

Source: IDC

6

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Oracle’s Public Cloud Presence#4

Gartner Magic Quadrant“Cloud Infrastructure” Ranking
Based on “Completeness of Vision” and “Ability to Execute”

26 Regions Live, 12+ Planned
https://www.zdnet.com/article/google-cloud-gains-in-gartners-2019-cloud-infrastructure-magic-quadrant/

Copyright © 2020 Oracle and/or its affiliates.

24+ Industry and Regional Certifications

Moving Zabbix to Oracle Cloud1

Get always the latest updates ontechnology stack, minimizing
donwtimes and service windows

2

Convert the time you spend managing
your monitoring platform in time youspend monitoring your platforms

3

Leaverage the most secure andcost-effective cloud platform inthe market

Planning themigration

9Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Requirements: What do I need to keep in mind?
• Server Configuration• Database• Network topology (Zabbix
Clients, Zabbix Proxies, etc)

Interface}

Clients / Proxies

ServerDatabase

Requirements: What do I need to set up in my OCI tenancy?

MySQL
Database
System11Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

ComputeInstancefor Zabbix
ServerStorage
for Databaseand Backup

Networking/ LoadBalancing

Oracle Cloud target architecture for Zabbix
ORACLE CLOUD INFRASTRUCTURE DATACENTER
Availability Domain 1
Regional
Subnet A(Public)
Zabbixclients/proxies

VPN

Availability Domain 3• Cloud Networking
LoadBalancer
ActiveInternetGatewayRegional
Subnet B(Private)

Availability Domain 2

Required Components:• Zabbix Cloud Image

Standby• MySQL Database
ServiceApplication
Tier

Zabbix Server

Zabbix Server• VPN Connection forclient/proxies

DynamicRouting
Gateway

Database
Tier
MySQL DBSystem

VCNOracle Cloud target architecture for Zabbix: a simpler solution

ORACLE CLOUD INFRASTRUCTURE DATACENTER
Availability Domain 1
Zabbixclients/proxies

SSL/TLS
SSH

Subnet A
10.0.30.0/24

Internet
Gateway

BastionMySQL Router

Zabbix Server

Subnet B
10.0.30.0/24

Database

MySQL
DB System

VCN

Migrating theApplication to OracleCloud14

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Deploy the Zabbix Application
Before you begin:• Set up tenancy and compartments• Set up cloud networking - public and private VCN
Deploy Zabbix:• One click deployment vs DIY:
Use the official Zabbix OCI Marketplace Image...or deploy an OCI Compute Instance and install manually• Choose the desired Compute “shape” during deployment
Configuration:• Start the instance• Edit the config file
• Point to the database...Done!

ComputeCompute services forany enterprise usecase16Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Bare Metal

VMs

Containers

Functions

Instance isolation
Highest IOPSHigh throughput
Low latency

Security- hardened
hypervisor
Flexible sizing
Dense IO andDedicated hostoptions

Bare metal
performance
Self-healing clusters

Pay only for usage
ServerlessContainer-native
Open source

AMD EPYC

Intel Xeon

NVIDIA GPUs

Local Attached Storage

Remote Attached Storage

NVMe SSDs
Up to 51.2 TB
Millions of IOPS

NVMe Block Volumes up to 1PB
32 TB / volume
75 IOPS / GBMigrating theDatabase to MySQLDatabase Service

17

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

MySQL Database Service
100% developed, managed, and supported by the MySQL teamEasy

SecureEnterprise-Ready• Fully Managed Database Service• Data Protection• Built on MySQL Enterprise Edition• Instant Provisioning• Advanced security• On Premises Compatibility• Latest Features• Latest Security Updates• Built on Gen 2 Cloud
Infrastructure

18

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Considerations before your migration
Before you begin:• Check your MySQL 8.0 compatibility• Check your database size
• Plan a service window
High-level migration plan:
1. Setup cloud networking
2. Setup your (on-prem) networking secure connection
3. Create MySQL Database Service DB-System with storage
4. Move the data MySQL Shell Dump & Load utility

Easily create MySQL instances withjust a few clicks•

Create customized configuration•

Start the creation of DB system•

Select Virtual Cloud Network (VCN) and Subnet toplace your MySQL endpoint•

Select pre-defined MySQL instances or createcustomized instances for your workload•

Shape for the DB System (CPU and RAM) willautomatically be set•

Select size of the storage for data and backup•Create backup policy or accept the default

20

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

MySQL Shell Upgrade Checker Utility
util.checkForServerUpgrade()Loading the data
MySQL Shell Dump & Load - NEW!
Amazon, Google, Microsoft, etc.

Oracle Cloud Infrastructure
Gen2

MySQL Database ServiceMySQL
On-Premise

MySQL Shell Dump & Load

Next Steps

23

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

Test Drive MySQLDatabase Service For
Free Today
Get $300 in cloud credits
and try MySQL Database Service and other services in OCI
free for 30 days.
Get in touch with us!

Questions?

vittorio.cioe@oracle.com