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”.
https://youtu.be/g9fce9kEeq8
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
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
scott.stroz@oracle.com
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.
