• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TeraTech

The ColdFusion Experts: Develop | Secure | Optimize

  • Services
    • Consulting
    • Crash
    • Development
    • Maintenance
    • Modernization
    • Security
  • About Us
  • Testimonials
  • Free Assessment
  • Get in touch!

  • Services
    • Consulting
    • Crash
    • Development
    • Maintenance
    • Modernization
    • Security
  • About Us
  • Testimonials
  • Free Assessment
  • Get in touch!

137 ColdFusion Oracle Cloud Migration with MySQL (from VPS) with Scott Stroz

May 12, 2024 By Michaela Light Leave a Comment

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

Contents

  • Show notes
  • What is Oracle Cloud?
  • How does it differ from AWS, GCP, Azure etc?
  • MySQL
  • Why cloud hosting?
  • Why use Oracle Cloud?
  • Moved from VPS at HostMedia in Europe
  • Issues with migration that you solved
  • Paramedic experience and development skills
  • Why are you proud to use CF?
  • WWIT to make CF more alive this year?
  • Mentioned in this episode
  • Listen to the Audio
  • Bio
  • Links
  • Interview transcript
    • Read more
  • Join the CF Alive revolution

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

Listen to the Audio

https://traffic.libsyn.com/coldfusionalive/ColdFusion_Oracle_Cloud_Migration_with_MySQL_from_VPS_with_Scott_Stroz_Final.mp3

Podcast: Play in new window | Download | Embed

Subscribe: RSS

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

  • Scott Stroz | LinkedIn
  • [email protected] 
  • http://www.oracle.com

Interview transcript

Michaela Light 0:01
Welcome back to the show. Today we're going to be talking about moving your ColdFusion dye into the cloud with Oracle Cloud Migration with Scotts froze, and got it joining us from exotic West Virginia, in the United States of America. And you may not know, Scott, he's been doing cold fusion stuff for years. And he's got some he used to run the CFR podcast with with it, Dave, or who are you running that with? Dave Ferguson? Dave Ferguson? Yeah. And he's the developer advocate for my sequel, which many of the listeners will be using for their database? If they're not still on the dark side with SQL Server? So that was a joke. You said that not me. Yes.

We have complete freedom in this podcast, though.

So and he also has been doing software development for you said 20 plus years. I'm sure you in your bio, I'm sure you've been doing for 25 years.

Scott Stroz 1:00
Not quite, not quite. Also done network administration being an operations manager. And he is also a paramedic. So November's eto, former paramedic, oh, former. I stopped being a paramedic a long time ago. You did. Oh, that's certified anymore.

Michaela Light 1:20
Okay. And as well as cold fusion. You also do things with Groovy and Grails Angular view. Micronauts. I think you'd mentioned Python and all kinds of other Sonos. Yeah, node. So yeah, lots of cool stuff. Lots of experience. This man has. Welcome to the show. Thanks. It's great to be here. So I think we should start with the So speak elephant in the room. What is this Oracle cloud thing? Because I've never heard of it until you mentioned it to me.

Read more

 

Michaela Light is the host of the CF Alive Podcast and has interviewed more than 100 ColdFusion experts. In each interview, she asks "What Would It Take to make CF more alive this year?" The answers still inspire her to continue to write and interview new speakers.

Michaela has been programming in ColdFusion for more than 20 years. She founded TeraTech in 1989. The company specializes in ColdFusion application development, security and optimization. She has also founded the CFUnited Conference and runs the annual State of the CF Union Survey.

 

Join the CF Alive revolution

Discover how we can all make CF more alive, modern and secure this year. Join other ColdFusion developers and managers in the CF Alive Inner Circle today.

  • Get early access to the CF Alive book and videos
  • Be part of a new movement for improving CF's perception in the world.
  • Contribute to the CF Alive revolution
  • Connect with other CF developers and managers
  • There is no cost to membership.
  • Facebook
  • Twitter
  • LinkedIn

Filed Under: CF Alive Podcast

