AWS to Oracle Cloud Migration Gemma Wood 1
About Me • Gemma Wood Co-Founder of Cavanti, responsible for product development • Oracle Developer since 1995, initially Oracle E-Business Suite. • Focused exclusively on Oracle APEX for the past 7 years Previously worked for Oracle, Accenture Enkitec and have been an • independent consultant for the majority of my career Originally from London, I spent 20 years in the United States. Now • based in the Algarve, Portugal gemma@cavanti.com @gemmawood 2 Confidential 2
About Cavanti Software as a Service company • Based in San Jose, California • Founded in 2012 • 300+ customers in 15 countries • Provide Practice Management solutions to animal practitioners • (veterinarians, chiropractors, physiotherapists, massage therapists, etc.) 24/7 availability • e-DBA/Red Stack/Data Intensity client since founded • 3 Confidential 3
Our Journey Our environment • Oracle DB, Oracle APEX (now running ORDS to use Rest services) • Cavanti was a bootstrapped start-up – Price was a big factor on day 1! • • Matured from a start-up to a ”real” business 4 Confidential 4
Why Amazon RDS? Pay as you go to avoid any upfront hardware or licensing costs • • Gave us own Oracle “database” on shared instance Solution worked pretty well • Some constraints (no file system access, no data pump, no external • tables, no sys access, sharing hardware resources with other tenants, etc.) Great to get us started • 5 Confidential 5
Why Move From AWS? Needed to start development on a new product • • Needed some of the missing Oracle features that AWS RDS did not support • Grown into a real business and needed our own non shared environment so we had control of patching, resource allocation, configuration, etc. Wanted own VMs, but cost was prohibitive on AWS (mainly from a • licensing perspective) 6 Confidential 6
Oracle Cloud Data Intensity recommended running Oracle DBCS Standard • Technical Benefits Commercial benefits! • Dedicated Virtual Machines so we • Pricing was extremely competitive and would be in full control of our own offered massive savings over running destiny VM’s on AWS • Oracle DBCS would give us all the • We can scale up as needed with no features we were missing on AWS upfront costs – great for a still growing • Full control over ORDS listener etc. business 7 Confidential 7
Concerns – The (Brutally) Honest View • Immediate reaction was skepticism! • Experience several years ago with the Oracle Cloud was not great. Environment was unavailable 45% during a 30 day trial period! • General feedback over the last couple of years was that the Oracle Cloud was not production ready Bad experiences with Oracle in the past from a commercial and support perspective - Concerned • that Oracle could change the game once we were on board, hike prices, etc. Felt like we didn’t have a great deal of choice! • Didn’t have the budget for VMs on AWS • Same was really applicable if we looked at other cloud providers as licensing costs were the • killer • Reluctantly agreed to re-evaluate the Oracle Cloud 8 Confidential 8
Migration • Data Intensity handled provisioning of the environment Data Intensity dealt with Oracle with was fantastic! • • Cavanti took care of migrating the application • Data Intensity and Cavanti worked together on the data migration 9 Confidential 9
Issues Faced Tried to migrate from Oracle 12.1 to Oracle 12.2 as part of the • migration Oracle 12.2 was not production ready at the time so reverted back to • Oracle 12.1 • Cavanti had 120GB+ of fairly static blob data and exporting/importing this was going to result in an outage of 7+ hours. Not feasible in a 24/7 environment We imported blob data one day and then imported changed blob data • (and non blob data) when we went live Outage was less than 2 hours • 10 Confidential 10
Overall Experience Fantastic! We were surprisingly happy with what we saw! • The Oracle Cloud had grown up! • Live now for 7 months. Environment has been very stable – 100% • uptime! Got everything we wanted • Subsequently provisioned a second Virtual Machine running Oracle • 12.2 and Oracle APEX 5.1 for development of a new product Data Intensity provide managed services of the environment and • subsequently deal with Oracle Support on any issues 11 Confidential 11
Lessons Learnt • Recently tried to “kick the tyres” of Oracle Exadata Express on the Oracle Cloud and provisioned the environment directly with Oracle – Big mistake! Working with Data Intensity was once again a fantastic experience. This was • highlighted further by my “kicking the tyres” experience with Oracle! The combination of Data Intensity and the Oracle Cloud is perfect • • You get extremely competitive pricing from Oracle as they are playing catch up with the other cloud providers • You get excellent service and support from Data Intensity who do a great job at managing your environment and at dealing with Oracle on your behalf 12 Confidential 12
One More Thing… Oracle Application Express Plug! • Oracle’s browser-based high productivity application development platform Fully supported, no-cost feature of all Oracle databases (Oracle Cloud, • on-premises, other clouds) • Rapidly build beautiful, responsive web applications out-of-the box Extend with small amount of SQL, PL/SQL, JavaScript, CSS or HTML • Scales to tens of thousands of users • • Hundreds of thousands of developers. Very active development community, including the APEX Development team #orclapex https://apex.oracle.com - Sign up for free development service • 13 Confidential 13
Recommend
More recommend
