137 ColdFusion Oracle Cloud Migration with MySQL (from VPS) with Scott Stroz
Release Date: 04/17/2024
140 BoxLang modern JVM language that runs CFML code (new CFML engine and much more) with Luis Majano and Brad Wood
ColdFusion Alive
Luis Majano and Brad Wood talk about “BoxLang modern JVM language that runs CFML code (new CFML engine and much more)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “…BX is the acronym we use a lot like our file extensions are analogous to the cold fusion file extensions. So a CFM file, we call that bxm For box Lang markup, CMS, which Lucy six had his support for, which is cold fusion script”. Show notes What is BoxLang? A new language for the JVM that includes CFML Inspired by cool CF, Groovy, Rust, Go, PHP etc Compiles into Java byte code, just like CF A...
info_outline
139 All About Adobe ColdFusion 2023 (Part 2: PDF, CCS, SSO, perf, security) with Mark Takata
ColdFusion Alive
Mark Takata talks about “All About Adobe ColdFusion 2023 (Part 2: PDF, CCS, SSO, perf, security)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “…So we decided to build this thing called CCS central configuration server. And it runs at the command line, basically, and allows you to control your servers from a central location.”. Show notes Enhanced HTML-to-PDF Conversion New HTML-to-PDF conversion engine Supports new CSS features for pixel perfect PDFs Imbed audio, video and SVG Old tags features for manipulation of PDFs and forms etc still work Increased...
info_outline
138 All About Adobe ColdFusion 2023 (Part 1: containers, GCP, GraphQL, JWT) with Mark Takata
ColdFusion Alive
Mark Takata talks about “All About Adobe ColdFusion 2023 (Part 1: containers, GCP, GraphQL, JWT)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “…So we support Google's version of Pub Sub. And it's fairly simple. You know, you've got a you've got someone creating a message. You've got a subscriber that you can create to listen to that message, messages of contact message that I gaze at It just have, you know, timestamps and things like that”. Show notes In this episode, we look at all the Adobe ColdFusion 2023 new features with the Adobe CF evangelist, Mark...
info_outline
137 ColdFusion Oracle Cloud Migration with MySQL (from VPS) with Scott Stroz
ColdFusion Alive
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...
info_outline
136 Into The Box 2024 (all the details and speakers) with Jorge Reyes
ColdFusion Alive
Jorge Reyes talks about “Into The Box 2024 (all the details and speakers)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “...But it's just those aha moments where, Hey, I didn't know you could do that. So you can actually, when you go back home and do your job, then you can actually worry about looking more into it and implementing it. So that's kind of the idea behind all the sessions, actually.”. Show notes What is Into The Box conference? Is it only for Box products topics? No - lots of CF topics, not just Box products Do not have to use ColdBox framework...
info_outline
135 Lucee Migration (8 CFML code moving tips) with Mike Chytráček
ColdFusion Alive
Mike Chytráček talks about “Lucee Migration (8 CFML code moving tips)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “...but we had migrated everything over and all new clients went to Lucy all new applications went to Lucy. And within I'd say maybe two years, we had probably 95% of our clients might get it off, some clients still required it”. Show notes What is Lucee? Why did you migrate to Lucee? 2018 switch from ACF to Lucee Adobe Licensing fishing call and new licensing model per application with $10ks extra cost. “SaaS” due to Mura Per core...
info_outline
134 ColdFusion Legacy app - Is a Refactor Better than a Rewrite? with Denny Springle
ColdFusion Alive
Denny Springle talks about “ColdFusion Legacy app - Is a Refactor Better than a Rewrite?” in this episode of ColdFusion Alive Podcast with host Michaela Light. “Refactoring is a way of taking in modernizing code that already exists, and bring it up to speed with generally modern best development practices. So you know, some object orientation, data modeling type of thing, as well as you know, either using a framework or building an application framework yourself, that hits all of the major obstacles that are that a framework will do for you generally.” Show notes Why is refactoring vs...
info_outline
133 GitHub Copilot & AI-Assisted Coding (Unlocking ColdFusion's AI Potential) with Monte Chan
ColdFusion Alive
Monte Chan talks about “GitHub Copilot & AI-Assisted Coding (Unlocking ColdFusion's AI Potential)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “It is an AI pair programming tool. So this helps test your programming that basically, there's another person but in this case is a AI tool, if you will, so but you will be doing most of the typing. But then that will also give you some code suggestions, if you will. And to help you with coding. So sometimes can be a short one liner, or could be one whole block of codes. So you can save a lot of typing.” Show notes...
info_outline
132 ColdFusion Hosting options with Dakota Clum and Ryan Brown
ColdFusion Alive
Dakota Clum and Ryan Brown talk about “ColdFusion Hosting options (what to consider when choosing a CF host)” in this episode of ColdFusion Alive Podcast with host Michaela Light. “……you shouldn't have to be trapped with one hosting option or one provider. So when we think about the AWS are the answers of the world, when there's a need for those specific resources are specific tooling and libraries, we want to be able to support that. So, to your point, there's no kind of lock in, or anything like that you shouldn't do one or the other, you should keep all the options open to you.”...
info_outline
131 Lucee 6 with Gert Franz, Charlie Arehart, Ben Nadel, Mark Drew, Zac Spitzer
ColdFusion Alive
Gert Franz, Charlie Arehart, Ben Nadel, Mark Drew, and Zac Spitzer talk about “Lucee 6” in this episode of ColdFusion Alive Podcast with host Michaela Light. “Welcome to the podcast. We’re coming here live from CF camp in Munich, Germany. And we are going to be talking about Lucee 6, the new release of Lucee CFML. And we’ve got some amazing experts here. Mark Drew who's done a lot of Lucee coding at distro kid. Then we’ve got Charlie Erehart, the ColdFusion troubleshooting expert giving an independent view on Lucee. Then we’ve got Ben Nadal all the way from New York City. And...
info_outlineScott 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.