← Previous Post 136 Into The Box 2024 (all the details and speakers) with Jorge Reyes – Transcript
Next Post → 137 ColdFusion Oracle Cloud Migration with MySQL (from VPS) with Scott Stroz – Transcript

Primary Sidebar

Subscribe on iTunes

Popular podcast episodes

  • Revealing ColdFusion 2021 – Rakshith Naresh
  • CF and Angular – Nolan Erck
  • Migrating legacy CFML – Nolan Erck
  • Adobe API manager – Brian Sappey
  • Improve your CFML code – Kai Koenig

CF Alive Best Practices Checklist

Modern ColdFusion development best practices that reduce stress, inefficiency, project lifecycle costs while simultaneously increasing project velocity and innovation.

Get your checklist

Top articles

  • CF Hosting (independent guide)
  • What is Adobe ColdFusion
  • Is Lucee CFML now better than ACF?
  • Is CF dead?
  • Learn CF (comprehensive list of resources)

Recent Posts

  • 141 Into The Box 2025 ColdFusion conference (all the details) with Daniel Garcia – Transcript
  • 141 Into The Box 2025 ColdFusion conference (all the details) with Daniel Garcia
  • 107 ColdFusion 2021 Revealing Details on How it was Created with Rakshith Naresh
  • The Legacy Continues: ColdFusion Summit East Conference Edition
  • 140 BoxLang modern JVM language that runs CFML code (new CFML engine and much more) with Luis Majano and Brad Wood – Transcript

Categories

  • Adobe ColdFusion 11 and older
  • Adobe ColdFusion 2018
  • Adobe ColdFusion 2020 Beta
  • Adobe ColdFusion 2021
  • Adobe ColdFusion 2023
  • Adobe ColdFusion 2024
  • Adobe ColdFusion 2025
  • Adobe ColdFusion Developer week
  • Adobe ColdFusion Project Stratus
  • Adobe ColdFusion Summit
  • AWS
  • BoxLang
  • CF Alive
  • CF Alive Podcast
  • CF Camp
  • CF Tags
  • CF Vs. Other Languages
  • CFEclipse
  • CFML
  • CFML Open- Source
  • CFUnited
  • ColdBox
  • ColdFusion and other news
  • ColdFusion Community
  • ColdFusion Conference
  • ColdFusion Consulting
  • ColdFusion Developer
  • ColdFusion Development
  • ColdFusion Hosting
  • ColdFusion Maintenance
  • ColdFusion Performance Tuning
  • ColdFusion Projects
  • ColdFusion Roadmap
  • ColdFusion Security
  • ColdFusion Training
  • ColdFusion's AI
  • CommandBox
  • Docker
  • Fixinator
  • Frameworks
  • Fusebox
  • FusionReactor
  • IntoTheBox Conference
  • Java
  • JavaScript
  • JVM
  • Learn CFML
  • Learn ColdFusion
  • Legacy Code
  • Load Testing
  • Lucee
  • Mindmapping
  • MockBox
  • Modernize ColdFusion
  • Ortus Developer Week
  • Ortus Roadshow
  • Server Crash
  • Server Software
  • Server Tuning
  • SQL
  • Survey
  • Survey results
  • TestBox
  • Transcript
  • Webinar
  • Women in Tech

TeraTech

  • About Us
  • Contact

Services

  • Free assessment
  • Consulting
  • Crash
  • Development
  • Maintenance
  • Modernization
  • Security
  • Case Studies

Resources

  • CF Alive Book
  • CF Alive Podcast
    • Podcast Guest Schedule
  • TeraTech Blog
  • CF Alive resources
  • CF e-course
  • CF best practice checklist

Community

  • CF Alive
  • CF Inner Circle
  • CF Facebook Group

TeraTech Inc
451 Hungerford Drive Suite 119
Rockville, MD 20850

Tel : +1 (301) 424 3903
Fax: +1 (301) 762 8185

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Pinterest Follow us on YouTube



Copyright © 1998–2025 TeraTech Inc. All rights Reserved. Privacy Policy.