Scott Stroz talks about "ColdFusion Oracle Cloud Migration with MySQL (from VPS)" in this episode of ColdFusion Alive Podcast with host Michaela Light.

"…And the difference between Oracle clouds version of the manage the managed MySQL database is that in Oracle Cloud, it's Enterprise Edition. So if you are using MySQL heatwave in Oracle Cloud, you're actually using Enterprise Edition".

Show notes What is Oracle Cloud?

Oracle cloud services like AWS, GCP, Azure etc
Servers, Storage, MySQL, AI etc
OCI = Oracle Cloud Infrastructure

How does it differ from AWS, GCP, Azure etc?

Robust always free tier, not CC required
Startups, open source or personal projects
Oracle is the steward behind MySQL community edition
MySQL Heatwave is cloud version of MySQL
- Compare AzureSQL etc
- Managed db
- Enterprise edition performance boosts and more security
- The latest

MySQL

New features - Ben Nadel posts
Open Source version and closed source versions
Caught up with MS-SQL Server
MariaDB fork
- Original MySQL dev lead developer/CTO is Michael "Monty" Widenius
- SQL Server is a 'fork' of Sybase
Docker images
Auto Tuning and DBA
- AI and ML
- Oracle The Automatic Database Diagnostic Monitor (ADDM) provides a holistic tuning solution.

Why cloud hosting?

Ease - no server management, no hardware management
Fast upscale of memory, disk, CPU
Fast scaling of extra servers and spin down too
Ditto failover
CapEx vs OpEx
Small and Enterprise good, Medium less
- 37 signals posts on cloud vs inhouse
Regions - data centers
Patching and security
- Very hard to hack MySQL cloud
Point in time recovery
Easier Disaster Recovery
Pre-problem detection

Why use Oracle Cloud?

Always free tier - 4 VMs, ARM CPU
- Lucee issue on ARM? Fixed with CommandBox
https://www.oracle.com/cloud/free/
Two Oracle Autonomous Databases with powerful tools like Oracle APEX and Oracle SQL Developer
Two AMD Compute VMs
Up to 4 instances of ARM Ampere A1 Compute with 3,000 OCPU hours and 18,000 GB hours per month
Block, Object, and Archive Storage; Load Balancer and data egress; Monitoring and Notifications

Moved from VPS at HostMedia in Europe

Lucee on MySQL

Issues with migration that you solved

Set up MySQL instance (VM)
- Now would just use HeatWave MySQL
Update Datasource in CF Admin
Use CommandBox to launch Lucee

Paramedic experience and development skills

Transferring skills from other careers to developing
Deal with high stress - stay calm, calm others in chaos
Troubleshooting skills - differential diagnosis - keep checking for evidence is true
Intuition on what to do or not to do
Layers of bugs
New keynote
Learning from your mistakes or other people's mistake
- Code reviews
- Opportunity to learn
- Rotate reviewers
- Think bigger picture
- Code reuse
- Open source
Time to go, time to stay

Why are you proud to use CF?

Ortus tools and packages
Node packages
CF community

WWIT to make CF more alive this year?

Mentioned in this episode

Oracle Cloud
Inside MySQL: Sakila Speaks - new podcast, link coming soon
CF Hour
- Dave Ferguson, Scott Stroz and Matt Gifford
CF Suicide, Depression, and Recovery with Jorge Reyes
From near death to better biz leader with Brie Moreau
Forgebox
ITB article
CF Summit article

Bio

Scott Stroz

Developer Advocate for MySQL

20+ Years as Software Developer/Architect

2 Years as Assistant Network Administrator

2 Years as Operations Manager for large Mobile Health System

14 years as a Paramedic.

Specialties:

Web application development with Groovy/Grails, Angular, Vue.js, Micronaut.

Links